Updating Multiple Records

[melmckee72]

I am writing a program in which a user can update information within a table. I have a one to many relation between two tables within the database. I would like to be able to display all the records which meet the user's search criteria and then allow them to go through the fields one by one to update.

The problem I am having is getting all the records to display first, and then going through the update process.

I am using a for each loop to find the records and display them, then an update statement to allow user input.

for each bempfunc where bempfunc.bfstnme = bemp.bfstnme and
bempfunc.blstnme = bemp.blstnme:
display bfcde bfjob with fram func down.
update bfcde bfjob with fram func.
END.

Any help would be appreciated.

Thanks

 

[toby.Harman]

Try using an updateable Browser.

This should display a page worth of records that you can modify to your hearts content and then page up and down as needed.

Completely different programming model required! Event Driven will require a bit of thought but can be done!

 

[vinod_home]

check the programming handbook and you should get some examples on how to use browsers to do this.

Originally posted by toby.Harman
Try using an updateable Browser.

This should display a page worth of records that you can modify to your hearts content and then page up and down as needed.

Completely different programming model required! Event Driven will require a bit of thought but can be done!

 

[MHotovec]

Event driven.
Love it, live by it...

Originally posted by vinod_home
check the programming handbook and you should get some examples on how to use browsers to do this.