Hi to all,
I receive an unexpeted system error when I run a routine that contains two concentric sql for a certain number of cycles (not always the same).
It's a bug or a limitation?
Any idea?
Fulvio
some spec:
Dabase: MySql
dbconn: is the name of connection opened with the DB
routine code:
sql_1 is string = "SELECT..."
QuerySql_1 is data source
sql_2 is string = "SELECT..."
QuerySql_2 is data source
IF HExecuteSQLQuery(QuerySql_1, dbconn, hQueryWithoutCorrection, sql_1) THEN
HReadFirst(QuerySql_1,hNoRefresh)
while not hout(QuerySql_1) then
IF HExecuteSQLQuery(QuerySql_2, dbconn, hQueryWithoutCorrection, sql_2) THEN
HReadFirst(QuerySql_2,hNoRefresh)
while not hout(QuerySql_2) then
...
...
HreadNext(QuerySql_2)
end
end
hcanceldeclaration(QuerySql_2)
HreadNext(QuerySql_1)
end
end
hcanceldeclaration(QuerySql_1)