Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting DATETIME() to Character
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00092809
Message ID:
00092881
Vues:
21
Hey Brian,

Take a look at TTOC(). Make sure you use the ,1 argument for accurate indexing on char expressions.

INDEX ON TTOC(mydatetime,1) TAG MYDateTime

hth,

>There must be a fairly simple way to to do this, but I'm missing something. How do you convert the DATETIME() value to a character expression? I'm trying to make an index that sorts on a part number (alphanumeric) and then the DATETIME(). I'm building a transaction log that records when a part's information was modified.
>
>Thanks for any help,
>- Brian
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote Technologies
Developer's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform