Mark,
Try this:
WITH THIS
IF .commevent = 2
.pcLastReading = .pcLastReading + .INPUT
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.