------=_Part_469581_18536970.1288471768563
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit


In my program sources code, I have the following querydef with returning expression:

.......... "VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,now(),?,?,?,?,?,?,?,?, now(),? ) returning to_char(""INS_DATA"", 'YYYYMMDDHH24MISS') as pippo;"


Using the new ODBC: "psqlodbc_09_00_0200", I have an error and no returned parameter.

Many thanks for your help

------=_Part_469581_18536970.1288471768563
Content-Type: text/html;charset="UTF-8"
Content-Transfer-Encoding: 7bit

 <BR>In my program sources code,  I have the following querydef with <STRONG>returning expression</STRONG>:<BR><BR>  .......... "VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,now(),?,?,?,?,?,?,?,?, now(),? )  <STRONG>returning to_char(""INS_DATA"", 'YYYYMMDDHH24MISS') as pippo</STRONG>;"<BR><BR><BR>Using  the new ODBC:  "<STRONG>psqlodbc_09_00_0200",  </STRONG>I have an error and no returned parameter.<BR><BR>Many thanks for your help<BR>

------=_Part_469581_18536970.1288471768563--

On 30/10/2010 21:49, r.melizzi [at] tin.it wrote:
> ) *returning to_char(""INS_DATA"", 'YYYYMMDDHH24MISS') as pippo*;"

I'd hazard a guess that the double-double-quotes around "INS_DATA" are a
problem, maybe?

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod [at] iol.ie

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

------=_Part_465044_12636655.1288549896006
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Maybe I get it.
It is no longer supported the function RETURNING on the execution of a query !!!!!?????

Many thanks


----Messaggio originale----
Da: rod [at] iol.ie
Data: 30-ott-2010 23.01
A: "r.melizzi [at] tin.it"<r.melizzi [at] tin.it>
Cc: <pgsql-odbc [at] postgresql.org>
Ogg: Re: [ODBC] psqlodbc_09_00_0200 - Information

On 30/10/2010 21:49, r.melizzi [at] tin.it wrote:
> ) *returning to_char(""INS_DATA"", 'YYYYMMDDHH24MISS') as pippo*;"

I'd hazard a guess that the double-double-quotes around "INS_DATA" are a
problem, maybe?

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod [at] iol.ie



------=_Part_465044_12636655.1288549896006
Content-Type: text/html;charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<SPAN class=3Dlong_text id=3Dresult_box><SPAN onmouseover=3D"this.style.bac=
kgroundColor=3D'#ebeff9'" title=3D"Forse ho capito." style=3D"BACKGROUND-CO=
LOR: #fff" onmouseout=3D"this.style.backgroundColor=3D'#fff'">Maybe I get i=
t. <BR></SPAN><SPAN onmouseover=3D"this.style.backgroundColor=3D'#ebeff9'" =
title=3D"Non =C3=A8 pi=C3=B9 supportato la funzione RETURNING on una query.=
" style=3D"BACKGROUND-COLOR: #ebeff9" onmouseout=3D"this.style.backgroundCo=
lor=3D'#fff'">It is no longer supported the function RETURNING on the execu=
tion of a query  !!!!!?????<BR></SPAN></SPAN><BR>Many thanks<BR><BR>
<BLOCKQUOTE>----Messaggio originale----<BR>Da: rod [at] iol.ie<BR>Data: 30-ott-2=
010 23.01<BR>A: "r.melizzi [at] tin.it"<r.melizzi [at] tin.it><BR>Cc: <pgsql=
-odbc [at] postgresql.org><BR>Ogg: Re: [ODBC] psqlodbc_09_00_0200 - Informati=
on<BR><BR>On 30/10/2010 21:49, r.melizzi [at] tin.it wrote:<BR>> ) *returning=
to_char(""INS_DATA"", 'YYYYMMDDHH24MISS') as pippo*;"<BR><BR>I'd hazard a =
guess that the double-double-quotes around "INS_DATA" are a <BR>problem, ma=
ybe?<BR><BR>Ray.<BR><BR><BR>-- <BR>Raymond O'Donnell :: Galway :: Ireland<B=
R>rod [at] iol.ie<BR><BR></BLOCKQUOTE><BR> =
=
=
=

------=_Part_465044_12636655.1288549896006--

On 30/10/2010 21:49, r.melizzi [at] tin.it wrote:

> ) *returning to_char(""INS_DATA"", 'YYYYMMDDHH24MISS') as pippo*;"
>
>
> Using the new ODBC: "*psqlodbc_09_00_0200", *I have an error and no
> returned parameter.

What is the error you are getting? - And can you show us the whole query?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod [at] iol.ie

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc