Re: Maximum size of SQL statement

Article View: borland.public.interbase.opensource

Article #328

Back to borland.public.interbase.opensource Previous Next

#328

From: Thomas Steinmaurer
Date: Mon, 18 Oct 2004 17:17

18 lines
1571 bytes

> I'm using IB6.Open version 6.0.2.0
>
> I have a table with 1,023 fields.  My SQL statement must refer to
> every field in the table, making the statement very large.
>
> What is the maximum size of SQL statement that IB can handle?

AFAIK, 64K. It might be less for SP and trigger, because
the generated BLR is restricted to 48K (or was it less?),
AFAIK.


Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com

Technical Details

Message-ID: <4173f957@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

References: <4172a622.2672663@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 106772,28adea62becabfa8
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Thomas Steinmaurer" <t.steinmaurer@_no_upscene_spam_.com>
Newsgroups: borland.public.interbase.opensource
References: <4172a622.2672663@newsgroups.borland.com>
Subject: Re: Maximum size of SQL statement
Date: Mon, 18 Oct 2004 19:17:35 +0200
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
NNTP-Posting-Host: 62.46.233.82
Message-ID: <4173f957@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1098119511 62.46.233.82 (18 Oct 2004 10:11:51 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Reply to Parent Message