Re: NEW ODBC DRIVER

Jose' Soares Da Silva wrote:

> I have a problem with types.
> I created a table with a column of type money and another with type
> bool, Access translate money to numeric (double precision) and bool to
> text.
> I thought that Access recognized this types as Money and Yes/No.
> Is it an ODBC or a PostgreSQL problem ?
>                                                          Thanks, Jose'


In my tests, Access never bothered to retrieve the information returned by
the driver which says that the field is a MONEY type.  I chose to make it a
numeric, but I could make it character, which would allow you to see the
money symbols, but I'm not sure if you could perform calculations on it?

As for the BOOL problem, I tried to return it as a SQL_BOOL, but Access
displayed it as 0=FALSE, and (-1)=TRUE.  Why does TRUE translate to a -1, I
have no idea.  But for that reason, I chose to make it a character type
instead.

I could add options to the setup dialog for handling these two types, if
anyone's interested.

Byron