stored procedures again

  • Thread starter Thread starter Diavolo
  • Start date Start date
D

Diavolo

hello, sorry for my english, i use adp project that connect to sql server 2000

i build stored procedure, but it not parsing expresions like: Forms![skolos]![nuo], it use that exacly, not value, i need that stored procedure parse this, i want input parameters specify in form
 
It can't be done. Stored Procedures run on the server: they know nothing
about values on forms that are open on your client.

What you'll have to do is write code that redefines the SQL associated with
your pass-through query, so that the values of the form textboxes are
actually written into the SQL.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Diavolo said:
hello, sorry for my english, i use adp project that connect to sql server 2000

i build stored procedure, but it not parsing expresions like:
Click to expand...
Forms![skolos]![nuo], it use that exacly, not value, i need that stored
procedure parse this, i want input parameters specify in form
 
Back
Top