>>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
>>>

>
>Jim,
>With that post, you'll make me read the whole HELP again :o))))
>If there is a better and easier way I'll be very happy.

Yea, that wasn't too bright of me. < s >
I think there is a third parameter for SQLEXEC. Jut can't check.