[V4MD] tableName variable query
info at vallemediatime.com
info at vallemediatime.com
Mon Jun 6 09:02:29 CDT 2005
Hi Ruslan.
I need to know how to write in a SQL query the tableName as variable
e.g
global gCursor
on mBuild_gCursor me, Target, fieldNum, fieldPrefix, TableName
gCursor = 0
go Target -- ok
put TableName
-- "STUDENTS"
-- 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"
gCursor = gDb.sqlSelect(query, #kServer, #kReadWrite, #kRandom)
... [cut]
Thanks Paolo
More information about the Valentina
mailing list