Re: Forms delete record
From: Paul Dorsey <pdorsey.dulcian_at_worldnet.att.net>
Date: 29 Apr 1998 10:31:34 GMT
Message-ID: <6i6vi6$3fe_at_bgtnsc03.worldnet.att.net>
Date: 29 Apr 1998 10:31:34 GMT
Message-ID: <6i6vi6$3fe_at_bgtnsc03.worldnet.att.net>
In our multi LOV we store the IDs in
a comma delimited list. To delete
the records we issue a delete
statement from forms and requery the block.
The trick was to store the IDs as the records are sleected. Otherwise you have to "walk the block" to figure out what is selected.
-- Paul Dorsey Dulcian, Inc. www.dulcian.com 212 595 7223 Harry Yuen <hyuen_at_istar.ca> wrote in article <3546cb4f.431738292_at_news.istar.ca>...Received on Wed Apr 29 1998 - 12:31:34 CEST
> With Oracle Forms, is there a generic way to delete record/records
> after an Execute_Query? What I'm trying to do is to select
> (highlighting) records in a multi record block and click a button to
> issue the delete sql pertaining only to those records.
> Thanks in advance.
>
> Harry Yuen
>