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
>