|
| Max Length SQL Statement |
 |
Fri, 2 Nov 2007 20:41:37 -0500 |
I have a screen which could potentially generate some really really long SQL
commands. When sending an SQL statement to the Interbase server, is there a
limitation on how long the query string can be? If so, how long?
Thanks,
- Jason
|
| Post Reply
|
| Re: Max Length SQL Statement |
 |
2 Nov 2007 21:38:13 -0700 |
Jason Summers wrote:
> I have a screen which could potentially generate some really really
> long SQL commands. When sending an SQL statement to the Interbase
> server, is there a limitation on how long the query string can be?
> If so, how long?
>
> Thanks,
> - Jason
In IB 5.x time, 220k was too large for a single sql statement. It seems
to me the limit was either 32 or 64k but that was a long time ago.
hth
--
|
| Post Reply
|
| Re: Max Length SQL Statement |
 |
Sat, 03 Nov 2007 13:26:53 +010 |
> I have a screen which could potentially generate some really really long
> SQL commands. When sending an SQL statement to the Interbase server, is
> there a limitation on how long the query string can be? If so, how long?
~ 64K
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
|
| Post Reply
|
| Re: Max Length SQL Statement |
 |
Sat, 3 Nov 2007 16:04:56 -0500 |
Thanks guys. I don't think my statements will ever exceed 64k, but it's
good to know this isn't going to be an issue.
- Jason
"Thomas Steinmaurer"
<t.steinmaurer_dontbugmewithspam_@upscene.com> wrote in
message news:472c68ec$1@newsgroups.borland.com...
>> I have a screen which could potentially generate some really really
long
>> SQL commands. When sending an SQL statement to the Interbase server,
is
>> there a limitation on how long the query string can be? If so, how
long?
>
> ~ 64K
>
>
> --
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com
|
| Post Reply
|
| Re: Max Length SQL Statement |
 |
5 Nov 2007 05:39:18 -0700 |
In addition to the limitation on length, there is also a limitation on
the number of conjuncts in a WHERE clause, which varies by IB version,
IIRC.
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Everything You Need to Know About InterBase Character Sets:
|
| Post Reply
|
|
|
|
|
|
|
|
|
|