>>I'm not an expert for SCX/DATENVIRONMENT, I use forms via VCX and add my DE's at runtime, and do all datahandling by CursorAdapter, skipping all this inner workings. It was to ugly to maintain.
>>
>>So you have
>>- a form with a DE
>>- the DE holds one cursor object for your table
>>
>>This table is open and holds all the records you expect, right?
>>
>>And then you run a VIEW against that table, or is this a different object in your dataenvironment?
>>And this does not show the number of records you expect?
>
>Pardon me if I'm stating the obvious elephant, but... could it be that the fourth record was still only in the buffer and not yet flushed into the table? Then a view against that table would show only the records which made it to the disk so far, i.e. only three. Just closing the entry form would flush that and then the view would show all four. So, perhaps a tableupdate() still didn't have a chance to do its trick at the time?
That is a point to think about. Instead of TABLEUPDATE() this: SELECT * from MyTable WITH (BUFFERING=.T.) will do as well. (if one need to keep the buffer state)
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]