Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Seek Command
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using Seek Command
Miscellaneous
Thread ID:
00645533
Message ID:
00645533
Views:
30
I am trying to use the seek command to do a lookup in a zipcode table. I have two tables

mytable zip c(5) and county c(15)
zipcodes zip c(5) and county c(15) index tag zip_t

my code looks like this

use mytable in 0
use zipcodes in 0 order zip_t
sele mytable
scan
hld_cnty = ' '
scatter memvar
sele zipcode
seek(m.zip)
if found() then
hld_cnty = zipcode.county
sele mytable
replace mytable.county with hld_cnty
end if
endscan

However the seek never finds any matching records?????
Next
Reply
Map
View

Click here to load this message in the networking platform