Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Phantom records?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
FoxPro Dos
OS:
Windows XP SP2
Divers
Thread ID:
01258937
Message ID:
01258955
Vues:
13
>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?

Corrupted table. What happens if you open that table EXCLUSIVE and PACK it? Be sure you have a backup first :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform