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