[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