Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select a record with the most recent date
Message
 
 
To
17/02/2022 11:30:02
Antonio Lopes (Online)
BookMARC
Coimbra, Portugal
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01683566
Message ID:
01683600
Views:
32
>>Just a follow-up question.
>>Why does the field DATE (in the SQL Select you suggested) is a Char type? Nothing wrong. I would just like to understand why when you CAST the DateTime to DATE, the result is a char type and not a Date type.
>>
>
>Dmitry, adding to what was already stated in this thread, attached goes a more comprehensive VFP/ODBC/MSSQL compatibility chart.
>
>I can't remember if I already posted it here. It will serve as a refresh, if that's the case.

Antonio,

Thank you for the chart. I will save it for a future reference.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform