Jim, Thanks for the response. I'm trying to create a script that will recreate my database. I need to create multiple tables and allot of inserts. Jeff
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Ault Sent: Monday, January 02, 2006 1:42 PM To: How to use Revolution Subject: Re: SQL Statement on Multiple Lines > two lines it dies. I've tried using the / with no luck. The correct character is "\" Not sure what you are doing specifically, but remember, the "\" cannot be used to split a string: NO: put "the lazy brown dog jumped \ and bit the mailman" into neverHappened Yes, even in the multi-line message box: put " the lazy mailman bit " & \ "the brown dog" into newsAtSix Jim Ault Las Vegas On 1/2/06 12:34 PM, "Jeff Honken" <[EMAIL PROTECTED]> wrote: > 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. > > > _______________________________________________ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution