Posting to AutoInc fields in SQL Server

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

Article #3516

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

#3516

From: Robert Lancaster
Date: Thu, 25 Jul 2002 13:53

19 lines
1753 bytes

Greetings,

I am writing a utility to migrate tables from SQL Server 6.5 to SQL Server
2000. Everything is working fine except for one small detail ... AutoInc
fields. I have executed the following statemnet via a TADOQuery component :
SET IDENTITY_INSERT SomeTable ON. I then copy the fields across field by
field. On executing Post the system returns the error "Multiple-step
operation generated errors. Check each status value." irst an an
EOleException then as a EDatabaseError. If I run Query Analyzer and add the
data manually using an insert statement it roks fine. What is the porblem ?
... and what can I dopto get around it ?

Before anyone shouts at me I will be posting this message to
borland.public.delphi.database.ado as well just in case there is someone
there who can help me who does not read this group.

Thanks,

Robert

Technical Details

Message-ID: <3d4002ca_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!newsfeed.gamma.ru!Gamma.RU!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,42aca66258b4db73,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-07-25 07:02:55 PST
From: "Robert Lancaster" <robert.lancaster@thales-geosolutions.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Posting to AutoInc fields in SQL Server
Date: Thu, 25 Jul 2002 15:53:13 +0200
Lines: 22
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: 196.15.157.2
Message-ID: <3d4002ca_1@dnews>
X-Trace: dnews 1027605194 196.15.157.2 (25 Jul 2002 06:53:14 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!newsfeed.gamma.ru!Gamma.RU!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews