Re: ODBC SQLSetPos Delete problem
От | Lothar Behrens |
---|---|
Тема | Re: ODBC SQLSetPos Delete problem |
Дата | |
Msg-id | 200409151826.i8FIQvJ16458@jedi.behrens.de обсуждение исходный текст |
Ответ на | Re: ODBC SQLSetPos Delete problem (Janet Borschowa <borschow@roguewave.com>) |
Список | pgsql-odbc |
> Hi, > I've used various versions of the PostgreSQL odbc driver on Windows and > Unix. I found that versions 7.2.1 to 7.2.2 will not crash but will give an > error when subsequently fetching a row after having deleted a row even > though the delete works OK. With versions 7.2.3 to 7.3.3 the program will > crash but this is not consistent depending on the table involved and what > platform the driver is on. > Thanks, I will try this version. I also have a new idea: As for a financial system, a customer with invoices must not be allowed to be deleted. In germany this is a must law. On the other hand, if I like to enable a deletion, I would do this with a delete flag and explicid cleanup code at the connection or at disconnetion from the database. Updating of rows works fine in my code and adding too, so wy not updating a delete flag internally in my ODBC wrapper ? Thanks Lothar > I think you're best bet is to either use a different version of the driver > although I don't know if this can work in your app, or better yet, do what > Philippe has suggested. > > Good luck! > > -- Janet > > > > -----Original Message----- > > From: Philippe Lang [mailto:philippe.lang@attiksystem.ch] > > Sent: Wednesday, September 15, 2004 12:05 AM > > To: pgsql-odbc@postgresql.org > > Cc: Lothar Behrens > > Subject: Re: [ODBC] ODBC SQLSetPos Delete problem > > > > > > Lothar, > > > > As a workaround, what about writing your code in plpgsql, and > > call the function from your Power++ Developer application? > > With this technique, your app will be faster, and you'll be > > protected from possible bugs in the driver. (Anyway I cannot > > say if what you experiment is a bug...) > > > > I'm working like this with a MS Access front-end, and it > > works really fine. Code is centralized, so when you need > > updating it, it's easier... > > > > Hope this helps, > > > > Philippe > > > > -----Message d'origine----- > > De : pgsql-odbc-owner@postgresql.org > > [mailto:pgsql-odbc-owner@postgresql.org] De la part > de Lothar > > Behrens Envoyé : mardi, 14. septembre 2004 19:07 À : > > pgsql-odbc@postgresql.org Objet : Re: [ODBC] ODBC SQLSetPos > > Delete problem > > > > Hi, > > > > it seems that I did not get any help. Now I also like to say, > > that If I test a Sybase Power++ Developer application with > > simple db form, I get a crash in the Postgres ODBC driver. > > > > The form is created with the wizard and uses cursors. > > > > The driver seems to delete the record, but moving to > > next/prev record fails. > > > > Who can help me ? > > > > Do you like to have the source ? > > You can dounload it. > > > > I can try to debug the ODBC library, but I do not understand > > the full source, so I need a little help. > > > > Thanks > > > > Lothar > > ---- My home: www.lollisoft.de ----------------------------- > > Lothar Behrens | Independent: lothar.behrens@gmx.de > > Rosmarinstr 3 | My public project: > > 40235 Düsseldorf | http://sourceforge.net/projects/lbdmf > > | -> Need comments, please visit :-) > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 8: explain analyze is your friend > > > > > > > > ---------------------------(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 > > > > ---------------------------(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 > ---- My home: www.lollisoft.de ----------------------------- Lothar Behrens | Independent: lothar.behrens@gmx.de Rosmarinstr 3 | My public project: 40235 Düsseldorf | http://sourceforge.net/projects/lbdmf | -> Need comments, please visit :-)
В списке pgsql-odbc по дате отправления: