Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Check for uniqueness
Message
From
26/12/2001 21:54:24
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Title:
Check for uniqueness
Miscellaneous
Thread ID:
00598341
Message ID:
00598341
Views:
56
My form has a combobox control that can use lunique. The table I want to check uniqueness against has an index on the concatenation of 2 fields (regular index). I want to choose a value in the combo box, and check to make sure this value is not in another table for the customer I am on (i.e. the key is the customer id I am on and the value I am entering). Another way of putting it: The table I am adding to has a field for customer id and one for code. I want to make sure there are no dupe records.

I set lunique to .t. on the combo box control, set cView to a view I am creating. Not sure what to use for the filter (must use both fields) and what to use for cViewParameter for the control.

Anyone done this before?

Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform