set variable to query

[Rick Pritchett]

I am trying to set a variable to the value returned by the following query.

Topic

[Tom Rioux]

I’m pretty much a newbie with Sqlite….I’ve only built one but it works okay…

Are you sure your command is working that is connecting you to your database?  Try calling it with the catch command…

catch {sqlite DBCMD mem_fin}

then check for errors connecting to the database…

catch {DBCMD errorcode} ecode

It should return a 1 or 0 (I think) in the variable ecode to let you know if you are connected.

[Author]

Replies