TADOQuery Master/Detail with LockType ltBatchOptimistic

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

Article #1436

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

#1436

From: Scott Daily
Date: Thu, 22 Jul 2004 13:20

14 lines
1274 bytes

Hello,

I have a couple of TADOQueries setup for master/detail. I really want
to use a LockType of ltBatchOptimistic to reduce network traffic. I
have noticed, however, that when scrolling through the records in the
TDBGrid displaying the master records, it fetches the detail records in
what appears to be an 'as needed' basis.

Also, when I use adoqueryDetail->UpdateBatch(arAll); changes are not
updated and the values in the detail query go back to what they
originally were.

Any help appreciated,
Scott.

Technical Details

Message-ID: <40ffbf16@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,baaae314002d0279,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Scott Daily" <>
Subject: TADOQuery Master/Detail with LockType ltBatchOptimistic
Newsgroups: borland.public.cppbuilder.database.ado
User-Agent: XanaNews/1.16.3.1
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 81.137.14.60
Message-ID: <40ffbf16@newsgroups.borland.com>
Date: 22 Jul 2004 06:20:22 -0700
X-Trace: newsgroups.borland.com 1090502422 81.137.14.60 (22 Jul 2004 06:20:22 -0700)
Lines: 15
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail