query - parameter problem

  • Thread starter Thread starter Tom S
  • Start date Start date
T

Tom S

Because the SQL I've written for a query calls on a database Proc., it can't
be displayed graphically. Because of this, it won't let me use
paramaters.... any suggestions on how to call a db. proc. and still use
parameters?
 
You could try using a question mark, e.g.:

SELECT Invoices.InvID, Invoices.CustID, Invoices.InvDate
FROM Invoices Invoices
WHERE (Invoices.InvDate>?)
 
I did this, but since the SQL can't be displayed graphically (one of my
select statements is not a column in a table, it's a call to a db proc), it
won't let me use the question marks.
 
Back
Top