Getting placeholder variables to work in revDataFromQuery

[Quentin Brown]

I am trying to get a list of columns in a SQLite table - chosen by the user from a list of Tables in the database.

The following works fine:

Code: Select all

function ListTableColumns pTable
   local tColumnList, tSelectedTable
   put pTable into tSelectedTable
   databaseConnect
   put revDataFromQuery(comma, return, GetDatabaseID(), "pragma table_info(Projects);") into tColumnList 
   return tColumnList
end ListTableColumns

Above I manually and explicitly entered the Table name into the SQL Query

But adding a placeholder Variable within the SQL Query as follows results in a revdberr,Database Error: near ":1": syntax error message.

Code: Select all

function ListTableColumns pTable
   local tColumnList, tSelectedTable
   put pTable into tSelectedTable
   databaseConnect
   put revDataFromQuery(comma, return, GetDatabaseID(), "pragma table_info(:1);", tSelectedTable) into tColumnList 
   return tColumnList
end ListTableColumns

Where am I going wrong?

Any help would be very much appreciated...

Quentin.

[elanorb]

Hi Quentin

I think it might just be that you need quotation marks around your variable name e.g.

put revDataFromQuery(comma, return, GetDatabaseID(), "pragma table_info(:1);", "tSelectedTable") into tColumnList

I haven't set up a test so this may not work but syntax wise as least that's how it should be.

Kind regards

Elanor

[Quentin Brown]

Brilliant. That did the trick, thanks.
I was wondering if there was some kind of syntax I was getting wrong. I guess I am too used to developing in Filemaker where only explicit values require quotes and variables don't use them or they are parsed as if explicit rather than being replaced with the contents of the variable! Good to know it doesn't work like that in Livecode.

Kind Regards,

Quentin.