Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comm port controlled by MSCOMM
Message
From
24/07/2006 13:11:59
 
 
To
14/07/2006 06:05:12
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01135440
Message ID:
01139273
Views:
15
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform