Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Validation on field
Message
De
13/04/2008 12:25:46
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Validation on field
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01310249
Message ID:
01310249
Vues:
62
Dear Experts

Table Zone has two fields as

Zone c(1)
Name c(30)

And data in table as follows

zone-----name
A---------Eric
B---------Bill
C---------Nomi
E---------Rich

Form’s Activate event has following codes
select zone
index on zone to zone1
go top
thisform.GRID1.RecordSource="zone"
thisform.grID1.COLUMN1.ControlSource="zone.zone"
thisform.GRID1.COLUMN2.ControlSource="zone.name"
Grid1 has Allowaddnew=.t.

I add data into zone table through grid but it accept duplicates

I want column1 must not accept duplicate values

Suppose Column1 has “B” then it must not allow “B” to enter.
What validation rule should I apply on column1?
Or there is some other methed exists?

Please help
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform