Data Type Mapping Firebird Domains at design time

[FredS]

In my first test I used Boolean as a Domain and mapping was perfect but reading a bit it made sense to change that to fbBoolean in case future versions restrict the word 'Boolean'.

Now I see that the Domains do not show up in the drop down box of the Data mapping tool. How do we handle this?

[ViktorV]

Unfortunately, at the moment IBDAC doesn't support this functionality.
The 'Database Type' drop-down list is generated not automatically requesting data from the server, but statically using predefined DBMS data types.
Therefore you won't be able to get your predefined domain types in this list.
You can map data with such types using 'Field Name' of the required columns.
Example:

Code: Select all

UniTable1.DataTypeMap.AddFieldNameRule(YourFieldName, ftBoolean);

More details about Data Type Mapping can be found in the UniDAC documentation: http://www.devart.com/unidac/docs/data_type_mapping.htm

[FredS]

Not the answer I wanted but for now I simply made the Domain Names match the field types of Delphi.

[ViktorV]

Thank you for your interest to our product. Feel free to contact us if you have any further questions.