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