Problem with dblookupcombobox

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 1
Joined: Fri 25 Mar 2005 00:56

Problem with dblookupcombobox

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

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

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.

Post Reply