Board index » delphi » Delphi 7/Oracle/BDE/printing- bugs ?

2004-01-25 06:23:55 PM
delphi94
I upgraded my application from D5 to D7.Since then my company clients
complain that the application freezes
from time to time,and they have to reset the server and clients computers.
When I using cached updates I receive access violation when I close some
forms or called applyupdates.
Cached updates problem was solved when I went back to use Sqlora8.dll
version 5.1.1.2 (Delphi 5).
However I still didn't find the leaking that causes the application to
crash.It may have to do with printing.
I use Oracle 8.1.6 ,BDE 5.1.1.2 or BDE 5.2.0.2,QuickReport 6.1.2+Gnostice
2.12,InfoPower 4000.
Any help would be appreciated
 

problem with parameterized queries when using the BDE SQL Links with Oracle.
Since the SQL Links are deprecated there is no chance that this will ever be
fixed. The only work around is to not use parameterized queries which gives
you a huge performance hit.
David R.
 

Hello Lior
If you need a good solution take a look to Direct Oracle Access
(www.allroundautomations.com/doa.html)
this controls will give you quality and advanced options.
Mauricio.
"lior ilan" <XXXX@XXXXX.COM>writes

I removed all query.Prepare/unprepare commands long time ago.
Is it ok to use the query this way :
With Query1 Do
Begin
Sql.Clear;
Sql.add('select custno,balance where type1=:type1');
ParamByName('type1').DataType:=ftInteger;
ParamByName('type1').Value:=5;
Open;
.......
Close;
Sql.Clear;
End;
"David R. Robinson" <XXXX@XXXXX.COM>wrote in
message news:40153848$XXXX@XXXXX.COM...

that compiled the query on the server that was causing the problem I was
referring to.
Typically you use parameterized queries so you can issue the query multiple
times and don't have to have the server compile the query every time. You
simply can not do this with Oracle and the BDE reliably due to the memory leak
problem.
David R.