Subject | TIBO_Query creating Access Violation with fbclient.dll |
---|---|
Author | hcarvajalsy |
Post date | 2003-09-10T16:12:33Z |
Hello,
I am getting an EAcessViolation when trying to open a SQL sentence
using a TIBO_Query. The message that i get is the following: Project
ctswin.exe raised exception class EAccessViolation with
message 'Access violation at address 011D264E in
module 'fbclient.dll'. Read of address 00DCC000'. Process Stopped.
Use Step or Run to continue.
My environment is the following:
fbserver.exe file version 1.5.0.3773
fbclient.dll file version 1.5.0.3773
fbclient.dll has been copied to gds32.dll
TIBOQuery package ibo40xdt_d5
on the conf file of Firebird I changed the following parameter:
OldParameterOrdering = 1
the code which is originating the problem is the following:
db is a DataModule.
db.TIBOQuery.IB_Connection := db.TIB_Connection;
db.TIBOQueryIB_Transaction := db.TIB_Transaction;
db.TIBOQueryIB.Prepared := false;
if db.TIB_Transaction.InTransaction
then db.TIB_Transaction.Commit;
db.TIB_Transaction.StartTransaction;
try
db.TIBOQuery.SQL.Add('SELECT * FROM TABLE WHERE SCHOOL = ' +
'''' + SchoolCode + '''' +
' AND DISTNO = ' + IntToStr(DistNo) );
db.TIBOQuery.Prepared := true;
db.TIBOQuery.Open; <====== error ocurrence
Result := true;
except
db.TIB_Transaction.Rollback;
db.TIBOQuery.Unprepare;
end;
Any suggestions of how to solve the problem?
Thank you.
Horacio C.
I am getting an EAcessViolation when trying to open a SQL sentence
using a TIBO_Query. The message that i get is the following: Project
ctswin.exe raised exception class EAccessViolation with
message 'Access violation at address 011D264E in
module 'fbclient.dll'. Read of address 00DCC000'. Process Stopped.
Use Step or Run to continue.
My environment is the following:
fbserver.exe file version 1.5.0.3773
fbclient.dll file version 1.5.0.3773
fbclient.dll has been copied to gds32.dll
TIBOQuery package ibo40xdt_d5
on the conf file of Firebird I changed the following parameter:
OldParameterOrdering = 1
the code which is originating the problem is the following:
db is a DataModule.
db.TIBOQuery.IB_Connection := db.TIB_Connection;
db.TIBOQueryIB_Transaction := db.TIB_Transaction;
db.TIBOQueryIB.Prepared := false;
if db.TIB_Transaction.InTransaction
then db.TIB_Transaction.Commit;
db.TIB_Transaction.StartTransaction;
try
db.TIBOQuery.SQL.Add('SELECT * FROM TABLE WHERE SCHOOL = ' +
'''' + SchoolCode + '''' +
' AND DISTNO = ' + IntToStr(DistNo) );
db.TIBOQuery.Prepared := true;
db.TIBOQuery.Open; <====== error ocurrence
Result := true;
except
db.TIB_Transaction.Rollback;
db.TIBOQuery.Unprepare;
end;
Any suggestions of how to solve the problem?
Thank you.
Horacio C.