Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why is SEEK command showing error?
Message
 
À
07/09/2004 13:15:52
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00939863
Message ID:
00940717
Vues:
17
>The differences:
>- With SEEK you can search with descending order ( for found the bottom ),
>SEEK() have not this possibility.
>- With SEEK() you can use the a field reference without the alias, with SEEK you cannot do this
>

>* 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

Thanks
Imagination is more important than knowledge
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform