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!
Master/detail error
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
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
