Yes, at the end of my code .pcLastReading = '
But still how come that can happen? Dont you think it is anActiveX probem? Looks like it does not reset the Input property.
>Mark,
>
>First thing that comes to mind is to extract all data from .pcLastReading up through your CHR(13), massage and post it, then remove it from .pcLastReading. This would keep any additional scans intact, which you could then test for and deal with. Otherwise, test for multiple CHR(13)'s up front and deal with them accordingly.
>
>Make sense?
>
>>Hi Jim,
>>I am having some strange results. Maybe you can help me.
>>Here is a sample of scanned data in a table with readings form a scanner. Order is reading time descending.
>>
>>...
>>L1jaH L1jcB
>>L1jcB
>>...
>>
>>Her is a fragment of the code that is used to created these two records:
>>

>>WITH This
>>	.pcLastReading = .pcLastReading + .Input
>>        IF AT(CHR(13), .pcLastReading) > 0
>>       	lcSqlStr = STRTRAN(.pcLastReading, "'", "''")
>>        TEXT TO lcSql TEXTMERGE NOSHOW
>>	usp_UpdateReading '<<lcSqlStr>>',<<.Parent.pnCommPort>>,<<ThisForm.pn        LineId>>
>>	ENDTEXT	
>>	ThisForm.mExecuteSqlCommand(lcSql, '', '')
>>

>>You see what happened: A scan of the barcode "L1jaH" had also a read from the prev. scan. How that can be?