WHERE in UPDATE SQL in TADOTable

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

Article #5340

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

#5340

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

12 lines
1309 bytes

I'am sorry for that long line ;-)


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: <3b1ca896$1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

References: <3b1ca525$1_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,d507f3d4335c2528
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-06-05 02:43:42 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    
References:  <3b1ca525$1_2@dnews> 
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3b1ca896$1_1@dnews>
Date: 5 Jun 2001 02:38:30 -0700
X-Trace: dnews 991733910 207.105.83.65 (5 Jun 2001 02:38:30 -0700)
Lines: 14
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Reply to Parent Message