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.

Report message to a moderator

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: 21826
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.

Report message to a moderator

Previous Topic: how to create the relationships between two tables presents in different database
Next Topic: Dynamically fetch records in tabular layout
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 14 11:57:31 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.