I have a block based on a table. When the user enters data into a control field and presses a save button. The data is transferred to a field in the block table. This works quickly and as expected; however, when I change the block to be based on a view (select * from table), there is a considerable delay when the the field is transferred to the view. I don’t see why there would be any delay as at no time is the data being commited. There is no reason for Forms to access the server when the save button is pressed.
Using debug I can see that when I execute this line
snote.note := :ctl_enter.ctl_note and the block snote is based on a table it works immediately. When the block is based on a view there is a long delay.
Any ideas on why this happens?
Using debug I can see that when I execute this line
snote.note := :ctl_enter.ctl_note and the block snote is based on a table it works immediately. When the block is based on a view there is a long delay. Any ideas on why this happens?