TABLEUPDATE() never raise an error. You should check it:
IF NOT TABLEUPDATE(1, .t., [YourViewAlias])
AERROR(laError)
MessageBox(laError[1,2])
ENDIF
ALWAYS do something like that. Also ALWAYS put ALIAS at the end of the function, just to be sure that you TABLEUPDATE the right table/view/cursor.
>I have a view that when I do a tableupdate sometimes fails but doesn't show it.
>i.e.
>
>l=tableupdate(.t.,.t.)
>if l=.f.
> failed
>else
> good
>endif
>What is happening, is I replace data into the view, i.e.
>replace invno with nInvNo ;
> invdate with dDate ;
>invcust with nCustNo
>
>I then call the tableupdate() after this and check as above.
>I get no errors, however if I look at the underlying table, the last record has empty fields for the above.
>
>This apparently only happens when the underlying table is at eof()
>
>Does this make any sense to anyone?
>Mike
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.