Re: ODBC escape convert error

Richard Broersma wrote:
> I've attached a log file with the code for a  prepared insert command.
>  However, when it is executed, I am getting the error:
>
> ODBC escape convert error.
>
> It looks like the query never makes it to the sever becuase I don't
> see any statement logged for it.  Does anyone have any ideas?

You may have to replace '{' (ODBC escape) by '(' in the line.

      .CommandText = .CommandText & "      WHERE { T.instrumentcode,
T.instrumentsuff, T.area, T.loopnbr ) IS NULL;

regards,
Hiroshi Inoue