Article View: borland.public.cppbuilder.database.ado
Article #3012Multiple-step operation generated errors. Check each status
From: Johny
Date: Sat, 25 Jan 2003 16:57
Date: Sat, 25 Jan 2003 16:57
28 lines
2285 bytes
2285 bytes
I wrote this:
adodsTransfersFilterOrgs->Close();
adodsTransfersFilterOrgs->CommandText="SELECT -1 AS OrgID, '-1' AS
OrgCode, 'Show All' AS OrgName, 'Show All' AS OrgCodeName UNION " + asBr
+ " SELECT 0 AS OrgID, '0' AS OrgCode, 'Budg' AS OrgName, 'Budg' AS
OrgCodeName UNION " + asBr
+ " SELECT -2 AS OrgID, '-2' AS OrgCode, 'Any' AS OrgName, 'Any
without Budg' AS OrgCodeName UNION " + asBr
+ " SELECT OrgID,OrgCode, OrgName, OrgCode + ' ' + OrgName AS
OrgCodeName FROM Basic_Orgs " + asBr
+ " WHERE IsActive=1 ORDER BY OrgCode";
adodsTransfersFilterOrgs->Open();
adodsTransfersFilterOrgs->Edit();
while(!adodsTransfersFilterOrgs->Eof) {
adodsTransfersFilterOrgs->FieldByName("OrgCodeName")->ReadOnly =
false;
adodsTransfersFilterOrgs->FieldValues["OrgCodeName"] =
frmMain_FW->ConvertToCyrillic(adodsTransfersFilterOrgs->FieldByName("OrgCode
Name")->AsVariant);
adodsTransfersFilterOrgs->Post();
adodsTransfersFilterOrgs->Next();
}
but on the end I get mistake: "Multiple-step operation generated errors.
Check each status
value.". How can I avoid that?
Technical Details
Message-ID:
<3e32c2d8@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!telocity-west!DIRECTV!news-out.spamkiller.net!propagator2-maxim!news-in.spamkiller.net!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,baab65c75d56b49,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-01-25 09:02:48 PST From: "Johny" <goky2002@beograd.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: Multiple-step operation generated errors. Check each status Date: Sat, 25 Jan 2003 17:57:54 +0100 Lines: 30 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 213.137.120.129 Message-ID: <3e32c2d8@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1043514072 213.137.120.129 (25 Jan 2003 09:01:12 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!telocity-west!DIRECTV!news-out.spamkiller.net!propagator2-maxim!news-in.spamkiller.net!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail