Better to use IF SEEK(mcity+mstate, 'Cities', 'City'). Mcity+mstate must
match index so need to be padded to same length as the index fields, I
wouldn't index on a trimmed field, others may disagree. Also, suggest SCAN
ENDSCAN better than DO WHILE.
Try:
USE h-1b_fy14_q4 ALIAS mastfile in 0
USE us_cities ALIAS cities in 0
SELECT Mastfile
SCAN
IF SEEK(mcity+mstate, 'Cities', 'City')
mlat = n3
mlng = n4
ENDIF
ENDSCAN
Regards
John
John Weller
01380 723235
07976 393631
> -----Original Message-----
> From: ProfoxTech [mailto:[email protected]] On Behalf Of
> Virgil Bierschwale
> Sent: 21 January 2015 16:11
> To: [email protected]
> Subject: boy, I'm rusty
>
> SELECT 0
> USE h-1b_fy14_q4 ALIAS mastfile
> SELECT 0
> USE us_cities ALIAS cities
> SET ORDER TO city
> SELECT mastfile
> GO top
> DO WHILE .not. EOF()
> mcity = RTRIM(lca_case12)
> mstate = lca_case13
> SELECT cities
> SEEK mcity + mstate
> IF FOUND()
> * found it
> mlat = n3
> mlng = n4
> ENDIF
> SELECT mastfile
> SKIP
> ENDDO
> RETURN
>
> cities is indexed on rtrim(city) + rtrim(state)
>
> not finding the records..
>
> what am I missing in the seek portion?
>
> I know about the problem in the found part, just haven't fixed it yet
>
> thanks,
>
> Virgil
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
