Devart Forums

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.

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 .

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

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