MyDac 5.20.0.13 : EConvertError exception is raised when modifying any data type

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
swierzbicki
Posts: 451
Joined: Wed 19 Jan 2005 09:59

MyDac 5.20.0.13 : EConvertError exception is raised when modifying any data type

Post by swierzbicki » Thu 31 Jan 2008 16:05

Hi,

I'm getting Exception Classe EConvertError with message 'Cannot convert type'

This exception is raised from the memdata unit : procedure TData.PutFieldAsVariant

When debugging, Value = 1

Code: Select all

   dtInt64:
      case VarType(Value) of
      {$IFDEF VER6P}
        varInt64: begin
          i64 := Value;
          Marshal.WriteInt64(FieldData, i64);
        end;
      {$ELSE}
        varDecimal:
          Int64(FieldData^) := TVarDataD6(Value).VInt64;
      {$ENDIF}
      else
        raise EConvertError.Create(SCannotConvertType);
      end;
Last edited by swierzbicki on Fri 01 Feb 2008 08:36, edited 1 time in total.

swierzbicki
Posts: 451
Joined: Wed 19 Jan 2005 09:59

Post by swierzbicki » Thu 31 Jan 2008 20:19

I have sent you you a demo + sql script that reproduce this issue

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 05 Feb 2008 09:29

We have received your demo and answered you by e-mail.

pris.almeida
Posts: 1
Joined: Thu 14 Mar 2013 20:26

Re: MyDac 5.20.0.13 : EConvertError exception is raised when modifying any data type

Post by pris.almeida » Thu 14 Mar 2013 20:29

Hi... I'm having the same problem. How did you resolve this?

Thanks,
Priscilla

DemetrionQ
Devart Team
Posts: 271
Joined: Wed 23 Jan 2013 11:21

Re: MyDac 5.20.0.13 : EConvertError exception is raised when modifying any data type

Post by DemetrionQ » Mon 18 Mar 2013 15:11

Hello.

Please describe in more details the situation, when the error occurs. Also try downloading the latest MyDAC version 7.6.12 and check if the problem repeats.

neifirst
Posts: 3
Joined: Fri 09 Jan 2015 21:32

Re: MyDac 5.20.0.13 : EConvertError exception is raised when modifying any data type

Post by neifirst » Fri 09 Jan 2015 21:35

I am also running into this same situation after upgrading my project to Delphi XE7 and MyDAC to 8.4.12. When I attempt to refresh any DataSet from a TMyTable, I get this exception.

Here's a bit of the thread leading up to this error:
main thread ($2478):
0077e711 +29d FSTdb.exe MemData TData.PutDataAsVariant
0077f7a0 +0b8 FSTdb.exe MemData TData.PutFieldAsVariant
00828b33 +407 FSTdb.exe DBAccess CopyRecBuf
00828c62 +04a FSTdb.exe DBAccess ReadUQFields
008295f3 +7f3 FSTdb.exe DBAccess TDADataSetUpdater.PerformSQL
0082a450 +054 FSTdb.exe DBAccess TDADataSetUpdater.PerformRefreshRecord
008202bd +061 FSTdb.exe DBAccess TCustomDADataSet.RefreshRecord
01171633 +04f FSTdb.exe DBFra 437 +4 TDBFrame.RefreshRecord

Any help would be appreciated, as I'm not sure how to proceed. Thanks!

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: MyDac 5.20.0.13 : EConvertError exception is raised when modifying any data type

Post by ViktorV » Tue 13 Jan 2015 11:44

Unfortunately, we could not reproduce the issue. Please send us a small sample to demonstrate the issue to viktorv*devart*com, including a script to create and fill in the test database object.

neifirst
Posts: 3
Joined: Fri 09 Jan 2015 21:32

Re: MyDac 5.20.0.13 : EConvertError exception is raised when modifying any data type

Post by neifirst » Tue 13 Jan 2015 15:59

I believe I've found the issue. Before upgrading to XE7 and MyDAC 8.4.12, I had been running under XE4. I was using a type workaround that was needed for certain version 7 releases of MyDAC 7, detailed here: http://forums.devart.com/viewtopic.php?f=7&t=26116

Once I removed this, everything began working normally. I'm hoping that the type incompatibility issue that this workaround resolved has been resolved in subsequent MyDAC releases.

Thanks!

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: MyDac 5.20.0.13 : EConvertError exception is raised when modifying any data type

Post by ViktorV » Thu 15 Jan 2015 10:16

Glad to see that the issue was resolved. The fix for types incompatibility will be included into one of the next MyDAC builds.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: MyDac 5.20.0.13 : EConvertError exception is raised when modifying any data type

Post by ViktorV » Wed 15 Apr 2015 10:33

The new MyDAC version 8.5.14 with a fix for this issue are available for download now.

Post Reply