Hello,
i have two tabes in a master/detail using two TMyQuery. When i try to insert a new detail record, i get this error inmediatly:
Cannot access field "myfield" as type Variant". I have not code in detail table events (like onNewRecord ..). I think the problem occurs in mydac libraries when it want to fill the foreign key for the detail table.
It seems to be a problem with the access to fields generated in delphi (TLargeInteger) (Integer unsigned in original table estructure).
What can i do?. I need help about this. Thank you.
rui.
My versions:
Delphi 7 c/s
MyDAC 3.30.2.15
MySQL 4.1.7.nt (TCP/IP)
master-detail with integer unsigned
Re: master-detail with integer unsigned
Because of Borland Delphi VCL restrictions (See unit DB, TLargeintField.SetVarValue) Int64-field cannot be used for binding Master-Detail tables.