VirtualTable and change indexfieldnames problem

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Giovanna
Posts: 25
Joined: Tue 21 Jul 2009 07:44
Location: Italy

VirtualTable and change indexfieldnames problem

Post by Giovanna » Wed 14 Oct 2015 09:56

Hello,
I have this problem: when I change a value of indexFieldNames of a VirtualTable, that was different at design time, an error occured that say that the field was not found, but it is the same of prior setting in different order, for example:
VirtualTable.IndexFieldNames := 'ANCFOR;ANCDATA'
at design time
After the user change the order, I setting
VirtualTable.IndexFieldNames := 'ANCDATA;ANCFOR'
and at this time, I see the error 'Field ANCDATA not found'

How can I do for change the IndexFieldNames?
Thanks in advance.
Giovanna Cellitti.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: VirtualTable and change indexfieldnames problem

Post by AlexP » Thu 15 Oct 2015 07:26

Hello,

We can't reproduce the problem. Please specify the exact versions of UniDAC and IDE and compose a small simple sample reproducing the problem and send it to alexp*devart*com .

Giovanna
Posts: 25
Joined: Tue 21 Jul 2009 07:44
Location: Italy

Re: VirtualTable and change indexfieldnames problem

Post by Giovanna » Fri 16 Oct 2015 10:31

My project(first) is very complicated and therefor I have make a simply project (second) with the instruction of Virtual Table used.
This project with same instruction work fine.
Then, in debug of the first project,I have tested the Virtual Table and I casually
solved in this mode:
This is the example of project(first) correct:
QryLog2.Close;
QryLog2.Open; // Added because don't work indexfieldnames
QryLog2.Close; //Added because don't work indexfieldnames
cOrdine1 := 'ANCFOR;ANPCVA;ANTPAR';
If RadioGroup1.ItemIndex = 1 then
cOrdine1 := 'ANCFOR;ANPCVA';
cOrdine2 := ';ANDCAR;ANAPRA;ANTPRA;ANNRIG';
cOrdine1 := cOrdine1 + cOrdine2;
QryLog2.IndexFieldNames := cOrdine1;
QryLog2.Clear;
QryLog2.Open;
Best regards.
Giovanna Cellitti

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: VirtualTable and change indexfieldnames problem

Post by AlexP » Fri 16 Oct 2015 11:29

The provided steps don't lead to the error. Please send the complete sample.

Post Reply