WHERE in UPDATE SQL in TADOTable

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

Article #5339

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

#5339

From: Kine
Date: Tue, 05 Jun 2001 09:23

2 lines
1181 bytes

I am using TADOTable component, but if I change some field and do Post(), I get errot that row can't be found (I am using ODBC with ADO). In ODBC log file is UPDATE sql which have all columns in WHERE statement. How can I mark columns for WHERE statement? The ProviderOption does nothing. The UPDATE sql generate ADO or ADOExpress class? (I tested it with MyODBC and ODBC driver for MS Access and in both case the WHERE clausule has been different)

Technical Details

Message-ID: <3b1ca525$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!skynet.be!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,d507f3d4335c2528,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-06-05 02:32:13 PST
From: "Kine" <sacekk@seznam.cz>
Sender: "Kine" <sacekk@seznam.cz>
Reply-To: "Kine" <sacekk@seznam.cz>
Subject: WHERE in UPDATE SQL in TADOTable
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 147.229.9.14 147.229.9.14    
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3b1ca525$1_2@dnews>
Date: 5 Jun 2001 02:23:49 -0700
X-Trace: dnews 991733029 207.105.83.65 (5 Jun 2001 02:23:49 -0700)
Lines: 4
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!skynet.be!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews