Re: More strict bind param count checking - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: More strict bind param count checking
Date
Msg-id 20051215051256.GA21336@soptik.pzkagis.cz
Whole thread Raw
In response to Re: More strict bind param count checking  (Hiroshi Inoue <inoue@tpf.co.jp>)
Responses Re: More strict bind param count checking  (Hiroshi Inoue <inoue@tpf.co.jp>)
List pgsql-odbc
> Hi Ludek, thanks to your recent effort to improve the psqlodbc driver.
> Please let me comment on your patch a little.

Hello,

  your comments are welcome.

> > !         if (ipdopts->allocated == marker_count)
>
> Why are you using the operator '==' not '>=' ?
> AFAIK there's no such limitation.

We have problems with Visual FoxPro. It calls SQLCancel without
FreeStmt(SQL_RESET_PARAMS). It leads to failure becouse next
ExecDirect with fewer parameters in some cases think that it
has data_at_exec (which was parameters from previous).

So I think this could be good prevent againist driver failure.

> > +     if (ipdopts->allocated != marker_count)
>
> Why are you using '!=' not '<' ?

It's the same as previous (only negated).

> > +     ipdopts = SC_get_IPDF(stmt);
> > +     if (ipdopts->allocated != marker_count)
>
> The same comment as the previous one.
> In addtion, the check is not appropriate because Exec_with_parameter_resolved
>  could be called with insufficient parameters.

I take a look at it again.

Thanks for comments

Luf

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: More strict bind param count checking
Next
From: "Anoop Kumar"
Date:
Subject: Re: Next development steps?