>Thanks for your help with this. I will try out temp tables and trouble you if I get stuck anywhere.

You can look up message #1134780 (or the whole thread) - seems to describe the same type of problem.

Also, you can have two selects in your SPT strings, you just get two result sets:

cSQL="select * from table1"+chr(13)+"select * from table2"
sqlexec(haendel, cSql, "crsTemp")

if everything goes right, you get the results of the first select in cursor crsTemp, and the second in crsTemp1.

At times I had anywhere between one and dozen of cursors pulled with a single trip to the server.