Problem with dblookupcombobox

[wernerconny]

trying to bind two fields of different mysql table by a dblookupcombobox results in an error telling me '..not able to access field 'xxx' as variant value'.
Why is this.
With ODAC on ORACLE it always works.
Using last edition of MDAC and Mysql 4.0.23 and delphi 7 on win2000.

Thank you for your help

[Ikar]

Most probably, you use TLargeIntField (BIGINT or UNSIGNED INT). This field cannot be used as Lookup (see method TLargeintField.SetVarValue). Declare this field at the server as INT.