Results of SQLEXEC() into a CURSOR with a specified name

[benasumwa]

Hi friends

Thanks to all for your helpful tips/hints.

I have trouble with SQLMORERESULTS()

This is the scenario:

=SQLSETPROP(nHandle,"Asynchronous",.T.)
nResult=SQLEXEC(nHandle,"SELECT * FROM GLTRANFI","GLTRANFI")
nResult=SQLEXEC(nHandle,"SELECT * FROM GLACCOUN","GLACCOUN")

The second SQLEXEC() call generates the error below:

Invalid call issued while executing a SQLMORERESULTS() sequence

Iam preparing my data session for editting. The tables are relatively small.(no stress on the network). I am unable to know why the error comes and how to incorporate the said
SQLMORERESULTS() function here.


Please help. Many thanks.


---------------------------
Benson O. A.
Infinity Link Limited

 

[benasumwa]

Hi Mike,

I must say I appreciate greatly your answer. It has actually
given me several tips on how to approach the whole thing
Thank you very much! Most of my dilemmas are sorted now.
You know I am just getting into the client/server stuff
and surely receiving such well thought out responses is a real boost to my confidence to continue!

I must say thank you very much!

---------------------------
Benson O. A.
Infinity Link Limited

 

[benasumwa]

Thanks Mike!

---------------------------
Benson O. A.
Infinity Link Limited