TUniLoader respects "Data Type Mapping" of UniConnection ?
Posted: Fri 02 Sep 2022 21:04
I'm doing some tests with "TUniLoader" my source bank is a Firebird with Numeric(18, 2)
field the destination bank is a Postgres with Numeric(18, 12)
How could I configure the "Data Type Mapping" to do this conversion because it's giving "numeric field overflow" error
I've made several attempts to use the "Data Type Mapping" but I don't know how to proceed.
In the Origin bank I put the following in UniConnection
object UniConnection1: TUniConnection
AutoCommit = False
DataTypeMap = <
item
DBType = 408
FieldType = ftFMTBcd
FieldLength = 18
FieldScale = 12
end>
ProviderName = 'InterBase'
Database = 'D:\BDTest.Fdb'
Username = 'SYSDBA'
Connected = True
LoginPrompt = False
Left = 43
Top = 25
end
field the destination bank is a Postgres with Numeric(18, 12)
How could I configure the "Data Type Mapping" to do this conversion because it's giving "numeric field overflow" error
I've made several attempts to use the "Data Type Mapping" but I don't know how to proceed.
In the Origin bank I put the following in UniConnection
object UniConnection1: TUniConnection
AutoCommit = False
DataTypeMap = <
item
DBType = 408
FieldType = ftFMTBcd
FieldLength = 18
FieldScale = 12
end>
ProviderName = 'InterBase'
Database = 'D:\BDTest.Fdb'
Username = 'SYSDBA'
Connected = True
LoginPrompt = False
Left = 43
Top = 25
end