But what if commevent <> 2? How will my form's property collect .input?
Data all the same in all 22 rows.
>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.