Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can see records / cant see records
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00428193
Message ID:
00428313
Vues:
11
>I would chalk this up to a broken index but apparently thats not the case. A report option populates a temporary cursor with a list of accounts to select from. This is done in the form's INIT. The code looks something like:
>
>CREATE CURSOR tmpreport ;
> (msel L, accountname C(30))
>
>SELECT accounts
>GO TOP
>msel = .f.
>SCAN FOR ! DELETED()
> m.accountname = accounts.accountname
> INSERT INTO tmpreport FROM MEMVAR
>ENDSCAN
>SELECT tmpreport
>GO TOP
>
>When this user runs the option, they see just one record in the tmpreport cursor. If they SEND ME their data and i run it, i see all the accounts (they have approx 30). Other users dont have this problem.
>
>I have used their data and it works fine for me.
>I have reindex their data and it works fine for me.
>Other users do not experience the same problem.
>They have reindexed their data and it still does not work for them.
>
>I am running the EXE as they would - not inside of VFP.
>
>Any suggestions?

I would suggest Deleting the indexes and creating them from scratch...

DELETE TAG ALL
INDEX ON...
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform