Problem with dblookupcombobox

wernerconny · Post by **wernerconny** » Fri 25 Mar 2005 01:09

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 · Post by **Ikar** » Fri 25 Mar 2005 10:28

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.