Devart Forums

Hello,

I made a master detail form but when I try to insert a new record into the detail area I get the folowing error:

Cannot acces field 'website_id' as type variant.

I have made the same construction with ZEOS and it worked well.

How do I solve this problem.

Thanks in advance!

Please check if the fields you use for Master-Detail relationship are either of the following types:
INT UNSIGNED
BIGINT
BIGINT UNSIGNED
If this is true, try converting them to INT data type. If problem persists or you don't use such data types then send us (EvgeniyD*crlab*com) a complete small sample to demonstrate the problem, including script to create and fill table.
Also supply us following information
- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client. You can see it in Info sheet of TMyConnection Editor

Problem solved,

thanks, now I can sleep again at night!