On 28-7-2013 20:49, Alan J Davies wrote:

> Hi again all, thanks to Mark and Matkus I have successfully converted a
> number of SPs using this technique, but cannot get this particular
> version to work. I have tried every combination I can think of and
> looked and re-looked at the example code and my own code.
> The error I get every time (regardless of where the parameters are
> placed) is:
> The insert and delete options work perfectly
>
> Overflow occurred during data type conversion.
> conversion error from string "CT ".
> At procedure 'Q_UPD_TOOL_GAUGE_PPAP_PARTNO' line: 31, col: 9.

What has the value "CT ", what is its datatype and what is the datatype
of the column being inserted or updated? At first glance I'd say you try
to insert a string into a numeric column.

Mark
--
Mark Rotteveel