Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Flash poof it's gone
Message
De
18/12/2006 16:05:34
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
18/12/2006 15:50:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01178692
Message ID:
01178706
Vues:
19
>>>>This line of code causes my report to flash onto the screen and then disappear.
>>>>It's been a while since I created a report, but I think a line such as the one below used to work. Have I made an error for the very first time in my coding career?
>>>>
>>>>Report Form incident For Alltrim(crimetype) = "Vandalism" PREVIEW
>>>>
>>>
>>>Maybe you don't have 'Vandalism' anymore? :)
>>
>>I wish!;-) It's in the table.
>
>I got it - The data environment was hooked to a test table in another folder. Sorry folks.

I think lots of people tend to upper() strings for indexing. If you

INDEX ON UPPER(crimetype) TAG ixcrimtype

Then this command

REPORT FORM incident FOR UPPER(crimetype) = "VANDALISM" should be Rushmore Optimized. However it still won't work if you're hooking to the wrong table. :)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform