Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Detect double records
Message
 
 
To
12/04/2010 09:43:57
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01459753
Message ID:
01459754
Views:
61
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform