General information
Category:
Coding, syntax & commands
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only