Here's the code:
local aSQLError[1]
SELECT V_VEHLIST
replace V_VEHLIST.curr_sele WITH .t.
llsuccess = TABLEUPDATE(.T.)
IF !llsuccess
aerror(aSQLError)
msg = "Data was not saved -- call a programmer"
messagebox(msg, 0+16+0, "Data Update Failure")
list memory like aSQLError noconsole to print
=TABLEREVERT(.t., .t.)
=REQUERY()
ELSE
SELECT V_CURRLIST
=REQUERY()
ENDIF
But it is still not updating the v_vehlist local view.
Hre is what is returned on the print command above...
ASQLERROr
(1,1) N 10
(1,2) C "Syntax Error."
(1,3) C .NULL.
Thanks in Advance.
J. Turner