Hi

Im using a data report in vb6.  Now i want to use a parameter in my select from... string.  It works fine if i place the parameter after WHERE so : SELECT * FROM TABLENAME WHERE id=?  The ? is defined as a parameter.  Now if I use the following SELECT * from ? WHERE ID=1 it doesnt work anymore.  Anybody any idea why?

Grtz

Hi ivoke,
A parameter is a parameter - the value that you are searching for in a field in a table. You cannot use it to represent the actual table. If you want to change the table from which you are selecting data then use a string variable.

EG
Dim strTableName as String

"SELECT * FROM " & strTableName & " WHERE ID=1"



____________________________
multi-tasking - the ability to hang more than one app. at the same time.

Ok

Thx

Ivoke