Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Flash poof it's gone
Message
From
18/12/2006 16:05:34
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
18/12/2006 15:50:49
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01178692
Message ID:
01178706
Views:
18
>>>>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. :)
Previous
Reply
Map
View

Click here to load this message in the networking platform