Locate with Caculated field

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ioda
Posts: 12
Joined: Fri 08 Feb 2008 15:11

Locate with Caculated field

Post by ioda » Wed 01 Oct 2008 21:39

I would like to know if is possible to do locate on VirtualTable with Caculated or Lookup Field. Because I always receive this error message :

---------------------------
Project1
---------------------------
Field ****** not found.
---------------------------
OK
---------------------------

Do you have a solution
thank you

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 02 Oct 2008 09:31

TVirtualTable does not create FieldDescs for saving values of calculated and lookup fields, therefore you can't use the Locate method for these fields in VirtualTable.
Use dataset that has linked database table.

Post Reply