OraFAQ Forum: Forms » SELECTIVE INSERT INTO TABLE

Home » Developer & Programmer » Forms » SELECTIVE INSERT INTO TABLE (Oracle Database 10g, Forms 10g, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SELECTIVE INSERT INTO TABLE [message #689657]

Mon, 11 March 2024 11:42

billgates
Messages: 19
Registered: March 2017

Junior Member

Dear Experts,
I am building a payment voucher form in forms 10g. It has two database data blocks MASTER and DETAILS.
A button fetches invoice data from different tables into the fields of the details data block.

I want to place a checkbox in the tabular (details) data block. So that the user can select the invoices to pay based on the checkbox.
And only those records where he checked the checkbox can be saved in the database table behind this details datablock.

An easy solution was to set the database item property true of every single item in the row where check box has changed to checked.
but unfortunately in the forms 10g changing the database_item property of a field through code is not possible.

Please help me figure out how can I do this.

Report message to a moderator

Re: SELECTIVE INSERT INTO TABLE [message #689659 is a reply to message #689657]

Tue, 12 March 2024 01:58

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

One option might be to create a button (in master block), saying e.g. "Pay selected invoices".

Its WHEN-BUTTON-PRESSED trigger would then

navigate to detail block
loop through all records
whenever it finds that checkbox is checked, perform that "save" action (I guess it is UPDATE; if not, do whatever you find appropriate)
commit after the loop

Report message to a moderator