Home » Developer & Programmer » Forms » How to process all records one by one, in a data block
How to process all records one by one, in a data block [message #390574] Sat, 07 March 2009 13:50 Go to next message
manimuthuraman
Messages: 6
Registered: July 2006
Location: chennai
Junior Member
Hi I have two data blocks in my canvas
While running the form
a)WHEN NEW FORM INSTANCE, i query the data block 1.

When i click a button,
by calling a procedure...
I need to process Data block1 - record one by one, to check whether this record exists in data block 2'table.
If it is there, update it or else to insert it.
Then i need to query the data block 2's table(go_block datablock2...Execute query) & display it as data block 2 o/p.
Re: How to process all records one by one, in a data block [message #390582 is a reply to message #390574] Sat, 07 March 2009 15:22 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
How to process all records one by one, in a data block

In a loop. Navigate through records using Forms built-ins, such as GO_BLOCK, GO_ITEM, NEXT_RECORD, PREVIOUS_RECORD etc.
Previous Topic: how to create the relationships between two tables presents in different database
Next Topic: Dynamically fetch records in tabular layout
Goto Forum:
  


Current Time: Wed Dec 07 18:12:28 CST 2016

Total time taken to generate the page: 0.10007 seconds