Devart Forums

Hey,
I'm moving my software from paradox to mysql, and using your components, i noticed however that setrange is not available, same for indexnames, and the batchmove components, so i was wondering if it's not implemented is there a replacement?
also the findkey and findnearest only work on primary key as i can't set the index, what's the solution for that? i can use locate for findkey but does it work in place of findnearest?

Thank you

ghaith wrote:I'm moving my software from paradox to mysql, and using your components, i noticed however that setrange is not available, same for indexnames, and the batchmove components, so i was wondering if it's not implemented is there a replacement?

MyDAC components is specified for working with MySQL.
MyDAC does not support the SetRange method. You can use the TCustomDADataSet.Filter property for local filtering of a dataset and the TCustomDADataSet.FilterSQL property for filtering on the server side instead.
For specifying of a table index you can specify need index fields in the TMyTable.OrderFields property.
The analogue of TBatchMove is the TCRBatchMove component. Also there is the TMyLoader component for fast data loading to the server.

You can find more detailed information about these components in the MyDAC help.

ghaith wrote:also the findkey and findnearest only work on primary key as i can't set the index, what's the solution for that? i can use locate for findkey but does it work in place of findnearest?

You may use the TMemDataSet.LocateEx method with the Option parameter equal to lxNearest instead of the FindNearest method for any fields.