revQueryDatabase inquiry

[gpearson]

I am trying to use this in my application but when I issue

Code: Select all

revQueryDatabase(gDatabaseID, tSQL)

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

[gpearson]

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.

[Klaus]

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