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

Re: UPDATE with data at exec and CURRENT OF question

From: Lothar Behrens <lothar(dot)behrens(at)lollisoft(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: UPDATE with data at exec and CURRENT OF question
Date: 2007-08-16 11:35:15
Message-ID: 1187264115.857459.54640@a39g2000hsc.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-odbc
"Hiroshi Saito" schrieb:
> Hi.
>
> ----- Original Message -----
> From: <lothar(dot)behrens(at)lollisoft(dot)de>
>
> >
> > "Hiroshi Saito" schrieb:
> >> Hi.
> >>
> >> Ah thanks, It is the environment which can reproduce me.
> >> Then, I am beginning to make a test code.  There is likely to be a problem
> >> of some except for SQL_FETCH_NEXT....
> >
> > I have created a small test application only with plain ODBC stuff. I
> > could reproduce
> > my problem also on Windows with MS SQL Server 2000 !
> >
> > You could grab the code here:
> >
> > http://lbdmf.cvs.sourceforge.net/lbdmf/CPP/RegressionTests/Database/Plain-ODBC-Test-Blob/test.cpp?revision=1.4&view=markup
> >
> > The relevant function is testBlobUpdate.
> >
> > On PostgreSQL I did not yet have tested on actual drivers, but when
> > the MS SQL driver behaves similar, I suppose still an error in my
> > code.
> >
> > Regards, Lothar
>
> Uga...Sorry, SQL_CURSOR_KEYSET_DRIVEN cannot be supported yet.:-(
> Although I tried it as remembered, it is very difficult correction....
> As for the present version, SQL_CURSOR_FORWARD_ONLY and
> SQL_CURSOR_STATIC are supported.
> To be sure, it needs to exist as TODO.!
>

I have solved it by binding the binary column as usual. Then I have
set the value of
the column to an unique value - maybe cursorname - and have updated
the database
with that value set.

Then I was able to use a different query (prepared) with a simple
where clause and this was successfull.

So this may be a solution for the TODO ?

I have figured out some problems doing this on MS SQL but this another
issue and propably
only a cast for the where clause because they do strikter type
checking.

Regards,
Lothar

> Regards,
> Hiroshi Saito
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                 http://www.postgresql.org/about/donate


In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi SaitoDate: 2007-08-16 12:22:11
Subject: Re: UPDATE with data at exec and CURRENT OF question
Previous:From: Hiroshi SaitoDate: 2007-08-16 09:29:30
Subject: Re: ODBC driver adding extra characters to table names.

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