LiveCode Forums

Yes that is what I'm looking to do. I can't seem to find out if there is a last row command or some such way of calling the Table1 ID for use in my other insert statements. Currently I programmatically built an insert statement with the following code; put "INSERT INTO control (" into tSQL put empty...

Sorry it got jumbled in the formatting of the post. Here is the table info Table 1 ------------------------ ID1 Date created Date Modified Table 2 ---------------------- ID2 Table2ID Table2Date created Table2Date Modified Data2 Table 3 ---------------------- ID3 Table3ID Table3Date created Table3Dat...

Hi, I'll start with the fact that I'm fairly new to Livecode. I am currently writing a small application with three tables in it. I have a view created that combines the data into one place for the purpose of display. THX to those who helped me out with that excercise! I'm now faced with getting Liv...

THat worked great! I was just trying the use of splitting the pptext using "split linColumn by comma and return" but I had it too far down in the code.

Thanks for the clarification on the FieldValues portion of the code. However I'm still not able to get the VALUES properly quoted. THe code puts quotation marks around the combined VALUES list instead of around each value as required for the SQL to interpret the VALUES properly. I'm unsure how to 'c...

I am getting close to having a correctly word INSERT INTO sql query but I cannot seem to get the values portion of the statement within quotation marks. The code I have puts quotation marks around the entire contents of the VALUES portion of the statement and not around the individual value terms. p...

I've been able to return the column names using put revDatabaseColumnNames(conID, "control") into pptext answer "ColumnNames"& pptext What direction do I take to read through the field names in "pptext" and read the field names and count into my loop? I assume that using revDatabaseColumnCount will ...

Hi, I'm fooling with SQLite and want to generate an INSERT statement by reading in the field names from an existing table. I want to read in the total number of fields ie:NumbFields and the field name itself ie:FieldName put "INSERT INTO Mood ( " into sqlQuery repeat with i = 1 to NumbFields put "Fi...

I need to generate put statement for a large number of database fields. I want to loop through creating the names of the fields and Data fields as follows; put revDatabaseColumnNamed(sRecordSetID,"Depress_Field_1") into field "Depress_Field_1" I am having trouble with building the strings in the loo...

Hi, I have an extremely long sql statement and I'm wondering how to best get it into LiveCode since the "\" character doesn't seem to work since the statement is between parenthesis. When I set it all in one line it gets really hard to manage. Here is an example of the sql code. --Table: Mood --DROP...

THX for the help. However I'm still not sure where the references to iHandle and iEnter come from any ideas?

I'm referring to the following script: function dbData iHandle, iEntry global conID -- Step 1: Check for Close Connection Request if iHandle is empty then revCloseDatabase conID put the result into temp if the result is empty then return "ok" else else return the result end if put empty into conID e...

I understand the "select *" business, what I'm looking for is an answer within the context of the code from the "CRUD SQLite example" database. I'm trying to figure out the relationship between the actual display fields "sEntry" and "sHandle" and the retrieval of the data from a database and the use...

This may seem like a silly question but I see fields named sEntry and sHandle, what I do not see is how the values of these fields are transferred tot he database. I see iEntry and iHandle but no corresponding code to set these values. Also, if I am trying to retrieve a table full of data do I then ...

Thanks for the link it looks good. But is there a way to also be able see all the scripts, then bulk edit the scripts with search and ?