CRBatchMove field type wrong

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
bwilt
Posts: 15
Joined: Wed 07 Aug 2013 01:45

CRBatchMove field type wrong

Post by bwilt » Mon 12 Aug 2013 22:18

Hello,
Just upgraded to 5.0.2.

I'm trying to use CRBatchMove but are getting the EDatabaseError: 'Cannot access field '<field_name>' as type DateTime.

In the database side of things <field_name> is actually a Memo blob so not sure why its being mapped to a DateTime.

I've tried putting in the following rule in both the database connection and Tables themselves :-

<table>.DataTypeMap.AddFieldNameRule('<field_name>', ftMemo);

but this makes no difference.....!?!!?

bwilt
Posts: 15
Joined: Wed 07 Aug 2013 01:45

Re: CRBatchMove field type wrong

Post by bwilt » Mon 12 Aug 2013 22:47

I see the from database field is ftMemo and the destination is ftWideMemo.

Still not sure why that gets mapped to a ftDateTime. The data gets displayed correctly from this database in a TDBRichEdit field.

bwilt
Posts: 15
Joined: Wed 07 Aug 2013 01:45

Re: CRBatchMove field type wrong

Post by bwilt » Tue 13 Aug 2013 03:49

Still get this error but not to waste time I iterate through the table and insert it myself which works without error.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: CRBatchMove field type wrong

Post by AlexP » Tue 13 Aug 2013 07:25

Hello,

Please specify the databases you are working with

bwilt
Posts: 15
Joined: Wed 07 Aug 2013 01:45

Re: CRBatchMove field type wrong

Post by bwilt » Tue 13 Aug 2013 08:53

database is access i.e. mdb via AccessProvider

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: CRBatchMove field type wrong

Post by AlexP » Tue 13 Aug 2013 10:32

Hello,

We cannot reproduce the problem, please send a small sample reproducing the problem (including the DB file) to alexp*devart*com , also specify the IDE version.

Post Reply