Re: SQL Delete Question

["Jeffrey Lee" <jeff@xxxxxxxxxxxxxxxxxxx>]

What I normally do is find all of the records I want to remove and use the
id number to remove them

For example:
SELECT * FROM table WHERE username="soandso"
put the data into an array
DELETE * FROM table WHERE id="$id"

I would put that in a loop for multiple records. Also I do this in PHP but
the concept and most of the syntax should be the same.

----- Original Message ----- 
From: "Mike Wills" <koldark@xxxxxxxxx>
To: "Midrange_RPG400_L" <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, August 06, 2004 10:40 AM
Subject: SQL Delete Question


> I have this SQL statement:
>
> SELECT * FROM DBPOPOR EXCEPTION JOIN DBPOPRL ON DBPOR_COMPANY =
> DBPRL_COMPANY AND DBPOR_REC_NUMBER = DBPRL_REC_NUMBER ORDER BY
> DBPOR_COMPANY, DBPOR_REC_NUMBER
>
> I would like to delete all records that come up. But obiously I can't just
do:
> DELETE FROM DBPOPOR EXCEPTION JOIN DBPOPRL ON DBPOR_COMPANY =
> DBPRL_COMPANY AND DBPOR_REC_NUMBER = DBPRL_REC_NUMBER ORDER BY
> DBPOR_COMPANY, DBPOR_REC_NUMBER
>
> Is there a simple way to set this up or do I have to do this the hard way?
>
> -- 
> Mike Wills
> iSeries Programmer/Lawson Administrator
> koldark@xxxxxxxxx
> http://www.koldark.net
> Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>