Problem refreshing form with sql view

zutzu

I have a sql view.
And a linked table. This table views the info of the sql view.
I create a form that shows the table (with the info of the sql view).
This form is not editable.
The problem is: i have filters in this form (user can intro, for example, vendor). When filter applies, many times show correct information and many times show incorrect information (all registers less one).
And if a click with the cursor on the information, sometimes appear or diseppear one register.
Any idea?

kine

The form is showing some "snapshot" of the view. When you are moving with the cursor inside the table, it will "refresh" the selected lines - some will be "removed", some are new etc... if you wish to refresh whole form, you need to use CurrForm.UPDATE to refresh the form. But still, this behavior is common for NAV and working in same way for common tables...

zutzu

kine wrote:

But still, this behavior is common for NAV and working in same way for common tables...

No, the behaviour is different.
Detailed example:
I introduce vendor X and the result is 5 registers:
The form shows 5 registers (OK).
But if i refresh, form shows only 4 registers.
If i refresh another time, form shows 5 registers.
If you continue refreshing, toy get, 4, 5, 4, 5...

The problem is that the first time form shows information, may show information OK or bad (5 or 4 registers).
And i can´t tell the user: "If the information is bad, refresh".

kine

Than there must be some code behind that... try to enable debugger and go through the code which is called when updating the form...