Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Select drops leading ZERO in TTOC(datetime,2)
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
SQL Select drops leading ZERO in TTOC(datetime,2)
Divers
Thread ID:
00249398
Message ID:
00249398
Vues:
133
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform