Thread: psqlodbc_09_00_0200 - Information

 
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

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

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