x = tableupdate(.t.,.t.,'tablename')>>>>It works in VFP 7 but not in VFP 9. The form has a burffermode of 2 (optimistic buffering) and the table a buffermodeoverride of 5 (optimistic table buffering).
>>>IF NOT tableupdate(.t.,.t.,'tablename') >>> AERROR(laError) >>> MessageBox(laError[1,2]) >>>ENDIF >>>>>
goto to bottom in tablename>
FUNCTION NEXTNO LPARAMETER lcNumStr RETURN PADL(ALLTRIM(STR(VAL(lcNumStr) + 1)), LEN(lcNumStr), '0')The problem is that I am not passing the last value in the table because it is not going to the last record in table (in this case it is going to the next to last record).