Filter and Locate

[FerCastro]

Hello all

I am trying to use the locate method whith the following code:

VTPCon.Locate('ID_Emp;CCon', VarArrayOf(['nID_Emp;cClaveCon']), []);

But I can not locate the record. Is there something wrong?


---
I am trying to filter the same virtual table with the following code:

VTPCon.Filter := 'ID_Emp = ' + VTMov.FieldByName('ID_Emp').AsString;
VTPCon.Filtered := true;


---

Do am I missing something? Thanks and best regards!!

[FerCastro]

Locate is orking fine, but the filter still doesn't works.

Any sugestion?

Regards!!

[AlexP]

Hello,

Judging by the code

Code: Select all

VTPCon.Filter := 'ID_Emp = ' + VTMov.FieldByName('ID_Emp').AsString;
FNominaData.VTPeriodoConceptos.Filtered := true;

You are setting the filter value in the VTPCon table, and the Filtered parameter value - in the VTPeriodoConceptos table. Please make sure you are working with one and the same table

[FerCastro]

Hello Alex!!

Working fine both procedures!

Thanks and best regards!!

[AlexP]

You are welcome. Feel free to contact us if you have any further questions about VirtualTable.