Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Comm port controlled by MSCOMM
Message
De
24/07/2006 14:07:30
 
 
À
24/07/2006 13:11:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Contrôles ActiveX en VFP
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01135440
Message ID:
01139324
Vues:
12
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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform