Invalid Connection ID SQLite

[jacque]

In this command: put pDatabaseID into sDatabaseID_med

It assumes the variable is a script local named sDatabaseID_med. Have you declared that at the top of the script? I don't think the problem is in the app installation, this sort of thing is almost always a script error.

[SkinnyKenny]

I think I figured out what the issue is. I was adding a "," after revExecuteSQL and there should not be one. GEEEEEEZ!

"revExecuteSQL, tDatabaseID, tSQL"

[Klaus]

Glad you could solve your problem!

Hint:
If you do not have an ELSE case:
...

Code: Select all

if this_or_that then
  do this
else

end if
...

there is no need to write ELSE

Code: Select all

...
if this_or_that then
  do this
end if
...

[SkinnyKenny]

Great tip! I just assumed you had to include the entire if/else format....I am just used to writing it that way or I just use a switch. Old habits die hard! Thanks for all your help everyone and especially you Klaus!