Skip site navigation (1) Skip section navigation (2)

Re: ODBC SQLSetPos Delete problem

From: Janet Borschowa <borschow(at)roguewave(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Cc: Lothar Behrens <lothar(dot)behrens(at)lollisoft(dot)de>
Subject: Re: ODBC SQLSetPos Delete problem
Date: 2004-09-15 16:14:22
Message-ID: D486606E7AD20947BDB7E56862E04C39BDC75F@cvo1.cvo.roguewave.com (view raw or flat)
Thread:
Lists: 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.

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(dot)lang(at)attiksystem(dot)ch] 
> Sent: Wednesday, September 15, 2004 12:05 AM
> To: pgsql-odbc(at)postgresql(dot)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(at)postgresql(dot)org 
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] De la part > de Lothar 
> Behrens Envoyé : mardi, 14. septembre 2004 19:07 À : 
> pgsql-odbc(at)postgresql(dot)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(dot)behrens(at)gmx(dot)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(at)postgresql(dot)org so 
> that your
>       message can get through to the mailing list cleanly
> 

Responses

pgsql-odbc by date

Next:From: Lothar BehrensDate: 2004-09-15 16:57:02
Subject: Re: ODBC SQLSetPos Delete problem
Previous:From: Philippe LangDate: 2004-09-15 07:05:00
Subject: Re: ODBC SQLSetPos Delete problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group