>I am creating my first Client/Server Application. I am using VFP 5.0 with a SQL Version 6.5 Database. Could anyone recommend some SQL error numbers I should trap when they occur?
It's better to intercept any SQL-related error:
ON ERROR lErrorflag=.t.
=sqlExec(...)
=AERROR(aErrorInfo)
ON ERROR
if lErrorflag=.t.
**** show custom message including aErrorinfo[2]
endif
Edward Pikman
Independent Consultant