SQL Statement on Multiple Lines

Jeff Honken jhonken at x12.info
Mon Jan 2 14:34:56 CST 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