Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Populating a multi-record UNBOUND block

Status
Not open for further replies.

cglisc

Programmer
Nov 15, 2001
45
CY
Hello,

We have a situation where a form has 2 blocks:
A "Main" block and a child, detail block showing multiple records. When a value in a certain field changes on the main block, we open a cursor and populate the child block.

GO_BLOCK('child');
open cursor
loop and populate child block.

Both blocks are "unbound", ie they have their Database Data Block property set to NO and Query DataSource TYpe to "None".

The prpoblem is that if on the main block there is a required item that is null, GO_BLOCK('child') does not work.

Is there a way to jump to the Child Block, fill it and go back to the Main block?

Thanks
Chris
 
Code:
Set_Item_Property('block.item',REQUIRED,PROPERTY_FALSE);
Go_Block('CHILD');
.
.
Set_Item_Property('block.item',REQUIRED,PROPERTY_TRUE);

Why do you have required items if the block is not based on a database object?
 
>Why do you have required items
>if the block is not based on a
>database object?

Because we eventually update database tables with data in
the unbound blocks. We set the required property to
true to certain fields and let forms do this validation
for us.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top