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