Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report anomaly
Message
From
02/05/2000 17:51:05
Rena Glubay
Pacific Press Publishing Assoc
Nampa, Idaho, United States
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00363132
Message ID:
00365381
Views:
17
Hi Cathy,

Sorry it has taken me so long to respond to your suggestion. The report does call a UDF in the page footer but it only
formats the date printed information. However, I have discovered what I think is the problem. Earlier in the program
a table is created and it is from that table that the report is printed. An index is created for the table that consists of
several fields one of which is a date field. At the time the table is created an ORDER BY is also performed.. Just before
the report is printed, there was a USE table-name INDEX table-idx. When I took off the INDEX part, it worked correctly.
I have heard since discovering this that FoxPro/VFP doesn't deal well with date fields in an index. It appears that this
is my problem.

Thanks for you time and interest in helping me solve this problem.

Rena

PS. Ms Paltiel and Ms Peisch, I am forwarding this to you two ladies since you also had suggestions to help me
solve this problem. My thanks to you too for your willingness to help me solve this problem.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform