Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Phantom records?
Message
From
05/10/2007 10:50:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Phantom records?
Environment versions
Visual FoxPro:
FoxPro Dos
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01258937
Message ID:
01258937
Views:
58
This would seem to be impossible:

I'm trying to debug this old FFP26 prog (of the arcane ones that haunt me). It is supposed to build up a table in a loop of inspected records according to certain criteria.

It created the table with, reportedly 385587 records in it (according to Reccount()). In browse mode when I click in any row column the cursor doesn't get placed in the browse and no "record" appears to be selected, ie the browse window is inert. But the scrollbar moves up and down (I should point out that I'm running the progs and viewing data from VFP7). Furthermore, of these 385587 records ALL seem to be completely blank. In my opinion there ARE no records in it. If I issue Go TOP:

? reccno() -> 385587
? eof() -> .T.
? bof() -> .F.

If I issue Go Bott:

? reccno() -> 385587
? eof() -> .T.
? bof() -> .F.

None is deleted.

Go TOP
dele next 10
? recc() - > 385587
? _tally -> 1
dele next 10
? _tally -> 0
? eof() -> .T.
? recc() - > 385587

Anybody got a CLUE what's going on here?
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Next
Reply
Map
View

Click here to load this message in the networking platform