Re: ODBC SQLSetPos Delete problem - Mailing list 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 :-)