Re: [INTERFACES] Re: pgsql-interfaces-digest V1 #180

Bill Hutto wrote:

> Hi again,
> Since my first Email apparantly went into the bit bucket, I thought
> I'd try again. The following is a post from last year :). Perhaps
> some one can give an authoratative answer.
>

Actually, two different people responded to your mail. However, it doesn't look
like they CC'd it to you. Maybe you should register on the pgsql-interfaces
list.

> > Date: Thu, 31 Dec 1998 15:16:59 +0000
> > From: "Bill Hutto" <bill(at)hammondgroves(dot)com>
> > Subject: Money type mapping to VB5 Jet workspace
> >
> > Hi,
> > I'm having problems with the mapping of the money type to an
> > appropriate type in Visual Basic 5.0. Presently, it is coming across
> > as type float8, and if that were acceptable to me, it isn't when I
> > update, because I get an error '524':
> >
> > parser: attribute 'amount' is of type 'money' but expression is of
> > type 'float8'
> > You will need to rewrite or cast the expression.
>

Its not exactly clear what you are trying to do. But I'll take a guess at it.
In the postgres database, the "amount" field is obviously of type money. The
sql statement, which I haven't seen, is probably trying to do an expression on
that column. Unfortunately, you can't easily do expressions on a money field in
Postgres, without casting it or something like that. And since the Jet is just
sending the statement, it isn't going to work. (I know you mentioned quotes,
but the error message above suggests this has nothing to do with quotes -- it is
some expression that is killing it. And besides, if it were a quote thing, the
error message would have been different.)

I recommend forgetting about the money type, and just stick with float for now.
When we have full Numeric() support, then you can use a SQL_NUMERIC or
SQL_DECIMAL to get the right precision. You will not be able to use dollar
signs and commas, but I don't think that is a show stopper, is it?

If you need further convincing, there isn't even a "money" data type on the odbc
side. Money is merely an attribute of a result set column. And worse in odbc
3.0, I don't see any mention whatsoever of money, even as an attribute! So, it
makes it very difficult to convert the field within the driver.

If I've missed what you are trying to do, then send the "psqlodbc.log" file of
your session so I can see the exact statement.

Byron