I remember VFP9 having a "clearer" way to determine the outcome.

Unfortunately, I'm not using it at the moment so cannot give details.

cheers

>>also i want to know , how can i know if the record has been succesfully inserted ????
>

>IF SQLEXEC(sqlH,lcSql) > 0
>   *** Success
>ELSE
>   AERROR(laError)
>   MessageBox([Can not insert the record: ]+laError[1,2])
>ENDIF
>