SQLite datatype conversion settings in pbodb126.ini

[Former Member]

Hi,

we want to convert the SQLite datatypes to specific Powerbuilder dataypes. Without doing anything PB shows the correct databaes dataytpes in the datawindow Data Source view. When i change back to the layout the datatypes from the selected columns are changed to datatypes which PB knows, e.g. float is changed to number and so on.

What we want to do is changing float to decimal. So that the Type in the column specifikation is decimal and not number.

Created a new section for SQLite in the pbodb126.ini and a SQLITE_SPECIALDATATYPES section as shown below:

[SQLite]
PBSpecialDataTypes='SQLITE_SPECIALDATATYPES'

[SQLITE_SPECIALDATATYPES]
;SpecialDataTypes='float=DBI_TYPEDECIMAL=100;10'
SpecialDataTypes='float=DBI_TYPEDECIMAL=3;5'

None of these settings change anything in PB.

Any suggestions what to insert into the pbodb126.ini to map the database datatypes to specific PB datatypes?

Btw. are there any descriptions for the settings out there? The description in the ini and the PB-Help isn't usefull. I couldn't find any description what term to use for the datatypes. DBI_TYPEDECIMAL seems to be decimal, regarding the name. Another thing is part right from =. There are different values for different predifined entrys like 100,101,102,3 but no description what it is for and what are valid values.

[Former Member]

I read the comments in the ini file and it appears that SpecialDataTypes is only used when the dbms maps more than one of its datatypes to the same ODBC datatype. That would explain why the setting you added is being ignored.

That being said, 3 is the correct value for decimal. My guess is that the 5 indicates the number of places to the right of the decimal point.