"Key column information is insufficient or incorrect" error message.

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

Article #3282

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

#3282

From: David Senterfitt
Date: Tue, 15 Oct 2002 16:15

27 lines
2143 bytes

I have just started receiving the error message. I have been
reading the other posts accross this site and tried many of the
suggestions. None of them have worked so I needed to post my
situation. Here it is.

I am running MS SqlServer 2000 using the ADO library within my
C++ Builder App.

I have a stored procedure that returns a single record dataset
that has been created from a SELECT with several JOIN clauses.

I have an update trigger inside the database that updates a
table used for tracking.

If I disable the trigger then everything works correctly. I looked
for errors in the trigger. There are no errors.

Here is what I feel is happening. The ADO layer comunicates to
the database that it needs to update 1 record. The database
updates 1 record in the initial table.  The update trigger modifies 6 records accordingly. The database responds to the ADO
layer that it modified 6 records. The ADO layer performs an
error check and notifies the user with the error message.

Does anybody have any ideas?

Thank you,
David Senterfitt

Technical Details

Message-ID: <3dac3f14$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,1dc7348ba2624cad,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-10-15 09:37:14 PST
From: "David Senterfitt" <senterfd@gordon.army.mil>
Sender: "David Senterfitt" <senterfd@gordon.army.mil>
Reply-To: "David Senterfitt" <senterfd@gordon.army.mil>
Subject: "Key column information is insufficient or incorrect" error message.
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 198.26.132.99 198.26.132.99    
X-Forwarded-For: 147.51.213.41
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3dac3f14$1@newsgroups.borland.com>
Date: 15 Oct 2002 09:15:16 -0700
X-Trace: newsgroups.borland.com 1034698516 207.105.83.65 (15 Oct 2002 09:15:16 -0700)
Lines: 28
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail