SQL Statement on Multiple Lines

[Bill]

I always wondered why sometimes the "\" character didn't work. I thought it
was me and I just started making extremely long lines in my code. Can't be
used to split a string. Geez. I guess there is a complex reason for that
related to hexadecimal inputs through the hyperspatial tuning of the
dilithium crystal memory stacks or some such.


On 1/2/06 4:41 PM, "Jim Ault" <JimAultWins at yahoo.com> wrote:

>> 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
> 
> 
> _______________________________________________
> 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

            |    |    |
           )_)  )_)  )_)
          )___))___))___)\
         )____)____)_____)\\
       _____|____|____|____\\\__
-------\                   /--------- http://www.bluewatermaritime.com
 ^^^^^ ^^^^^^^^^^^^^^^^^^^^^
  ^^^^      ^^^^     ^^^    ^^
       ^^^^      ^^^

24 hour cell: (787) 378-6190
fax: (787) 809-8426

Blue Water Maritime
P.O. Box 91
Puerto Real, PR 00740