Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can see records / cant see records
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00428193
Message ID:
00428313
Views:
12
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform