Problem with dblookupcombobox

Problem with dblookupcombobox

Postby 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
Posts: 1
Joined: Fri 25 Mar 2005 00:56

Postby 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.
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Return to MySQL Data Access Components