Sergey,
I found if I use the same type of 2 commands for one SQLEXEC command will return no problem, but if I use different command type, will return error "1463=No result set has been returned by the server." such as one for "Select..." and one for "Update..."
for example:
_success = sqlexec(_myconn,"select top 1 inv_no from autogen; update autogen set inv_no = inv_no + 1","autono")
error will be returned, but changes can still be updated to the SQL table.
is there any other method to avoid this error?
thanks in advance.