Interaction of CursorLocation, CursorType and prepared properties with ADO TADODataSet

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Peter Falconer Tue, 10 Apr 2001 00:48

#5549

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads