🚀 go-pugleaf

No, it is your bug. Use CursorType = ctKeyset or CursorType = ctStatic. It
is faster to work with forward-only read-only recordsets and ADO/OLEDB
returns recordset with requested functionality. If you do not ask for
bookmarks, they are not available.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi + ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)



"Francesco" <.> ???????/???????? ? ???????? ?????????:
news:3fb8f987$1@newsgroups.borland.com...
>
>
> 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