Maximum size of SQL statement

Article View: borland.public.interbase.opensource

Article #316

Back to borland.public.interbase.opensource Previous Next

#316

From: Red
Date: Sun, 17 Oct 2004 17:06

8 lines
987 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?

Thanks in advance.

Technical Details

Message-ID: <4172a622.2672663@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 106772,28adea62becabfa8,start
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: nospam_kandw321@icrossroads.com (Red)
Newsgroups: borland.public.interbase.opensource
Subject: Maximum size of SQL statement
Date: Sun, 17 Oct 2004 17:06:53 GMT
Message-ID: <4172a622.2672663@newsgroups.borland.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: 142.179.164.127
X-Trace: newsgroups.borland.com 1098032930 142.179.164.127 (17 Oct 2004 10:08:50 -0700)
Lines: 8
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail