SQL Statement on Multiple Lines

[Jim Ault]

> 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" <jhonken at x12.info> 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution