SQL - Access violation module: ntdll.dll (GPF)

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)

Well,

I'm not totally sure if this would cause the problem, but, your code is incorrect.

On both lines with the following code:

"while not hout(QuerySql_1) then"

your "WHILE" statment should not end with "THEN"

Take out the "THEN" on both lines and then retry.

Georgio

Hi Georgio,

don't considerate the "THEN" at the end of each WHILE...

yes, it's an error... sorry, I wrote the example directly in the topic.

I'm sorry for the mistake.

Fulvio