Field cannot be modified

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

Article #3006

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

#3006

From: Johny
Date: Wed, 22 Jan 2003 17:08

24 lines
1485 bytes

I have TAdoDataSet and command

adodsOs->CommandText="
SELECT OID,OCode, OName, OCode + ' ' + OName AS OValue

FROM Basic_Os
 WHERE IsActive=1
ORDER BY OCode";

And I want to transform OValue when I press button.

I wrote
adodsOs->First();
        while (!adodsOs->Eof) {
            adodsOs->Edit();
            adodsOs->FieldValues[OValue] =
Transform(adodsOs->FieldByName(OValue)->AsString);
            adodsOs->Post();
            adodsOs->Next();
        }

but I get error "Field OValue cannot be modified".

How can I avoid that?

Technical Details

Message-ID: <3e2ed0bb@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!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!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,d4680aadb996c822,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-01-22 09:17:25 PST
From: "Johny" <goky2002@beograd.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Field  cannot be modified
Date: Wed, 22 Jan 2003 18:08:19 +0100
Lines: 27
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.154
Message-ID: <3e2ed0bb@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1043255483 213.137.120.154 (22 Jan 2003 09:11:23 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail