Home » Developer & Programmer » Forms » Multiple Records in Forms
Multiple Records in Forms [message #79106] Thu, 25 April 2002 12:20 Go to next message
Lilly
Messages: 5
Registered: April 2001
Junior Member
Hi,

I have a multiple record form. I provided a process button for the user to commit changes made to the records. One of the columns in the form is status. When the user retrieved the records and commits then I want to change the status to 'processed'. I want the status to change whether they make any changes to the record or not.

Can anyone help me??
Please treat this very urgent
Re: Multiple Records in Forms [message #79108 is a reply to message #79106] Thu, 25 April 2002 14:29 Go to previous messageGo to next message
pb
Messages: 18
Registered: December 2000
Junior Member
On key commit trigger at the form level write the following:

Update tablename
set status = 'processed';

commit;
execute_query;
Re: Multiple Records in Forms [message #79111 is a reply to message #79106] Fri, 26 April 2002 09:02 Go to previous message
Lilly
Messages: 5
Registered: April 2001
Junior Member
Sorry, I tried but didnt work. I have multiple blocks
but I want to do this only to this specific block. I
used on key commit at block level. May be that is the
reason it didnt work?
Previous Topic: Multiple active forms?
Next Topic: Re: Which front-end is faster Dev 2000 or Visual Basic or Power Builder
Goto Forum:
  


Current Time: Mon May 16 19:03:08 CDT 2022