LiveCode Forums.

I am trying to use this in my application but when I issue
I get an error message that says:

stack "ApplicationName": execution error at line 214 (Handler: can't find handler) near "revQueryDatabase", char 1

gDatabaseID has a value of 6
tSQL has a value of Select * from Income_Categories


Has anyone ran into this before

I figured it out. The command returns a recordSetID then I use another Database Command to get the results from the record set. I ma not used to these extra steps. But it was a good learning experience.

Hi Graham,

the problem was that you used the FUNCTION -> revQueryDataBase() like a HANDLER!
Therefore the error -> can't find HANDLER...

Correct use would be:
...
PUT revQueryDatabase(gDatabaseID, tSQL) into SomeVariable
...

But I think you were looking for -> revDataFromQuery(()
That will reaturn the REAL data from the database


Best

Klaus