Re: pgsqODBC binding parameters II (fwd) - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: pgsqODBC binding parameters II (fwd)
Date
Msg-id 3AB95E40.64F8AEBA@tpf.co.jp
Whole thread Raw
In response to pgsqODBC binding parameters II (fwd)  (Ludek Finstrle <xfinstrl@informatics.muni.cz>)
Responses Re: pgsqODBC binding parameters II (fwd)  (Ludek Finstrle <xfinstrl@informatics.muni.cz>)
List pgsql-odbc
Ludek Finstrle wrote:
>
> > >   please, could some expert answer?
> >
> > Though I'm not an expert, I have a question.
> >
> > [snip]
> >
> > > > CONN ERROR: func=SQLExecute, desc='', errnum=110, errmsg='ERROR:  parser: parse error at or near ""'
> > > > SQLExecute: premature statement so return SQL_ERROR
> >
> > PREMATURE state of the statement seems to be the cause of
> > the error. Is your change about data_at_exec to prevent the
> > PREMATURE state just after the return from SQLNumResultCols ?
> > Or does it have another purpose ?
>
> Sorry, I don't understand question very well.
> I make it in december. So I don't remember details.
>
> The problem was that '?' didn't be detect as parametr at exec.
> So I added detection of parameters at exec to SQLExecute. And if I detect
> it I return SQL_NEED_DATA.
>

'?' doesn't necessarily mean a data_at_execution parameter.
Doesn't your patch change all parameters to data_at_exec ones ?
If so it doesn't seem good.

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: Bruce Momjian
Date:
Subject: New Unapplied Patches web page
Next
From: Dave Page
Date:
Subject: RE: [PATCHES] Problem in doing bulk inserts thru ODBC API calls