QRY Method - System hanging in loop (OpenInsight) [Revelation On-Line Wiki]

OpenInsight, Loren Henry

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 11 OCT 2001 05:49:26PM Loren Henry wrote:

I am running a Query against a SQL database - Code
 hqry2=QRYINSTANCE(hxo2)
 flag=QRYMETHOD(hqry2,QRY_EXECUTE$,script)
This code is in a loop. The first time through it works great. The second time through the flag… statement hangs the system. This requires a reboot. The end of the first loop contains a
 flag=QRYMETHOD(hqry2,QRY_Cancel$)
 flag=QRYMETHOD(hqyr2,QRY_Destroy$)
Do I need to do something to reinstate the query? Any other ideas?

Thanks!

At 15 OCT 2001 11:28AM Loren Henry wrote:

Well, I found out that if I open a new query handle for each query it doesn't hang, until you get to the 6th query. Is there a limit on the number of query handles that can be opened within one Stored Procedure? Should I be able to reuse the same handle over and over?

At 16 OCT 2001 09:23AM Loren Henry wrote:

Could someone please help with this - I am stuck.

View this thread on the Works forum...