Creating table with unsigned ints

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

Article #3988

Back to borland.public.cppbuilder.database.ado Previous Next

#3988

From: Chris Bandy
Date: Mon, 06 May 2002 08:15

18 lines
1421 bytes

Hi,

I am using ADOX to create an Access database and everything is working fine.
However, to increase the capacity of my program I realized I did not need to
use signed integers in my database. For some reason if I use unsigned
integers the table is not created.

Does Access not support adUnsignedInt or adUnsignedSmallInt ?

I do not see either mentioned here in table 6.4:
http://msdn.microsoft.com/library/en-us/dnacchbk/html/acsybex_chap6.asp

but they are mentioned here:
http://msdn.microsoft.com/library/en-us/ado270/htm/mdcstdatatypeenum.asp


Thanks in advance!
-- Chris

Technical Details

Message-ID: <3cd63b10$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,b46c822a3af0c40d,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-05-06 01:15:15 PST
From: "Chris Bandy" <cbandy@jbandy.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Creating table with unsigned ints
Date: Mon, 6 May 2002 03:15:57 -0500
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.4807.1700
NNTP-Posting-Host: 129.116.28.178
Message-ID: <3cd63b10$1_2@dnews>
X-Trace: dnews 1020672784 129.116.28.178 (6 May 2002 01:13:04 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews