Re: BUG: PGACCESS does not warn when trying to update
От | Brett Schwarz |
---|---|
Тема | Re: BUG: PGACCESS does not warn when trying to update |
Дата | |
Msg-id | 1029425397.1824.510.camel@thor обсуждение исходный текст |
Ответ на | Re: BUG: PGACCESS does not warn when trying to update a (Jean-Luc Lachance <jllachan@nsd.ca>) |
Список | pgsql-interfaces |
You are correct. Looking at the code a bit, it looks like it does the Right Thing when inserting a new record, but does not do the same for updating a record. Can you file a bug so that this can get tracked properly? http://bugzilla.pgaccess.org thanks, --brett On Thu, 2002-08-15 at 09:12, Jean-Luc Lachance wrote: > But, > > When a record is updated with PgAccess, the least that it should do is > check the return status of the update to find that the record no longer > exists and warn the user!!! > > JLL > > terry wrote: > > > > Actually, M$ Access does the same thing. When a form (or query) > > is populated with the contents of a record, it no longer is > > changed within the database - only within the form (or query). > > It is only when the record is saved that there is any indication > > of change or deletion. The only way to determine if the record > > in the form (or query) has been changed or deleted is to check > > that record in the database during the operation, which is not > > routinely done. > > > > >> DARN!!! > > >> > > >> I have just wasted half a day updating record with PcAccess. > > >> > > >> If one is updating a record that was deleted by someone else, > > >> PgAccess does not warn that the record no longer exists and > > >> silently accept the update. > > >> > > >> Then, if the list is refreshed, the record is gone!!! > > >> > > >> ---------------------------(end of > > >> broadcast)--------------------------- TIP 5: Have you checked > > >> our extensive FAQ? > > >> > > >> http://www.postgresql.org/users-lounge/docs/faq.html > > > > -- > > > > terry > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- Brett Schwarz brett_schwarz AT yahoo.com
В списке pgsql-interfaces по дате отправления: