I have been a long time getting back on this because of other pressures.
I want to repeat the original problem because it is a long ways back.
I have an Invoice Master File where each Invoice has about 5 rows. There are maybe 100 invoices in the file and just the first row of each invoice is shown on screen. See the attached screen capture.
The idea is we want the operator to click on multiple rows and then click "Delete Selected Invoices" and have all rows of each checked invoice deleted.
I thought I would need a Stored Procedure but its not required,
I got the answer from ChatGPT as below:
DELETE FROM Invoices02
WHERE Invnbr IN (
SELECT Invnbr FROM (
SELECT Invnbr FROM Invoices02
WHERE Check01 = 1
GROUP BY Invnbr
) AS subquery
);
Its not code like I have seen before. The Oracle Web Site was stumped by this.
But it works. You have to return the screen table to the server before running this.
Mike
Mike