Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select drops leading ZERO in TTOC(datetime,2)
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
SQL Select drops leading ZERO in TTOC(datetime,2)
Miscellaneous
Thread ID:
00249398
Message ID:
00249398
Views:
132
I am having problem with a form. In a test form using a Visual FoxPro BASECLASS FORM. I can do the following query and it works OK:

SELECT LEFT(TTOC(DateTimeField,2),5) FROM Table

and the results are for 9AM I get "09:00."

However, in a form using my class library I get "9:00:" instead.

The second form is a PRIVATE DATASESSION.

Apparantly this looks to be a PRIVATE DATASESSION issue!

Any IDEAS?

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform