sp calls

  • Thread starter Thread starter Gary Miller
  • Start date Start date
G

Gary Miller

I have taken over an ADP project that someone else has done.
I have found that there is criteria on the passed variables
in stored procedures that uses the Access terminology to
pass form variables ie...

@ID nvarchar(50) = 'Forms!frmClients!Id'

Is this a valid approach or would this bomb with SQL Server
2000?

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
GM> I have taken over an ADP project that someone else
GM> has done. I have found that there is criteria on
GM> the passed variables in stored procedures that
GM> uses the Access terminology to pass form variables
GM> ie...

GM> @ID nvarchar(50) = 'Forms!frmClients!Id'

GM> Is this a valid approach or would this bomb with
GM> SQL Server 2000?

is this specified in Access or in a stored procedure on the server?

This might be specified in property Input Parameters of the form bound to a
stored procedure with parameter @ID, however without the single quotes


Vadim
 
Vadim,

It seems just to be in the sp on the server. There is
nothing in the form InputParameters at all. Here is a sample
of one of these...

ALTER FUNCTION dbo.fn_ExpectedClose

(@DayMin nvarchar(50) = '[Forms]![frm_MainForm]![DayMin]',

@DayMax nvarchar(50) = '[Forms]![frm_MainForm]![DayMax]',

@REOWorldSpecialist nvarchar(50))

RETURNS TABLE

AS

RETURN ( SELECT TOP 100 PERCENT
dbo.vw_MainForm_Active.LoanNumber,

dbo.vw_MainForm_Active.PropertyAddress + N', ' +
dbo.vw_MainForm_Active.PropertyCity + N', ' +
dbo.vw_MainForm_Active.PropertySt + N', ' +
dbo.vw_MainForm_Active.PropertyZip

AS FullAddress, dbo.vw_MainForm_Active.BrokerAssign,
dbo.Directory.Email AS ListAgentEmail

FROM dbo.vw_MainForm_Active LEFT OUTER JOIN

dbo.Directory ON dbo.vw_MainForm_Active.BrokerAssign =
dbo.Directory.Contact

WHERE (dbo.Directory.Email IS NOT NULL) AND
(dbo.vw_MainForm_Active.REOEscrow = @REOWorldSpecialist) AND

(dbo.vw_MainForm_Active.DaysToClose >= @DayMin) AND
(dbo.vw_MainForm_Active.DaysToClose <= @DayMax)

ORDER BY dbo.vw_MainForm_Active.DaysToClose )


--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
GM> It seems just to be in the sp on the server.

No, I don't see how it might work. Even if it reflected some undocumented
trick of Access "cooperating" with sql server, it still would be very bad
design - server code in fact depending on the client.

Vadim
 
Back
Top