Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sorting by a DateTime type
Message
From
30/05/1996 03:02:56
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00001725
Message ID:
00001791
Views:
42
>SELECT rollview.barcode AS bar, rollview.accept AS
>acc, convert(VARCHAR(12),rollview.orgdate) AS org
>FROM rollview ORDER org DESC, acc DESC, bar ASC
>INTO CURSOR temp
>
>This gave me a syntax error. I'm thinking VFP
>doesn't like the convert().

sorry - i didn't notice the convert()
there is no such function in VFP - try DTOS instead
and if u nead the time portion as well use Hour(),Minute()
and Sec() to get thier values as well (btw all 3 return
numeric values )

Arnon
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform