[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: SQL statement issue



In some earlier versions of SQR (I don't remember how early, maybe v3), under 
Oracle,
using the COMMIT command within BEGIN-SQL would blow up.  You had to use the 
separate SQR COMMIT command outside BEGIN-SQL.  If you are having a problem 
with commit within begin-sql, try SQR command instead.

At 10:20 AM 4/4/2001 -0400, you wrote:
>Can anyone tell me if it is OK to end a SQL statement with a ;(semi-colon).
>
>We have following code...
>
>BEGIN-SQL
>  COMMIT;
>END-SQL
>
>Is this OK to do in SQR?
>
>Thanks..
>
>        .Bruce
>
>Bruce Weinstein
>E-Mail: bruceweinstein@canada.com


Dave Donnelly           <dave@isisbio.com>
ISIS BioComp            phone (909) 677-2446      fax (781) 207-5533