Dear all,
I use Lazarus v 2.0.6 and a mysql 8.0 database. I have created a new form with a DBLookupCombobox. The table loaded is having fields witht he tSQLQuery:
ID: integer with primary key,
NOM: varchar (20)
PRENOM : varchar (20)
Phone:: varchar (20)
Mail : varchar (20)
In the dbLookupCombobox, I have declared the datafield is NOM, the Data source : dbDataSource (as created in the form), Keyfield : NUM, Listfield : NOM and ListSource : dbDataSource.
With this config I always have an error Invalid Variant Type Cast just when I launch with the F9 key the execution. If I change the field NUM to mMAIL (for example), The result is OK.
It seems that when the returned field is an INteger, I have an error , with a string field there is no error.
Can you, please help me.
Nota : This table is visible with no error into the dbGrid , and I can use the NUM field for locate records.
Thanks in advance.