At 02:27 AM 3/03/2006, Kurt Schneider wrote:

>Hello
>
>"I'm Sorry my bad English."

Please respond to the questions:

>I'm a problem with a long sql's with select in Views.

What is "long"? There is a limit of 64 Kb in the length of one SQL
statement and a limit of 48 Kb in the length of a plan.

>When acessing with the same select and view more than 5 times the database
>shutdown and display Invalid BLR.
>Exactly, when acessing de view over 5 times, shutdown the database. I have
>an unic view on database.

Show exactly the problem statement *and* the plan that is produced
when you prepare a similar statement that does not fail.

Also state

a) whether you have triggers defined for the view.
b) what is the dialect of the database
c) what you mean by "an unic view on database"

>Its a great problem, the same SQL is executed in SQL Server, MySQL, Oracle
>Free (10g) and the error not Ocurred.
>
>I'm thinking this is a Bug, but, not find the correction.

To find the cure, one must first find the problem.

>Necessary on aid to decide this, the current project and the continuity of
>the use of the Firebird depend on this solution.
>
>The Sql Query have 6.634 Bytes.

I do not believe this. :-)

>I'm using Firebird 1.5.2 with ODBCJDBC_2.0 (DLL). and Delphi 7. (ADOQuery)

./heLen