Message
 
 
To
12/04/2010 09:43:57
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01459753
Message ID:
01459754
Views:
64
>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