Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Validation on field
Message
From
13/04/2008 12:25:46
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Validation on field
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01310249
Message ID:
01310249
Views:
61
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
Next
Reply
Map
View

Click here to load this message in the networking platform