#How to read sqlite database code

How do I send an email from my mobile device?.How do I Develop Cross-Platform in LiveCode?.The Basics: How do I Create Hello World on Android?.An old Hypercard/Supercard user who is happy to find LiveCode. This may have been obvious to more experienced users, but I wouldn't count a novice like me being able to see it immediately.Р”Р„nyway, thanks for so much that is right and does work. I post this comment in hopes of helping anyone else attempting this tutorial avoid this particular headache. I managed to figure this out on my own before I downloaded your example, but it took awhile.

#How to read sqlite database code

The requisite script-local variable definition is present in the example code you posted. And that implicit definition makes the variable local to the command, so its value can't be referenced in the getDatabaseID function later in the code.

If I understand correctly, because the variable is not defined as local to the script initially, it is being defined implicitly within the setDatabaseID command. What is left out of the instructions is definition of the local variable sDatabaseID in the card script outside (i.e., before) all the handlers.

I built a stack following your instructions explicitly, and running the stack consistently throws this error when you click the Add Table button: It is fixed in your example file, but it is NOT mentioned in your directions. I didn't try this tutorial until after you fixed the bug David found, but I found another one. We could put all the code in the button script but I prefer to keep all the database handlers together on the card script. In this case we will define sDatabaseID in the card script, above the handlers that use it. Script local variables are defined outside of any handler, they are then accessible to the scripts of all handlers that appear after the variable definition. We also need the commnd setDatabaseID, which stores the database connection id in a script local variable, and the function getDatabaseID, which returns the database connection id so we can use it. # Store the database id so other handlers can access it Put revOpenDatabase( 'sqlite', tDatabasePath,, ,, ) into tDatabaseID # If the database does not already exist it will be created Put specialFolderPath ( 'documents' ) & '/runrevemails.sqlite' into tDatabasePath # The database must be in a writeable location Select the 'Connect to database' button, open the script editor and set the script of the button to on mouseUpР”Р„dd the databaseConnect handler to the card script. The command will create an SQLite database if it does not already exist. We store the connection id as we will need it when we want to communicate with the database. This command establishes a connection with the database and returns the connection id. To do this we use the revOpenDatabase command. The first thing we need to do is establish a connection with the database.