Too many columns...

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Lance Robaldo Fri, 09 Feb 2001 14:58

#5772

Author: Lance Robaldo
Date: Fri, 09 Feb 2001 14:58

18 lines
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

Re: Too many columns...

#5778

Author: Alexei Karas
Date: Mon, 12 Feb 2001 09:49

31 lines
2004 bytes

I'm pretty unsure that you need all columns simultaneously. So you may bind
your TADOTable to some View (or SELECT for Access).
In any case it's probably a bad database design...;)))

HTH,
   Alexei.

"Lance Robaldo" <lance@e-machines.net> wrote in message
news:3a8405fd_1@dnews...
> 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
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads