Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

get_block_property('blockname', query_hits) returning wrong value

485377Mar 15 2006 — edited Mar 15 2006
I have a database datablock displayed on a form with all of the rows and columns for that datablock. Some of the columns are available to the user to be changed. And any of the rows can be deleted.

count := get_block_property('blockname',query_hits);
Lets say that count= 4;

If the user deletes one of the rows, I can loop through the block and see that the block only has 3 rows, not to mention all of the users chages to values in the rows can also be seen using the forms debugger for the datablock.

-- Exit out of loop when this is true
if(:system.last_record = 'TRUE') then
exit;
end if;

But if I now set count := get_block_property('blockname',query_hits);
then I still get a value of 4 instead of 3;

Does anyone know why the block property isn't updating?

Thanks,
michelle
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2006
Added on Mar 15 2006
1 comment
4,186 views