At 05/04/2002 04:42 PM, you wrote:

>Hi all,
>Why can I not execute this query? I get unknown table name error. but if I
>replace the params with the values it's ok. what am I missing?

I forgot to mention the same thing goes for the ORDER BY part of the
statement. Parameters are mainly to be used in the WHERE clause. I know
they can be used for input parameters of stored procedures used in the FROM
clause.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)