Kbase P26618: Error 9799 using a Delphi application when executing an SQL-
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/06/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
The SQL engine Statement Manager statement cache overflowed. <number> statements are currently in use ( <type of cache> cache). (9799)
Running a Delphi 5 application through the Progress 9.1D SP6 ODBC driver.
Using the Borland Database Engine (BDE)
CAUSE:
When a TQuery has not been prepared (i.e. the Prepared property is False), Delphi will automatically prepare it each time it is executed. If the same query is being executed over and over again, then this will result in unnecessary prepared statements in the Progress SQL-92 statements cache.
Additionally the problem in DELPHI 5 happens due to the BDE (Borland Database Engine). This component always unprepares the SQL statement.
FIX:
Use the DBExpress in Delphi 6 to access the database without BDE. With this you can manually Prepare and UnPrepare SQL Statements.
Basically you need to find a way to manually Prepare and Unprepare the statements. Please contact Borland for further help.