ADO Charset problem with deleteRecords (ADOTable)

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

Article #496

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

#496

From: Yannick
Date: Mon, 22 Aug 2005 15:21

25 lines
2078 bytes

Hello,

I am using ADO Components since I have to handle both DBF and MDB files
with the same code.
While trying to Empty the tables, everything works fine until there is
a line containing an accent (e.g. "é" or "è") in the database. Then,
in the FieldByName properties, the char turns into a "+" and when it
has to delete this line, it says: "la ligne n'a pas pu être trouvée
pour la mise à jour" ("update failed because the row to update could
not be found").
This simple code is:

        T_IDENTITE->Active=true;
        T_IDENTITE->First();
        while (!T_IDENTITE->Eof)
        {
            T_IDENTITE->DeleteRecords(arCurrent);  // -> Exception here
            T_IDENTITE->UpdateBatch(arCurrent);
        }
        T_IDENTITE->Active=false;

I set the Locale Identifier to 1036 (in ConnectionSttring) that is for
french charset but issue stays the same.
Any help would be greatly appreciated!
Thanks

Technical Details

Message-ID: <1124724100.649736.193240@g44g2000cwa.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!g44g2000cwa.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,c9d016f8d7f6c089,start
X-Google-Thread: 10288e,c9d016f8d7f6c089,start
X-Google-Attributes: gid10698b,gid10288e,public
X-Google-Language: ENGLISH,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!g44g2000cwa.googlegroups.com!not-for-mail
From: "Yannick" <ybarbeaux@gmail.com>
Newsgroups: borland.public.cppbuilder.database.ado,borland.public.cppbuilder.database
Subject: ADO Charset problem with deleteRecords (ADOTable)
Date: 22 Aug 2005 08:21:40 -0700
Organization: http://groups.google.com
Lines: 26
Message-ID: <1124724100.649736.193240@g44g2000cwa.googlegroups.com>
NNTP-Posting-Host: 194.78.197.250
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1124724106 3439 127.0.0.1 (22 Aug 2005 15:21:46 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 22 Aug 2005 15:21:46 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g44g2000cwa.googlegroups.com; posting-host=194.78.197.250;
   posting-account=oNwKxA0AAAD9haiSFLguSTupc4D9yOoG