3th parameter is Cursor where you'll get the results, maybe you mean forth parameter - array where you get how many rows are affected? This is great, but if the insert fails for some reason (some rules violation) it is better to check why this is happened with AERROR().
BTW if you didn't point me to this parameter I will countinue to searc for that info with some other ways. Thanks. :o))
>>>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.