Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SEEK function with a TagName
Message
From
24/03/2004 14:19:43
 
 
To
24/03/2004 12:59:46
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00889314
Message ID:
00889372
Views:
30
>Order is defined desc or open desc ?
>You have REINDEX ?
>
>You can try this:
>
>orderNo = TAGNO('order')
>orderExp = KEY(m.orderNo)
>orderSingle = PRIMARY(m.orderNo) OR CANDIDATE(m.orderNo)
>select 0
>use mytable again
>scan
>  if !SEEK(EVAL(m.orderExp), 'mytable', 'order') OR recno()#recno('mytable') AND m.orderSingle
>      ? EVAL(m.orderExp),RECNO(),recno('mytable')
>  else
>      go top in mytable
>  ENDIF
>endscan
>
>
>Not found values have a rule ?
>You can post
>- expression m.orderExp and its type ?
>
>Fabio

It's a free table. I haven't reindex yet. The value that I'm tring to seek is a compound index expression.

The index is
INDEX ON sono + STR(lineno, 4) TAG sono1
The field defs are sono C(10), lineno N(4,0)

I'm working on simplifying the code down to see if I can recreate in a less complex program.
Charles

"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform