>>Dear all,
>>
>>I am just beginning to start writing codes for C/S trials. One very strange problem which occurs very often is the execution of spt statements. Sometimes a spt executes successfully, and positive number is returned, while, the same form, same spt fails at other times. I don't know what causes the problem. Can someone suggest where I should look into?
>>
>>Many thanks.
>>
>>Best regards,
>>Ron.
>
>If you are using Private Datasessions, you have to reSET things like Exclusive, MultiLocks, Century, Talk, etc. I had the same problem with SQLExec failing when called from a form with a Private DE, but successful when done from command window. The SET CENTURY back to ON is what bombed my SQL from a private DE. By default CENTURY is OFF which, IMHO, is ludicrous in this day and age (big hint to MS!)
wish list item???