Hello,

I am using AnyDac 5.0.7, Firebird 2.5.1, Delphi XE, DataAbstract
Connexion strign is


Field defined as:
* IS_SPECIAL DMED_BOOLEAN /* DMED_BOOLEAN = SMALLINT DEFAULT 0 CHECK ((VALUE = 0) OR (VALUE = 1) OR (VALUE IS NULL)) */,
is mapped as SMALLINT (datSmallInt) and not as BOOLEAN (datBoolean) as I expected.

* PACHET_PRET DMED_PRET /* DMED_PRET = NUMERIC(18,4) NOT NULL */,
is mapped as datCurrency and not as datDecimal as I expected.

Is there a possibility that such fields to be mapped?

Thanks,
Tiberiu Stoicescu

Hello Tiberiu,

Thank you for the inquiry.

Yes, that's possible.

Please set up your connection string as:

This will map both columns to the required data types.

How you can extend that yourself:
1) Start ADExplorer
2) Setup a connection definition
3) At the Advanced options page set up the required options: see (more) about map rules and MaxBcdPrecision option
4) Save the connection definition
5) In ADConnectionDefs.ini locate that and copy the parameters you would like to customize and append to the connection string preceding them with "@" symbol

Please let us know if we can be of more help.

Thanks,

This works.

Is there a possibility that all fields that is defined with specific domain eg DBOOLEAN to be mapped as boolean?

Hello,

That's possible but is disabled by default.
You can manually enable this feature in the add-on source, but that will slowdown a bit opening of your datasets.
To enable this feature please:
1) open uDAAnyDACDriver
2) locate this function:
3) replace False with True

This will enable fetching metadata prior to retrieving the data from your table. You can read more about this here (see fiMeta item description): www.da-soft.com/anydac/docu/uADStanOptio...chOptions_Items.html