Hello:


Thanks for the answer.


Best regards
Carlos Guzmán Álvarez

>From: "Ivan Prenosil" <prenosil@...>
>Reply-To: ib-support@yahoogroups.com
>To: <ib-support@yahoogroups.com>
>Subject: Re: [ib-support] Limits of firebird/interbase
>Date: Mon, 12 Aug 2002 16:15:13 +0200
>
> > -Max number of columns in a select statement
>
>I think the limit is the same as for table, i.e. select as many columns
>as you wish, but you can't exceed total width 64K.
>
>E.g. you can't do
>CREATE TABLE tab (x VARCHAR(20000));
>SELECT x,x,x,x FROM tab;
>
>
> > -Max length of a statment.
>
>There are many different limits, none of which is properly documented.
>E.g. max. length of SQL string, max. length of generated BLR,
>max. number of Joins, max. number of AND/OR operators, etc.
>
>
> > -Max number of columns in the order by clausule
>
>The documented limit is
>"Maximum size of key in sort clause = 32K"
>
>(But FB server complains at 64K)
>
>
>Ivan
>http://www.volny.cz/iprenosil/interbase
>

Un saludo

Carlos Guzmán Álvarez
Vigo-España

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

_________________________________________________________________
Únase al mayor servicio mundial de correo electrónico:
http://www.hotmail.com/es