Dataset does not support bookmarks... error

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

Article #2035

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

#2035

From: Francesco
Date: Mon, 17 Nov 2003 15:38

28 lines
1637 bytes


Hi, i've a problem with TADODataSet descendent components.

scenario:

- BCB5 PRO + ADO fully update
- MSSQL Server 2000, sp3

I have a TADOQuery component connected to sql server database, i set
CursorLocation = clUseServer
CursorType = ctDynamic

then i execute a select command, and if to TADOQuery is attached a
DBGrid component i've this error message:

 "Dataset does not support bookmarks, which are required for
multi-record data controls"
I've noticed that if i change property CursorLocation = clUseClient all
works fine.

Is it a bug/limitation of ADO components that are not able to show few
records in a DBGrid retrieving directly from server?? Becasuse in case
of clUseClient as far as i understood it copies records in a local
cache. Is there any way to solve this problem??


Thanks in advance, Francesco

Technical Details

Message-ID: <3fb8f987$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,408adaac6b71eb7d,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-11-17 08:39:46 PST
From: "Francesco" <.>
Subject: Dataset does not support bookmarks... error
Newsgroups: borland.public.cppbuilder.database.ado
User-Agent: XanaNews/1.15.7.4
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 217.172.212.72
Message-ID: <3fb8f987$1@newsgroups.borland.com>
Date: 17 Nov 2003 08:38:31 -0700
X-Trace: newsgroups.borland.com 1069087111 217.172.212.72 (17 Nov 2003 08:38:31 -0700)
Lines: 28
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail