Parameter query?

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

Is it possible to have a parameter user-prompt in an .adp stored proc or
query? (and if so....how?)

Many thanks.....Jason
 
It's quite unconventional, but yes it is possible.
Set inputparameters property for your form to something like:
@CatID=[Which CatID would you like to see:]

and have a sproc like this:
create procedure CategoriesByCatID
(@CatID int)
as
select * from Categories
where CategoryID=@CatID

-Tom.
 
Back
Top