update rules + views + odbc problems
От | Mike Fahey |
---|---|
Тема | update rules + views + odbc problems |
Дата | |
Msg-id | 41655BB4.6070005@enter.net обсуждение исходный текст |
Ответы |
Re: update rules + views + odbc problems
|
Список | pgsql-odbc |
Hi, i'm runing into problems when I have a view defined and then try to update the view with a rewrite rule in place. At a psql prompt I can update the view just fine. I'm using access 2003 and I have a subform bound to a view in postgres, then I have a rewrite rule defined on the view. With psqlodbc.dll version 07.03.0200 I get the following error in access: No Current Record. With psqlodbc.dll version 08.00.0001 I get the following error in access: Write Conflict This record has been changed by another user since you started editing it. if you save the record you will overwrite the changes the other user made. Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes. Any thoughts? Thanks in advance. -- With best regards, Mike Fahey - Systems Administration ******************************************************************** ENTER.NET - "The Road to the Internet Starts Here!" (tm) (610) 437-2221 * http://www.enter.net/ * email:support@enter.net ********************************************************************
В списке pgsql-odbc по дате отправления: