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