Thread View: borland.public.cppbuilder.database.multi-tier
3 messages
3 total messages
Started by PRG
Thu, 08 Feb 2001 00:05
Table Index Question
Author: PRG
Date: Thu, 08 Feb 2001 00:05
Date: Thu, 08 Feb 2001 00:05
12 lines
1308 bytes
1308 bytes
I am using MS-Access and have defined a field with a size of 150. When attempting to select the index name for this field it is unavailable in a TTable component. If I reduce the size to say... 50, it is then visible. Would this be a setting somewhere that is causing this, or a compatability issue. FYI Paradox table with same definition works fine. cpp builder v.4 access 2000 connecting via odbc Thanks in advance, if this isnt the correct place for this post please let me know.
Re: Table Index Question
Author: Jerry Bloomfield (TeamB)
Date: Sat, 10 Feb 2001 21:48
Date: Sat, 10 Feb 2001 21:48
22 lines
2046 bytes
2046 bytes
On Wed, 7 Feb 2001 19:05:07 -0500, "PRG" <dork@dork.net> wrote: >I am using MS-Access and have defined a field with a size of 150. When >attempting to select the index name for this field it is unavailable in a >TTable component. If I reduce the size to say... 50, it is then visible. >Would this be a setting somewhere that is causing this, or a compatability >issue. FYI Paradox table with same definition works fine. I am not sure about the MS-Access limits (and they probably vary by Access version), but it sounds like you have exceeded the maximum length of an index. I encountered this problem on an SQL Server a while back when I tried to add a 255 byte text field to a key on a table... Each database format/engine has its own limitations on what are acceptable, and it sounds like you found one limitation where MS-Access is less flexible than Paradox... Jerry Bloomfield (TeamB) -- http://www.teamb.com JersWork@wwa.com Please do *NOT* send private e-mail without prior permission (my anti-spam filters will probably just delete it anyway <g>)
Re: Table Index Question
Author: PRG
Date: Sun, 11 Feb 2001 00:26
Date: Sun, 11 Feb 2001 00:26
30 lines
2344 bytes
2344 bytes
Yep, you are right, I dropped the index field size to 125 and the index was then visible, dont understand the limitation, but I suppose if I thought like MS then I wouldnt be here... Thanks "Jerry Bloomfield (TeamB)" <JersWork@wwa.com> wrote in message news:hjdb8t87c7afj3ht4grob3l6omqvgepi1i@4ax.com... > On Wed, 7 Feb 2001 19:05:07 -0500, "PRG" <dork@dork.net> wrote: > > >I am using MS-Access and have defined a field with a size of 150. When > >attempting to select the index name for this field it is unavailable in a > >TTable component. If I reduce the size to say... 50, it is then visible. > >Would this be a setting somewhere that is causing this, or a compatability > >issue. FYI Paradox table with same definition works fine. > > I am not sure about the MS-Access limits (and they probably vary by Access > version), but it sounds like you have exceeded the maximum length of an > index. I encountered this problem on an SQL Server a while back when I > tried to add a 255 byte text field to a key on a table... > > Each database format/engine has its own limitations on what are acceptable, > and it sounds like you found one limitation where MS-Access is less > flexible than Paradox... > > Jerry Bloomfield (TeamB) > -- > http://www.teamb.com JersWork@wwa.com > Please do *NOT* send private e-mail without prior permission (my anti-spam > filters will probably just delete it anyway <g>)
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