LiveCode Forums.

Hi I'm a new user, I am trying SQLilesampler.rev I get to page 9 connecting to SQLite I click on the button connecting to AppREg it works I can see the file, I click on the disconnect button it responds that is it disconnected, I tried to delete database file button and it does not remove the file.

I go to the next screen create tables I click on create table users button and I get an error, button "CREATE TABLE users": execution error at line n/a (External handler: exception) near "revdberr,invalid connection id" I have not made any modifications or changes to the sample application.

This is the line of code that is highlighted when I see the script editor.

revExecuteSQL gConID, tSQL

I look in the application browser and I do not see "revExecuteSQL" in the list. Am I missing a setting or downloading something to my live code its version 5.5.1

Any help would be appreciated thank you Gary

If the last thing you did before leaving the preceeding screen is delete the database, then there is no database to use when you get to the next screen so you get an invalid connection id error.

Go back to the previous screen and "connect" to the db and it will re-create the file.
Then go to the next card and continue on from there.

Even if you are just disconnected and the file is there, you'll have to go back, connect, then continue on.

Thank you for the help
It makes good sense if I disconnect from the database I can't add a table.
Did not think it through,the code needs some error checking I think I will play with that.

Thanks again