psqlodbc_09_00_0200 - Information

psqlodbc_09_00_0200 - Information

am 30.10.2010 22:49:28 von r.melizzi

------=_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

 
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--

Re: psqlodbc_09_00_0200 - Information

am 30.10.2010 23:01:51 von Rod

On 30/10/2010 21:49, r.melizzi@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@iol.ie

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

R: Re: psqlodbc_09_00_0200 - Information

am 31.10.2010 19:31:36 von r.melizzi

------=_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@iol.ie
Data: 30-ott-2010 23.01
A: "r.melizzi@tin.it"
Cc:
Ogg: Re: [ODBC] psqlodbc_09_00_0200 - Information

On 30/10/2010 21:49, r.melizzi@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@iol.ie



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

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.
title=3D"Non è più 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  !!!!!?????

Many thanks


----Messaggio originale----
Da: rod@iol.ie
Data: 30-ott-2=
010 23.01
A: "r.melizzi@tin.it"<r.melizzi@tin.it>
Cc: <pgsql=
-odbc@postgresql.org>
Ogg: Re: [ODBC] psqlodbc_09_00_0200 - Informati=
on

On 30/10/2010 21:49, r.melizzi@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, ma=
ybe?

Ray.


--
Raymond O'Donnell :: Galway :: Ireland R>rod@iol.ie


=
=
=
=

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

Re: psqlodbc_09_00_0200 - Information

am 31.10.2010 19:36:25 von Rod

On 30/10/2010 21:49, r.melizzi@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@iol.ie

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