get_block_property('blockname', query_hits) returning wrong value
485377Mar 15 2006 — edited Mar 15 2006I 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