Oracle Forms

Hi All,

I'm using form builder 6i, I have a browsing Tab in my form that have one block and a lot of check boxes (5) for browse criteria that can be checked and concatenated together with || 'and' into a variable (condition) to make a (value) for the (Default_Where) property of the block.

As you know I can't issue a statement like this:

Select count(*) into count from MyTable where condition;

it causes an exception because select statement needs to state column names in where caluse, but I can just use the accumulated condition in the manner below:

set_block_property('MyBLOCK',default_where,condition);

I used it to execute the query, and it works well...but the problem is that I want to know the number of records returned from query in order to show it in a display item for the browser.

So...what I have to do ?? Any clue?


Thanks,

LoveSoul