How to develope an error-handler for a kind of replication

Поиск

Список

Период

Сортировка

От	DI Hasenöhrl
Тема	How to develope an error-handler for a kind of replication
Дата	4 июля 2001 г. 05:20:53
Msg-id	006b01c1046a$a4d43660$01011eac@irina обсуждение исходный текст
Список	pgsql-odbc

Дерево обсуждения

Hello,

I use postgresql 7.0.2 as backend and MsAccess as frontend. In order to improve performance I use local Access tables and a copy of these tables on postgresql side. This means, that when I update some rows in the Access tables I have to synchronise the server tables and to develope an error-handler for any cases. In the docu I read, that every SQL query is executed in a transaction, this means that every update or insert is completed or isn't done. Now I assume, that an error occurs, because the server has some problems, or the network or, or, or.....How can I find out on Access side, wheter the transaction was made or not? Did the error occur befor or after the transaction?

Please, can someone show me, where I can find some information, hints, examples,.... how to realize this Error-handler ?

Thanks for your help

Irina

E-Mail: i.hasenoehrl@aon.at

В списке pgsql-odbc по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

How to develope an error-handler for a kind of replication