Back to forum list… Back to Issues and Problems...

Datatype mismatch updating a field in a DBF (1 reply)

John G
2 years ago
John G 2 years ago

We recently upgraded an installation to IMan 4.2. This site has jobs that have been running in IMan 3.2 for a few years.

One of the DB Writers updates fields in a Foxpro DBF file. Since the upgrade, two fields cause IMan to throw Datatype Mismatch errors. One field is a decimal in IMan and a numeric in the DBF; the other is an integer in both systems.

What can I do to make these values compatible between the two systems? Modifying the DBF structure is out of the question. Anyway, it used to work just fine.

Support
2 years ago
Support 2 years ago

John, the DBWriter went through a rewrite.

DB Writer Change Notice (realisable.co.uk)

If there is a mismatch you could try changing the fields to Text...and then maybe the DBF driver will attempt the conversion.

Thanks

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close