Devart Forums

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.....!?!!?

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.

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

Hello,

Please specify the databases you are working with

database is access i.e. mdb via AccessProvider

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.