LiveCode Forums

Thank you! I will give that a try and report back.

Sorry Klaus...I'm just not being descriptive enough I guess. What I do is one card has a datagrid that uses the "databaseConnectDailyLog" command to open the "dailyLogDB". The second card has a datagrid that uses the "databaseConnectMedAdmin" command to connect and add data to that particular DB. Sw...

Ok, here is the entire code I use in the stack script in order to handle the commands: *So this is how I connect. The "0x0023" is the shared user folder for multiple users in the Window's environment. on databaseConnectMedAdmin local tDatabasePath ## The database must be in a writeable location put ...

Some more clarification....If I open the first database, close it and go to the next card and access the second database, I can add records and retrieve them. It is only when I attempt to delete an entry from the SQLite DB does it give me a connection ID error. I'll show you my call to delete record...

Hello all, I have a question regarding connecting to a SQLite database or rather connecting to two different databases from a single stack. So basically I have two datagrids in a stack on separate cards that I display data from two SQLite databases I have created. When I connect to one of them, ever...

AxWald, Thanks again for the support! After some modifications to the code to pass the variables into the "INSERT" command, it works just fine. What I did not pay attention to was I was connecting to an old database that I created for testing and not the one I was attempting to write to. Needless to...

First off, thank you all for the help. I feel like I have a small grasp on how it woks now. I do have a question though. How can I use a variable with the INSERT INTO command? I have local variables that I would like to use. Here is my code.... put "INSERT INTO dailyLog (d_field, t_field, Supervisor...

AxWald, Thank you for all the valuable information. I took a look and it has helped. Also, I was not aware that you could take the SQL command into the DB manager and execute the script to see if it passes. (I'm still learning how this all works). NOW, the results of my tinkering around found that f...

I'm not sure why but I am absolutely unable to create a table in the new database I create. I don't understand because it looks like my command structure for creating the fields is solid. on databaseCreateTables ## Add a contact_details table to the database put getDatabaseID() into tDatabaseID put ...

Thank you Bogs! I'm going to look that over as well. I appreciate the help.

Yes we are! Thank you again for the link...I am checking it out now!

Klaus, Thank you for the response! I was wondering if the command structures that you showed me would work in LC. I will take a look today and see what I can do with them. Does LC recognize "date" "datetime", "time" "float" etc? I have been searching the forum for examples of how people have set up ...

Hello all....I am attempting to follow the tutorial on creating tables and fields for SQLite and am running into some issues. Firstly, I can't seem to find anything that shows what types of values to use for creating fields ie: "char(50), text, bool etc. Secondly, using the tutorial I am able to cre...