Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checking for duplicates
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00315645
Message ID:
00316392
Views:
24
Michelle,

You may want to save current record pointer, check with seek(), then return on the record, you was sitting. Or it won't work?

HTH

>>>This seems line an elementary question, but it's got me a bit puzzled. When the user is entering a new record, how do you check to be sure a field doesn't have a duplicate value without moving the record pointer? This also would have to take into account buffering. It seems as though I've done this before, but my head is in a bit of a muddle today and it's not coming to me.
>>>
>>>Thanks,
>>>
>>>Michelle
>>
>>Hi Michelle.
>>
>>The other's suggestions will certainly work, but you might also want to consider VFP 6's INDEXSEEK function. This will let you seek a value in the same work area without moving the record pointer.
>
>Yeah, I believe someone mentioned that. I didn't know it was for VFP 6, though. I guess that won't work.
>
>Thanks,
>
>Michelle
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform