Interaction of CursorLocation, CursorType and prepared properties with ADO TADODataSet

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

Article #5549

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

#5549

From: Peter Falconer
Date: Tue, 10 Apr 2001 00:48

24 lines
1921 bytes

Can anyone clarify the interaction of CursorLocation, Cursortype and
the 'prepared' properties for me?

I have a TADODataSet connected to a DBGrid.
CommandType = cmdText
CursorLocation = useServer
CursorType = ctStatic
prepared = false
CommandText = select distinct ACCRUNCODE, ACCRUNDATE, DESCRIPTION from
ACCOUNTRUN

The SQL appears to work fine when run through Microsoft's Query
Analyzer, but I have mixed success when trying to set the dataset to
active in the IDE.  Cycling through various combinations of the three
properties in question I either get the ever helpful 'Errors
occurred', or 'the required properties cannot be supported' or
(occasionally) 'does not support bookmarks which are required for
multi-record operations' or (even more occasionally(or is it less
occasionally?)) the bloody thing works! I have run across similar
problems in the past and managed to bumble my neophyte way around
them, but I would dearly love to know what was actually going on.

Anticipatory thanks
Peter

Technical Details

Message-ID: <3ad257de_2@dnews>

Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,407a7cd5616823ff,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-04-09 17:50:06 PST
From: "Peter Falconer" <Peter.Falconer@fsunion.org.au>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Interaction of CursorLocation, CursorType and prepared properties with ADO TADODataSet
Date: Tue, 10 Apr 2001 10:48:42 +1000
Lines: 25
Organization: FSU
MIME-Version: 1.0
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
NNTP-Posting-Host: 203.55.24.2
Message-ID: <3ad257de_2@dnews>
X-Trace: dnews 986863582 203.55.24.2 (9 Apr 2001 17:46:22 -0700)
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews