Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Acceptance of duplicate records
Message
From
25/06/1999 23:32:14
Heena Sampat
Fairbyte Computer Consultants
Mumbai, India
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Acceptance of duplicate records
Miscellaneous
Thread ID:
00234286
Message ID:
00234286
Views:
54
I had created party-group for accepting 2 char grp codes and party
master for creating selecting 2 chars from party-group[via combo]
and new 3 char codes.
while accepting the partyname in gotfocus I check for duplicates.
sele party_master
sele party_master.p_grp,party_master.p_code from party_master into table temp
sele temp
index on p_grp + p_code  TAG p_grp
seek party_master.p_grp + party_master.p_code
if found()
	wait window "Cannot enter duplicate code"
	thisform.p_code1.setfocus
endif found
if .not. found()
    	sele party_master
    	repl party_master.p_grp with party_grp.p_grp
    	repl party_master.p_codd with party_master.p_grp + party_master.p_code
endif not found
even then it accepts the duplicates -
[still new to vfp]

kindly help
Next
Reply
Map
View

Click here to load this message in the networking platform