Oracle Forms - Non Base Table / Base Table

[fmsousa]

Hi,

I have 2 blocks (1 non base table and another that is base table).

The first block has got only 1 text item and a button.
The 2nd block (base table) has got 3 text items (tabular type with 8 rows each one).

The Problem: i wrote a value into the text item (char) from the 1st block and then i press the button associated. Depending of the text filled in the text item, the second block will show some rows (filter by text item of block 1).

I m doing the following:
-In the first block, at the When-button-pressed trigger i put: go_block ('second_block');

At the 2nd block i have:
-at When-new-block-instance trigger:
set_block_property('2nd_block',DEFAULT_WHERE,filter by the text item value inserted into the 1st block');
execute_query;


PS: resuming, i have a base table block that has got a filter. This filter is constructed with the text item from the first block (this one non base table).

Can anyone help me?! Please this is very urgent!!
Thanks in advance.

 

[lewisp]

See my response in the Oracle release 8 and 8i forum....