[485] in sapr3-soft

home help back first fref pref prev next nref lref last post

Re: deleting tables

daemon@ATHENA.MIT.EDU (devnull@no.spam.glo.be (Dave Null))
Sat Oct 11 19:47:20 1997

To: sapr3-soft@MIT.EDU
Date: 11 Oct 1997 18:43:43 -0500
From: devnull@no.spam.glo.be (Dave Null) (by way of SAP Moderator <devnull@no.spam.glo.be>)

Once upon a time, in the land of comp.soft-sys.business.sap, Frode
Rxed eloquently wrote:
Organization: DustBin

>I have a table (database table, not internal) call ZNEWS and I want to
>empty it befor I fill it up with data again.

Hi,

Suppose your ZNEWS file contains a field ZFIELD, then use

delete znews where ZFIELD <> 'azeztrujtzfqjd'.

I use a string like 'azezdswkjnl=mk' to make sure all my records get
deleted.

Good luck,
Andre
------------------------------------------------------
Email address hidden thanks to idiots at
    Cyberpromo, AGIS and the IEMMC
------------------------------------------------------

----------------------------------------------------
comp.soft-sys.business.sap is a moderated newsgroup.
Postings are archived and available from the
Realtime USA web site at http://www.realtimeusa.com
----------------------------------------------------

home help back first fref pref prev next nref lref last post