Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database gets lost
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Database gets lost
Miscellaneous
Thread ID:
00236029
Message ID:
00236029
Views:
40
I have a prg below and the line "repl with 'UNKNOWN'" NEVER happens.
What's more when the last browse occurs, I get the error "ALIAS SCANFILE NOT FOUND" !!!! :( CRAZY or what? Too crazy for anyone to have seen this?


sele 1
use scanfile
sele 2
use ecu &&dump from sql
inde on allt(label) to z

do while .not. eof()
lab=allt(data)
sele 2
seek lab
if found()
repl scanfile->acct with acct <--ok here
endi
if eof()
repl scanfile->noun with 'UNKNOWN' <---NEVER happens, remains blank
endi
sele 1
skip
enddo
sele 1
set filt to noun = ' '
brow
sele scanfile
repl all noun with 'UNKNOWN'
set filt to
brow <---------ALIAS NOT FOUND!
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Next
Reply
Map
View

Click here to load this message in the networking platform