Search found 46 matches

by jpottsx1
Wed Oct 19, 2011 8:34 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Advanced Database usage questions
Replies: 4
Views: 1943

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...
by jpottsx1
Wed Oct 19, 2011 8:24 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Advanced Database usage questions
Replies: 4
Views: 1943

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...
by jpottsx1
Wed Oct 19, 2011 7:38 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Advanced Database usage questions
Replies: 4
Views: 1943

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...
by jpottsx1
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: 3382

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.
by jpottsx1
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: 3382

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...
by jpottsx1
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: 3382

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...
by jpottsx1
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: 3382

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 ...
by jpottsx1
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: 3382

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...
by jpottsx1
Sun Sep 18, 2011 2:21 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: How doI get quoted field names?
Replies: 2
Views: 1263

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...
by jpottsx1
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: 2082

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...
by jpottsx1
Tue Sep 13, 2011 1:03 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: CRUD SQLite example
Replies: 66
Views: 30557

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?
by jpottsx1
Mon Sep 12, 2011 10:37 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: CRUD SQLite example
Replies: 66
Views: 30557

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...
by jpottsx1
Mon Sep 12, 2011 10:14 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: CRUD SQLite example
Replies: 66
Views: 30557

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...
by jpottsx1
Mon Sep 12, 2011 8:55 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: CRUD SQLite example
Replies: 66
Views: 30557

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 ...
by jpottsx1
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: 4233

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 ?

Go to advanced search