Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace command throws me to eof
Message
From
24/10/2007 11:28:58
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01262987
Message ID:
01263147
Views:
24
>>But that should just get your record to be the last record (assuming you're entering a date larger than any other), not EOF(). Try with an older date - i.e. not today, but a date less than the latest date in the table, that should set your record as not the last.
>
>DAYS_Op is a 7 char field to denote what days the Journey runs, not a date, as I explained in another fork. If every day then it will hold "MTWTFSS". If the bus doesn't run, say, wed and thu then it will be "MT--FSS".

Seems to be this one runs only mid-week, i.e. it's a "--WTF--" :).


>>BTW, are you sure it's eof("infobase")? Could it be something else (a related table, perhaps) is at eof()?
>
>I have the infobase up in a browse whilst tracing. As soon as the repl day-op is executed - ZAP - off to last rec.

Spare me hunting down the rest of the thread - what's the key expression for the current tag? Could it be that it's somehow empty for other records and filled for the current - so it jumps to the bottom (bottom or eof() - the difference makes a difference).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform