Devart Forums

I test with both version and I have the same problem:
"invalida Variant Type Conversion"

This happend to execute the follow code:

dmN.tNicOcupa.SQL.Clear;
dmN.tNicOcupa.SQL.Text := 'Select Distinct Contrato From NicOcupa Order By Contrato';
dmN.tNicOcupa.Open;

Delphi 5
Windows Vista Bussines (new)
MyDac 5.50.34 and 5.50.35 (new)

Until I was worked with the follow enviroment all was fine
Delphi 5
Windows XP
MyDac 5.20

You Can help my, Thanks

Hi Almosqueda,

You should provide to Corelab support more informations :
- MySQL server version
- The 'NicOcupa' table structure + datas
- A simple Delphi project reproducing the issue

B.R.

Please send us a script to create and fill the 'NicOcupa' table.

Original Code that was worked for years until new version:

//Table slave from tOcupa
// Text of Query: Select * from Ocupa
tOcupaTmp.Open;
dmP.tOcupa.SQL.Clear;
dmP.tOcupa.SQL.Text := 'Select Distinct Contrato From Ocupa Order By Contrato';
dmP.tOcupa.Open; //Table master from tOcupaTmp

The solution was change order to open tables:

dmP.tOcupa.SQL.Clear;
dmP.tOcupa.SQL.Text := 'Select Distinct Contrato From Ocupa Order By Contrato';
dmP.tOcupa.Open; //Table master from tOcupaTmp

//Table slave from tOcupa
// Text of Query: Select * from Ocupa
tOcupaTmp.Open;

Thanks for all

It is good to see that this problem has been solved.