Hi Bernard,
If TABLEUDATE returns .T. it was succesfull (GETFLDSTATE(-1) must be all 1).
(TABLEUPDATE updates the cursor, if the settings are ok writes also the underlaying table)
So the Cursor (View) is updated, but does not write to the table.
So it looks like your view settings are still invalid.
Check that your table is not buffered.
(Or you have to TABLEUPDATE the table)
Use DISPLAY DATABASE to check view settings.
If you like you may post the section out of DISPLAY DATABASE describing your view here, so I can look at it.
Agnes
>Hi Agnes,
>
>I used your test, even though my view only returns one record at a time. It failed every time because TABLEUDATE always returns .T.
>So I modified it to
>
>IF llRet THEN....
>
>and GETFLDSTATE(-1) returns '111111'
>
>Thank you,
>
>Bernard
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]