Mark,

Try this:

WITH THIS
  IF .commevent = 2
    .pcLastReading = .pcLastReading + .INPUT
    *!* Upate reading with the raw scan
TEXT TO lcSql TEXTMERGE NOSHOW
usp_UpdateReading '<<.pcLastReading>>', <.Parent.pnCommPort>>
ENDTEXT
    THISFORM.mExecuteSqlCommand(lcSql, '', '')
  ENDIF
ENDWITH

Also, what do the rows look like, datawise? Repetitive? Garbage?

>I have the following code in the ONCOMM event of the control:
>WITH This
> .pcLastReading = .pcLastReading + .Input
> *!* Upate reading with the raw scan
> TEXT TO lcSql TEXTMERGE NOSHOW
> usp_UpdateReading '<<.pcLastReading>>', <.Parent.pnCommPort>>
> ENDTEXT
> ThisForm.mExecuteSqlCommand(lcSql, '', '')
>ENDWITH
>
>I am getting about 22 rows inserted into an SQL table after a single scanner's scan that is attached to the comm port. Why that's happening? My barcode is short - 5 chars.