Select order by a datetime field causes problem

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Select order by a datetime field causes problem

Message

From

11/07/1997 00:48:25

Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada

11/07/1997 00:43:59

Paul Vlad Tatavu
X, Ontario, Canada

General information

Forum:

Visual FoxPro

Category:

Troubleshooting

Title:

Re: Select order by a datetime field causes problem

Miscellaneous

Thread ID:

00039386

Message ID:

00039392

Views:

>It was yesterday a thread very similar (order by month from datetime). Sounds interesting. I'll check it.

We had the same bug at my client site with the same thing. We had to take an order by DTOS(datetimefield) instead but this is not excatly what I want as it is not as precised.

I am using Visual FoxPro 5. I don't have the patch. I tried with different SET DATE formats and SET CENTURY ON/OFF. It doesn't change anything. It was also tested on Windows '95 and NT 4 platforms.

Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52

Map

View

Click here to load this message in the networking platform