Error received using callback through XRev.dll (OpenInsight 32-Bit)
At 19 JUN 2004 10:22:39PM [email protected] wrote:
Occasionally i get
ENG0012: STDCRSIO, line 1 Table has not been opened
This has happened during use of TEST_EXEC_SQL through XRef and PHP and from the text editor command line.
it really nukes the engine. Some times running the same routine in the editor then works.
Any idea what could be causing this?
[email protected] onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"
David Tod Sigafoos ~ SigSolutions
At 19 JUN 2004 11:34PM Steve Smith wrote:
It's intermittent, so it's either timing related or memory related.
Put a
FLUSH
GARBAGECOLLECT
YIELD()
ahead of your function calls, and at regular intervals inside the code - then it will be in roughly the same state each time you run your routine.
Another idea is to always "CHDRIVE" and "CHDIR" to the XREV.DLL from any scripting language you use, then revert back later.
If this doesn't work, then it's timing related - I've found that depending on whether you have to load libraries (even using VB and Sybase, or VBA and Oracle) that the authentication steps are sometimes iffy, especially with ODBC-style calls. Unbeknowns to OI, at the time you first load, there are squigabytes of DLL code being located and loaded from disk into RAM.
Might I suggest that you place a call to KERNEL32's
SLEEP(milliseconds) subroutine ahead of each function call, especially if it's in the early stages of the connection or initial I/O. Use 100 ms - enough to seem deliberate and not enough to make it time out owing to delay - there's a "sweet spot" for timing here.
Someone may have a better solution, but I've had this using VB and SQL before - AODBC style calls - and I figure the issues may be similar.
Steve
At 20 JUN 2004 12:00PM [email protected] wrote:
Steve,
thanks for the reply, i think. lots of code to go through.
It does happen in the system editor. And it almost always happens during the following command
SELECT DISTINCT ARTIST FROM SONGLIST ORDER BY ARTIST
Funny after closing the debugger, the editors result window shows a large amount of results.
[email protected] onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"
David Tod Sigafoos ~ SigSolutions