It's convenient (search, filters, sorting...) to do local forms over ODBC
with linked tables in access. But exits incompatibility with date types:
int8, date, time in postgres with access.
I've link view with access97:
CREATE VIEW view_table AS SELECT Fdate::timestamp, Fint8::int4 FROM table;
Then make an attemp INSERT and get error:
'Cannot insert into view without an appropriate rule (#7)'.
Is it mistaken way to solve mentioned above problem with data
incompatibility postgres and access.
Or Is it posible to solve problem via rules...
Excuse me for newbie question.
pgsql-odbc by date
|Next:||From: Support||Date: 2003-02-06 15:43:21|
|Subject: Repost: problem on treatment when add a duplicate primary key|
|Previous:||From: Anderson Cichon||Date: 2003-02-06 12:03:21|
|Subject: Driver PostgreSql x dbExpress|