Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Detect double records
Message
 
 
À
12/04/2010 09:43:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01459753
Message ID:
01459754
Vues:
62
>in the invoice form, where I enter the items, my client wants me to issue a warning if I enter the same item twice.
>
>so I add this code in the valid event:
>
>
>select stock_id from vinvdetail into curs temp where stock_id=this.value
>if _tally<>0	
>   wait windows 'This item already exist...' timeout 1
>endif
>
>
>the problem is when the operator moves the cursors between items, the message always shows up, because it detect it own record.
>
>how can I detect it except the record itself.
>
>thanks for the help.

Perhaps you only need to add this code for the case when you're adding records? Is there a special flag or do you use buffering?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform