Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report anomaly
Message
 
To
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:
00365430
Views:
15
Rena,
Be sure you are using 'DTOS(Datefield)' not DTOC() or date format in your index.

DTOC() is particularly bad because dtoc(datefield) appears differently depending on the user's Windows settings.

>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.
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform