Re: Problem with libpsqlodbc

Yes it work on other database but probably i'm missing something...

For oracle they do

create_proc => '{call create_person(?)}'
add_proc      => '{call set_person_name(?,?)}'

Is that the problem ? Should I use call ? I use select instead of call
because when I've tried it under pgsql call is not a keyword. So do I
definitively missed something ?

Sorry for asking that but could you give me a little sample modifying the
first parameter in a function as I could be less stupid and understand
a little ODBC ?

I request your help because I really don't know about ODBC and after
finding the solution for openldap I will probably never use ODBC  :-((

Regards,
Gilles Darold

Hiroshi Inoue wrote:

> > -----Original Message-----
> > From: darold [mailto:darold]On Behalf Of Gilles DAROLD
> >
> > Hi,
> >
> > Yes it is build on a Linux RH6.2 and I use procedure as follow:
> >
> > create_proc => 'SELECT create_person(?)'
> > add_proc      => 'SELECT set_person_name(?,?)'
>
> Do they really work with other databases using
> SQLBindParameter ?
> SQLBindParameter(stmt, 1, ..) for above queries
> means a binding to the first parameter "?".
> Your functions seem to return the currval of a
> sequence but doesn't change/set the first para-

> meter(it's impossible in PostgreSQL). SELECT
> doesn't return a parameter but returns a result
> set in ODBC.
>
> regards,
> Hiroshi Inoue
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org