how to clone a dataset without moving the course of the dataset being cloned

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
gss200610
Posts: 35
Joined: Mon 23 May 2016 22:29

how to clone a dataset without moving the course of the dataset being cloned

Post by gss200610 » Fri 18 May 2018 11:54

I have situations that I am inserting into a uniquery and I need to clone it to check if a certain record exists in memory, how to do this without it canceling the dataset in editing or insertion?

already tried in several ways, if the dataset being cloned is in edit state or insertion the automatic cancellation unit before copying, how to solve this?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: how to clone a dataset without moving the course of the dataset being cloned

Post by ViktorV » Mon 21 May 2018 07:52

Currently, IBDAC does not support the specified functionality.
If you want us to implement the feature, please post it at our user voice forum: https://devart.uservoice.com/forums/104 ... ed-cursors. If the suggestion gets a lot of votes, we will consider the possibility to implement it.
You can try to use next code:

Code: Select all

  UniQuery2.Assign(UniQuery1);
  UniQuery2.Open;
  UniQuery2.GotoCurrent(UniQuery1);
Note, this solution does not assign UniQuery1 execution results to UniQuery2 results, therefore, the data will be fetched again.

gss200610
Posts: 35
Joined: Mon 23 May 2016 22:29

Re: how to clone a dataset without moving the course of the dataset being cloned

Post by gss200610 » Mon 21 May 2018 10:07

how much will we have aggregate fields in uniquery?
and the cascade feature in master detail with cached update?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: how to clone a dataset without moving the course of the dataset being cloned

Post by ViktorV » Mon 21 May 2018 10:50

We do not understand the essence of your question.
In order for us to be able to give you a detailed answer, please provide a more detailed and clear description of your question.

gss200610
Posts: 35
Joined: Mon 23 May 2016 22:29

Re: how to clone a dataset without moving the course of the dataset being cloned

Post by gss200610 » Mon 21 May 2018 11:29

how to use aggregate fields with unidac uniquery?
do you have MASTER DETAIL cascading recording option?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: how to clone a dataset without moving the course of the dataset being cloned

Post by ViktorV » Mon 21 May 2018 12:09

The similar question about aggregate fields has already been discussed on our forum in your topic: viewtopic.php?t=36624 for details.
IBDAC does not have the MASTER DETAIL cascading recording option.
You can get the necessary information about using master/detail relationship using our IBDacDemo project, on the 'General Demos\MasterDetail' tab, which you can find in the directory:%IBDACDemos%\IBDacDemo, where %IBDACDemos% is the path over which IBDAC Demo projects are installed on your computer.

Post Reply