Board index » delphi » Delphi 1.0 Tquery failes with lines > 10???

Delphi 1.0 Tquery failes with lines > 10???

Hello Delphi gurus,

   I am using a TQuery who's SQL stringlist consist of more than 10
statements. Example :

1.     Query.Add('Exam.Name');
2.     Query.Add('Exam.Last');
     .  
     .  
 6.    Query.Add(Where X = X and ( ' );
        .
        .
10   Query.Add('  ) ')          

   with 10 lines altogether.

  What I have discovered is if the length the SQL list is greater than 10
statements the BDE blows up.
  Now, I've also tried using the interactive SQL program that comes with
the database desktop and when I tried a
  query with more than 10 lines the database desktop just exploded.
CABOOMMMMM.

 Now, this tells me there is something deeply wrong with the BDE's SQL
engine, because if I try the same experiment with
 9 lines it works perfectly.

 A final note, this problem does not occurr with DELPHI 2.0's BDE.

 If anyone can help me, I would greatly appreciate it.

                                                                Thanx,
                                                                        Xdamien (ENRIQUE BENEDETTI)

 

Re:Delphi 1.0 Tquery failes with lines > 10???


Quote
"Enrique Benedetti" <xdam...@interport.net> wrote:
>Hello Delphi gurus,
>   I am using a TQuery who's SQL stringlist consist of more than 10
>statements. Example :

>1.     Query.Add('Exam.Name');
>2.     Query.Add('Exam.Last');
>     .      
>     .      
> 6.    Query.Add(Where X = X and ( ' );
>        .
>        .
>10   Query.Add('  ) ')              

>   with 10 lines altogether.
>  What I have discovered is if the length the SQL list is greater than 10
>statements the BDE blows up.
>  Now, I've also tried using the interactive SQL program that comes with
>the database desktop and when I tried a
>  query with more than 10 lines the database desktop just exploded.
>CABOOMMMMM.
> Now, this tells me there is something deeply wrong with the BDE's SQL
>engine, because if I try the same experiment with
> 9 lines it works perfectly.
> A final note, this problem does not occurr with DELPHI 2.0's BDE.
> If anyone can help me, I would greatly appreciate it.
>                                                            Thanx,
>                                                                    Xdamien (ENRIQUE BENEDETTI)

There is not a 10 line limit with TQuery.  I have many TQuery objects
that have exceeded that and one that even had 43 lines.  Other
possibilities are the DB or your query.  Have you tried the query
using the databases native SQL tool (i.e. SQLPlus or Oracle or ISQL
for Interbase)?

- Rick Hammel

Other Threads