client-side cursor cloning

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Ludek
Posts: 296
Joined: Thu 12 Oct 2006 09:34

client-side cursor cloning

Post by Ludek » Tue 22 Jul 2008 07:00

Hi,
is it somehow possible to clone a "cursor" to one TMSQuery? Just to have one data storage and 2 independent pointers to its records.

Example: to have all prices listed in a tdbgrid and the lowest price in a tdbedit, both editable.

I need similar functionality to TClientDataset.CloneCursor, but really don't want to use TClientdataset - I don't want to lose the advanced tmsquery functionality like fetchall = false etc.
Thanks, Ludek.

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 22 Jul 2008 07:56

SDAC has no functionality similar to TClientDataset.CloneCursor.
> Example: to have all prices listed in a tdbgrid and the lowest price in a tdbedit, both editable.
Probably this problem can be solved with using TEdit instead of TDBEdit, or with copying record(s) to TVirtualTable, or in any other way.

Ludek
Posts: 296
Joined: Thu 12 Oct 2006 09:34

Post by Ludek » Tue 22 Jul 2008 12:47

:cry:
Sure, I have solved this problem this way already a few years ago, but i wanted to optimize it, it is a very ugly code full of detecting, who changes the data, whether the user or the sync algorithm.
Is there any chance, you will implement such method in the (near?) future?

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 22 Jul 2008 13:38

It is unlikely as this is not an asked-for feature and it requires significant changes in code.

Post Reply