Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange things are happening
Message
De
06/02/2015 12:30:53
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01614979
Message ID:
01614982
Vues:
40
>>This VFP 6 app has been running since 2001,
>>Last week the client noticed that in the first line of a report (a grouped line) the numbers were doubled.
>>Just the first line. All other lines were OK.
>>A browse of the table showed that the data was correct.
>>After futzing for a while, I reindexed the table and the report showed OK In the preview screen.
>>That's the first time I've had to reindex a table in that app.
>>This particular table is used to house monthly data and is zapped every month when the month is closed.
>>I thought, "Wow 14 years and one blown index.. that's not shabby, is it?"
>>Today, the same client called and said that the report was OK in the preview screen, but when she clicked the print button and printed the report, the first line was doubled again.
>>I got the data here and was able to reproduce it.
>>OK in the preview, doubled when printed.
>>Strange.
>>That's a first for me. I've seen many format differences but never saw a report have a different grouping result when printed.
>>I reindexed the table again and packed it this time.
>>Now the printed version is OK.
>>Any ideas as to what might be going on?
>
>Are you sure that nothing is saved in Report's environment? Is Report running with default data session?

Good question, Naomi.
No, I browsed that .frx and it's all clean.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform