Re: Delete Query

[David Thompson-Hall <david.thompson-hall@DOIT.WISC.EDU>]

At 09:20 AM 12/7/00 +0100, Philippe Jamin wrote:

>Is there a means of do a DELETE Query without using the possibility of
>Rollback ?

Well, if the next thing you say is COMMIT, then there's effectively no
chance of a rollback - unless the original DELETE fails, in which case
there isn't really anything to rollback or delete anyway...

Speaking of which, does anyone know if you can effectively do nested
begin-transactions in SQR so you can do nested rollbacks if necessary?  I
did a lot of this in a VB app once, and I haven't had to worry about it in
SQR, but it would be nice to know...

DTH

David Thompson-Hall                                     1210 W. Dayton St.
Programmer/Analyst                                      Madison, WI 53706
Apps Tech/Business Operations Apps                      608/265-9571
Div of Info Technology (DoIT)
University of Wisconsin-Madison david.thompson-hall@doit.wisc.edu