Devart Forums

I am having problems with a TMyQuery with the following SQL:

SELECT p.CaptCtro, m.*
FROM medcambpnd p LEFT JOIN medicos m ON p.Medico=m.Medico
GROUP BY p.CaptCtro, m.Medico
ORDER BY p.CaptCtro, m.Medico

The table is displayed (initially) in a CRDBGrid without problem. When I try to move the cursor to another record, I get an "Invalid Variant operation". This happens regardles of the tables being readonly or not, and regardles of the grid (CRDbGrid or DBGrid).

If I display the table within the "Data editor" at design time, It displays and moves without a problem.

Any ideas on what is wrong??

I am converting a working application that was previously using zeos data components. This was working properly before using MyDac.

Regards
Jay

We couldn't reproduce the problem.
Please send us (mydac*crlab*com) a complete small sample to demonstrate it, 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

Have a look if you've calculated fields, or some OnGetText of the fields that you perform some operation.. Also datachange events, etc.. Mostly occurs on some of those events.