Hi Kusnardi,

If SQLEXEC() or SQLMORERESULT() return value less then 0, then SQL command execution failed. Use function AERROR() for reading info about errors.

MartinJ


>Hi,
>
>I am using VFP 7 as a front end and mySql as a backend database. I use sqlexe to execute the inserting, updating and deletion. Is there anyway to read any status from mySql. e.g. Updating record failed at the server or record not inserted. Thanks for any help.
>
>regards,
>Kusnardi