SQL Statement on Multiple Lines

[Jim Ault]

ooops, correction below [ it does NOT detect special structures] :
> On 1/3/06 7:18 AM, "Bill" <bill at bluewatermaritime.com> wrote:
>> the "\"  (...) Can't be
>> used to split a string.
> 
> There is a very good reason for this convention:
> This allows you to use any words you want in a text string and they will not
> be confused with commands.  Imagine wanting to use the word "repeat" in a
> paragraph that the user will read, but the compiler said 'too, bad, it is a
> reserved word'.  And all the others = "it, for, when, put, end, while,
> format, folder, file, into, ........"
> 
> Basically, the compiler is digesting variables, assignments, repeat loops,
> reserved words, etc, but *suspends* this while scanning a text string,
> therefore, it does NOT detect special structures like end-of-command-line.
> 
> HTH
> Jim Ault
> Las Vegas
> 
> 
> On 1/3/06 7:18 AM, "Bill" <bill at bluewatermaritime.com> wrote:
> 
>> 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
>> 
>> 
>> 
>> _______________________________________________
>> 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