Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find the records with the earliest dates
Message
From
15/01/2003 16:40:26
 
 
To
15/01/2003 16:33:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00742121
Message ID:
00742122
Views:
16
This message has been marked as a message which has helped to the initial question of the thread.
>I have a table that records changes to the status of a driver. I need to find the earliest record for each driver and what their status was on that day. I want to put this into a cursor for processing. I have tried an SQL Select statement, but it does not seem to work the way I want it to.

See this thread #738069. I faced the same situation and the related examples have been provided in that thread.
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform