Re: About rules on views and M$ Access

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Davide Romanini <romaz(at)libero(dot)it>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: About rules on views and M$ Access
Date: 2003-01-17 14:55:38
Message-ID: 20030117145538.16102.qmail@web20802.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


--- Davide Romanini <romaz(at)libero(dot)it> wrote:
(snipped)
> But it simply doesn't find any row with
> "CostoEffettivo"='1.44232004547119' and this is
> probably due to internal
> handling of double precision numbers, I don't know
> exactly why. The
> query successes if I cast the column
> "CostoEffettivo" as text.
> Remember anyway that I can't change the queries the
> Access sends to ODBC!
>
Not quite true: you could always use unbound forms
etc, though that lets you in for a lot of extra work
;-)
Your queries suggest that "CostoEffettivo" is a
display field, i.e. it is not used in computations and
will not be updated directly. If so, try casting it
to text in your view definition, and have it displayed
as text in your form. At least the value should agree
that way, so your updates would succeed.
As for controlling the way Access composes its SQL: I
don't know whether that is possible, perhaps you could
post the question to an Access NG/List.

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Oleg Grodzevich 2003-01-17 22:42:00 SQL: last OID returning
Previous Message Tambet Matiisen 2003-01-17 14:47:36 Re: About rules on views and M$ Access