Article View: borland.public.cppbuilder.database.ado
Article #5772Too many columns...
From: Lance Robaldo
Date: Fri, 09 Feb 2001 14:58
Date: Fri, 09 Feb 2001 14:58
18 lines
1561 bytes
1561 bytes
We're using an Oracle 8i database and we have a table with 478 columns, I know, that's a LOT of columns, but we need them this way, it would be VERY impractical to break them up into multiple tables. If I use a TTable, I have no problems at all, other than it's S L O W. But if I use a TADOTable with Client-side Cursor I get a "Too many columns" error. If I change it to a Server-side Cursor I can open and read the dataset, but I can't use controls that display multiple rows (like dbGrid). Is there any work around to this? I'd like to use ADO because it's substantially faster, but I can't use it if it doesn't allow me to have a lot of columns, or if it won't work with multi-record components. Thanks. Lance Robaldo lance@Robaldo.com
Technical Details
Message-ID:
<3a8405fd_1@dnews>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-04!supernews.com!xfer13.netnews.com!netnews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!4.33.198.101Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,de6a9360c62da9c7,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-02-09 07:05:19 PST From: "Lance Robaldo" <lance@e-machines.net> Newsgroups: borland.public.cppbuilder.database.ado Subject: Too many columns... Date: Fri, 9 Feb 2001 09:58:15 -0500 Lines: 20 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 NNTP-Posting-Host: 4.33.198.101 Message-ID: <3a8405fd_1@dnews> X-Trace: 9 Feb 2001 07:00:13 -0800, 4.33.198.101 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-04!supernews.com!xfer13.netnews.com!netnews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!4.33.198.101