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

Re: Delete Query

Can't add a 'Where' clause to a truncate.  Also many users will not be given
the power to truncate because it is in the same group with dropping tables
and such.

-----Original Message-----
From: jteschendorf@AGCONSULT.COM [mailto:jteschendorf@AGCONSULT.COM]
Sent: Thursday, December 07, 2000 8:25 AM
To: SQR-USERS@list.iex.net
Subject: Re: Delete Query


Why not try using "Truncate" instead of "delete" ?





Jamin Philippe <PJamin@SLTC-FR.COM>@list.iex.net> on 12/07/2000 03:20:43 AM

Please respond to sqr-users@list.iex.net

Sent by:  "Discussion of SQR, Brio Technology's database reporting
      language" <SQR-USERS@list.iex.net>


To:   SQR-USERS@list.iex.net
cc:
Subject:  Delete Query

Hello All,

SQR V3, Oracle V7

Is there a means of do a DELETE Query without using the possibility of
Rollback ?
I am sure to will suppress my data.

 thank you

---
Philippe Jamin
SLTC - Société Lyonnaise de Transports en Commun
Direction des Services Techniques - GMAO
41, rue de la Poudrette - 69120 Vaulx-en-Velin
* 04 78 71 83 16 - Fax : 04 78 71 83 56
pjamin@sltc-fr.com