Article View: borland.public.cppbuilder.database.ado
Article #6006Re: borland builder 5 and ms sql server7
From: Peter Dragun
Date: Thu, 16 Nov 2000 20:44
Date: Thu, 16 Nov 2000 20:44
38 lines
2014 bytes
2014 bytes
If you are using TAdoQuery or TAdoTable components, you double click on the component, it will bring up a window. Then you right click in the window, and "Add all fields", then you can bring up the properties for a particular field with the object inspector. Change the AutoGenerate value to "arAutoIncr". This will alowo c++builder auto increment your ID in your SQL Server database. -- Peter Dragun, pdragun@asifluid.com Alternate Solutions System/Software Designer - www.asifluid.com "Pablo" <kurzawki@poczta.onet.pl> wrote in message news:8v0io6$3rv3@bornews.inprise.com... > I have small problem. I made database in ms sql server 7. > In database I have table when field <id> is automatically number. When I use > dbgrid in borland builder 5, and I make insert in this table (I don't write > id), borland send message that id must be. Of course when I write id, > message send ms sql server. > > Question: > How turn off this control of sql syntax in dbgrid in borland c++? > > Thanks for every answer. > pk > > > > > >
Technical Details
Message-ID:
<3a141c6b$2_2@dnews>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!newsfeed.icl.net!news.algonet.se!algonet!neel.uni2.net!newssuck.uni2.dk!bornews.borland.com!dnews!24.141.25.94References:
<8v0io6$3rv3@bornews.inprise.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,5ae77ed22770ead7 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2000-11-16 09:42:21 PST Reply-To: "Peter Dragun" <pdragun@asifluid.com> From: "Peter Dragun" <pdragun@asifluid.com> Newsgroups: borland.public.cppbuilder.database.ado References: <8v0io6$3rv3@bornews.inprise.com> Subject: Re: borland builder 5 and ms sql server7 Date: Thu, 16 Nov 2000 12:44:16 -0800 Lines: 42 Organization: Alternate Solutions 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: 24.141.25.94 Message-ID: <3a141c6b$2_2@dnews> X-Trace: 16 Nov 2000 09:42:03 -0800, 24.141.25.94 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!newsfeed.icl.net!news.algonet.se!algonet!neel.uni2.net!newssuck.uni2.dk!bornews.borland.com!dnews!24.141.25.94