I use this bit of code frequently:

-----
PROCEDURE SQLOneValue(statement, connection="")
res is Variant
rss is Data Source
name is string
IF connection <> "" THEN
res=HExecuteSQLQuery(rss, connection, hQueryWithoutCorrection ,statement)
ELSE
res=HExecuteSQLQuery(rss, Null, hQueryWithoutCorrection, statement)
END
IF res THEN
HReadFirst(rss)
name=HListItem(rss, hLstAll)
name=name [ [1 TO Position(name, CRLF)-1 ] ]
res= {"rss."+name}
ELSE
ExceptionThrow(1, HErrorInfo())
res=Null
END
HCancelDeclaration(rss)
result res
-----
This is a simple procedure to grab the first value from the first row from the results of a sql query. Very convenient for things like:
id = SQLOneValue("select id from foo where bar='quuz'")
However, after several thousand calls to this function, the program causes an error in msvcrt.dll:
-----
Error in Global Procedure SQLOneValue process, line 23.
HReadFirst function called.
Unexpected system error.
If this error occurs systematically in the same conditions, contact PC SOFT Hot Line and indicate:
- the error circumstances,
- the code lines, a window or a project used to replicate the problem,
- the following technical details.
Détails techniques :
Module : MSVCRT.dll
Adresse de base : 77BE0000
Erreur système : Access violation (GPF)
EIP = 77C13070
OS : Windows XP ou .NET Service Pack 1(5.1.2600)
------
It all seems rather random, not occurring after a fixed number of queries. Am I doing something wrong ?