Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with seek
Message
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Miscellaneous
Thread ID:
01659059
Message ID:
01659060
Views:
64
>My code is this
>
>select clients
>set order to tag accountno
>seek left(globalnew.accountno,6)
>if found()
>WAIT WINDOW "A"
>endif
>BROWSE last
>WAIT WINDOW "B"
>
>The seek never brings up window "A" but does bring up the browse which shows it has found the correct client record
>
>So its saying to me that it that it hasn't found the correct record but yes it has
>
>What have I done wrong

What about this:
SET EXACT OFF
seek left(globalnew.accountno,6) IN clients ORDER accountno
if found([clients])
   WAIT WINDOW "A"
endif
SELECT clients
BROWSE last
WAIT WINDOW "B"
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform