[V4MD] tableName variable query

[Ruslan Zasukhin]

On 6/6/05 10:02 AM, "info at vallemediatime.com" <info at vallemediatime.com>
wrote:

Hi Paolo,

> I need to know how to write in a SQL query the tableName as variable

> -- query = "SELECT RecID, * from STUDENTS" -- this works


> -- Look here: this don't works...
> query = "SELECT RecID, * from '" & TableName & "'"
> 
> -- ...and give me a alert "unespected token: STUDENTSI"

Right, look on query which works.
You do NOT have single quotes around STUDENTS

So why you have them when you use concat ?
Should be as

     query = "SELECT RecID, * from " & TableName

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]