Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
listboxes - checking for dupplicates
- Thread starter cyrilf
- Start date
if it is from a alias you can try using select
_tally = 0
select field from alias where field = value into cursor junk
if _tally > 1
duplicate
endif
if your alias is buffered, uncommitted data then this will fail. select always makes hits on the underlying table. so if data is added to buffered table and no tableupdate is done on new records then this will fail.
if your source is an array, then use the ascan function to scan the array.
Attitude is Everything
_tally = 0
select field from alias where field = value into cursor junk
if _tally > 1
duplicate
endif
if your alias is buffered, uncommitted data then this will fail. select always makes hits on the underlying table. so if data is added to buffered table and no tableupdate is done on new records then this will fail.
if your source is an array, then use the ascan function to scan the array.
Attitude is Everything
- Status
Similar threads
