Frantz
You are putting the result from revOpenDatabase() into tConID, but later on
with revdb_querylist() you are using g_ConID - does g_ConID hold the same
value as tConID?
Dave
-
Some are born coders, some achieve coding, and some have coding thrust upon
them. - William Shakespeare
Good catch, missed that. I think, though, that if you specify an invalid
connection id, you get a runtime script error rather than the database
error he's getting back.
That's another thing that really should be changed so it returns an error
in the connection id instead of a run time error.
Frantz,
Let's see if we get to the bottom of this.
First: If the db does not exist SQLite will create a blank one. This is the
good news! You know that your DB code is working.
You can always check if your real db is open by making sure one or more of
your tables is returned by the
Sounds like the path to your db is wrong. LC happily creates an empty file
for you which is not even formatted as an sqlite db! I've always thought
that was flat out wrong.
I would check that your db file exists before calling revdatabaseopen with
the exists() function.
Pete
lcSQL Software
On