Dbase export: Invalid conversion for ftDBaseOLE field
Original Reporter info from Mantis: BigChimp
-
Reporter name: Reinier Olislagers
Original Reporter info from Mantis: BigChimp
- Reporter name: Reinier Olislagers
Description:
Either the fpdbfexport or more probably the dbf units seem to incorrectly treat ftDBaseOLE fields as date/time field. See additional information.
Steps to reproduce:
Compile and run attached test program.
Additional information:
Output on my system:
Time:00.014 N:1 E:1 F:0 I:0
TTestDBFExport1 Time:00.014 N:1 E:1 F:0 I:0
00.014 TestDBExportRuns Error: EDatabaseError
Exception: Invalid type conversion to TDateTime in field ftDBaseOle
Source unit: fields.inc
Method name: TFIELD__GETASDATETIME
Line number: 427
Number of run tests: 1
Number of errors: 1
Number of failures: 0
List of errors:
Error:
Message: TTestDBFExport1.TestDBExportRuns: Invalid type conversion to TDateTime in field ftDBaseOle
Exception class: EDatabaseError
Exception message: Invalid type conversion to TDateTime in field ftDBaseOle
Source unitname: fields.inc
Line number: 427
Failed methodname: TFIELD__GETASDATETIME
*** Starting to fill row 1
*** Finished filling row 1
*** Starting to fill row 2
*** Finished filling row 2
*** Starting to fill row 3
*** Finished filling row 3
*** Starting to fill row 4
*** Finished filling row 4
Mantis conversion info:
- Mantis ID: 20069
- OS: Windows
- OS Build: Vista
- Build: FPC git 27 August 2011
- Platform: x64
- Version: 2.7.1
- Fixed in version: 2.6.0
- Fixed in revision: 18945 (#80c8cdcf)
- Target version: 2.6.0