Article View: borland.public.cppbuilder.database.ado
Article #2129Re: TADOTable and data-aware components, or TADO Command?
From: Mark Guerrieri
Date: Wed, 12 Nov 2003 18:43
Date: Wed, 12 Nov 2003 18:43
16 lines
2012 bytes
2012 bytes
I think the problem lies in the fact that the myODBC provider does not correctly handle TDateTime values in parameterized queries. When you Post, ADO is internally creating a parameterized SQL update command that includes all your SELECT fields in the WHERE clause, to make sure the record has not changed since you queried it. There are dynamic ADO proerties you can set on the TADOQuery object to tell ADO to only use the primary key in the WHERE clause when updating, but you loose the oportunistic locking. You can try setting the "Update Criteria" property to adCriteriaKey for starters. see the following site for a great description of how ADO updating works and how you can customize it: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbdev00/html/vb00e1.asp Hope this helps- Mark
Technical Details
Message-ID:
<3fb27f49$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3faacfde@newsgroups.borland.com> <3fadac99$1@newsgroups.borland.com> <3fb16707$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,576fb9af2138d9fa X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-11-12 11:10:08 PST Reply-To: "Mark Guerrieri" <mguerrieri@cmsgrp.com> From: "Mark Guerrieri" <mguerrieri@cmsgrp.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3faacfde@newsgroups.borland.com> <3fadac99$1@newsgroups.borland.com> <3fb16707$1@newsgroups.borland.com> Subject: Re: TADOTable and data-aware components, or TADO Command? Date: Wed, 12 Nov 2003 13:43:18 -0500 Lines: 19 Organization: Creative Marketing Strategies X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 66.200.143.50 Message-ID: <3fb27f49$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1068662601 66.200.143.50 (12 Nov 2003 10:43:21 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail