Thanks for the response
Sorry for late response. I am actually a little embarrased because the problem turned out to be a syntax problem. I used "order by var1+var2". I changed the + to a comma and got the data I expected. The lack of an approiate error message confused me. Getting away from the problem for a day helped. When I looked at the query statement the next day it just popped out.

Thanks for the help, Chuck

>Hi Chuck,
>I dont really follow you here :) Can you post the code?
>It sounds a little like a problem I had using "manual transactions".
>You need to do a SQLCOMMIT(h) before the next result set will show the proper
>info..
>i.e.
>SQLEXEC(h,'select * from xxx','xxx')
>SQLCOMMIT(h)
>SQLEXEC(h,'select * from xxx','xxx')
>
>BR
>Tim