>* table1 id
>* table2 id
>
>select table1
>SEEK id IN table2 && is SEEK table2.id IN table2
>SEEK(id,'Table2') && is SEEK(table1.id,'Table2')
>
>When they use only the workarea with names of alias random, this becomes important.
Thanks - I've been using the seek function for years. In this case I did not need to ask if a point would be returned and was primarily interested in SETting EXACT back ON only once. If I had used the SEEK() function, it would have required exact to be set on two times (the pointer was resolved - ot not resolved)
So - since this project is one I own - I spent the time and reviewed the SEEK command. I noticed SEEK command had arguments that were new to me - even ZAP (now) has an IN clause - IOW - Theres a bunch of new xBAse stuff in VFP that I was not aware of.
It seems that now I can xBase and I do not need to buy a clock cycle to "SELECT MyAlias" and subsequent "SELECT MyLastAlias()". It seems all the xBase commands now have an Alias argument (awa ORDER TAGs) - which is pretty kool. I don't even know how long the SEEK command has had that feature - but I was surprised when I saw it!
NOW - if we cold only get an EXACT argument in the SEEK command!:-)SEEK lcKey ORDER lcKey IN MyAlias with EXACT OFF
ThanksImagination is more important than knowledge