Information générale
Catégorie:
The Mere Mortals Framework
Titre:
Check for uniqueness
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement