SQL Statement on Multiple Lines
Jeff Honken
jhonken at x12.info
Mon Jan 2 15:34:56 EST 2006
Is there any way to have a SQL statement on multiple lines. My code
works great if the statement is all on one line but once I try to go to
two lines it dies. I've tried using the / with no luck. Here's a very
cut down version of what I'm trying:
--> CONSTRUCT SQL
put "CREATE TABLE Provider
(ProvAutoNo INTEGER PRIMARY KEY, ProvActive text)" into tSQL
--> EXECUTE SQL
put revdb_execute(gConID,tSQL) into tList
The Provider table is actually very large.
More information about the use-livecode
mailing list