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

Re: SQLSetPos

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: SQLSetPos
Date: 2003-04-04 07:21:52
Message-ID: 03AF4E498C591348A42FC93DEA9661B8259EFC@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc

> -----Original Message-----
> From: Hiroshi Inoue [mailto:inoue(at)tpf(dot)co(dot)jp] 
> Sent: 03 April 2003 23:08
> To: Dave Page
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: RE: SQLSetPos
> 
> 
> > -----Original Message-----
> > From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
> > 
> > Hi Hiroshi,
> > 
> > I've had a query about support for SQLSetPos(SQL_UPDATE) in 
> psqlODBC. 
> > Upon examination of the code there seems to be some there to handle 
> > SQL_UPDATE, however the function exits with an error (Only 
> > SQL_POSITION/REFRESH is supported for PGAPI_SetPos) before 
> any of that 
> > code is ever reached.
> > 
> > Do you know if that's an oversight, or is the code that's there not 
> > ready for use yet?
> 
> You can use SQLSetPos(SQL_UPDATE) if you compiled the driver 
> with DRIVER_CURSOR_IMPLEMENT #defined(the current makefile s 
> in cvs already #define it) and turn on the *Updatable 
> cursors* DSN option.

OK thanks. I'm confused by the following code towards the beginning of
PGAPI_SetPos which is not in any #ifdef block that I can see:

	if (fOption != SQL_POSITION && fOption != SQL_REFRESH)
	{
		SC_set_error(stmt, STMT_NOT_IMPLEMENTED_ERROR, "Only
SQL_POSITION/REFRESH is supported for PGAPI_SetPos");
		SC_log_error(func, "", stmt);
		return SQL_ERROR;
	}

Won't that make the function exit with an error before an SQL_UPDATE is
handled?

Regards, Dave.


Responses

pgsql-odbc by date

Next:From: alain.bruneauDate: 2003-04-04 10:21:22
Subject: Problem with odbc.sql
Previous:From: Hiroshi InoueDate: 2003-04-03 22:07:41
Subject: Re: SQLSetPos

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