Search found 46 matches
- Wed Oct 19, 2011 8:34 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Advanced Database usage questions
- Replies: 4
- Views: 4190
Re: Advanced Database usage questions
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...
- Wed Oct 19, 2011 8:24 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Advanced Database usage questions
- Replies: 4
- Views: 4190
Re: Advanced Database usage questions
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...
- Wed Oct 19, 2011 7:38 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Advanced Database usage questions
- Replies: 4
- Views: 4190
Advanced Database usage questions
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...
- Fri Oct 07, 2011 1:47 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: How do I read table field names?
- Replies: 8
- Views: 7129
Re: How do I read table field names?
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.
- Fri Oct 07, 2011 1:23 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: How do I read table field names?
- Replies: 8
- Views: 7129
Re: How do I read table field names?
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...
- Thu Oct 06, 2011 1:11 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: How do I read table field names?
- Replies: 8
- Views: 7129
Re: How do I read table field names?
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...
- Mon Oct 03, 2011 2:22 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: How do I read table field names?
- Replies: 8
- Views: 7129
Re: How do I read table field names?
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 ...
- Mon Oct 03, 2011 12:41 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: How do I read table field names?
- Replies: 8
- Views: 7129
How do I read table field names?
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...
- Sun Sep 18, 2011 2:21 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: How doI get quoted field names?
- Replies: 2
- Views: 2477
How doI get quoted field names?
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...
- Thu Sep 15, 2011 2:49 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: How do I deal with long SQL statements
- Replies: 2
- Views: 3424
How do I deal with long SQL statements
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...
- Tue Sep 13, 2011 1:03 am
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: CRUD SQLite example
- Replies: 66
- Views: 55586
Re: CRUD SQLite example
THX for the help. However I'm still not sure where the references to iHandle and iEnter come from any ideas?
- Mon Sep 12, 2011 10:37 pm
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: CRUD SQLite example
- Replies: 66
- Views: 55586
Re: CRUD SQLite example
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...
- Mon Sep 12, 2011 10:14 pm
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: CRUD SQLite example
- Replies: 66
- Views: 55586
Re: CRUD SQLite example
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...
- Mon Sep 12, 2011 8:55 pm
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: CRUD SQLite example
- Replies: 66
- Views: 55586
Re: CRUD SQLite example
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 ...
- Sun Sep 04, 2011 6:15 pm
- Forum: Getting Started with LiveCode - Complete Beginners
- Topic: How can I see all scripts in stack?
- Replies: 6
- Views: 6698
Re: How can I see all scripts in stack?
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 ?