Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Silly question but it is Friday
Message
De
14/03/2014 11:36:59
Mike Yearwood
Toronto, Ontario, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01596530
Message ID:
01596533
Vues:
98
Simplest is to

REPLACE dDate with {/} IN ALIAS

REPLACE tDateTme with {/:} IN ALIAS

>>>How do I clear a date field and a datetime field
>>
>>Mechanically, you can do it like this if it's in a table or cursor:
>>
SCATTER NAME xyz BLANK
>>REPLACE dDate     WITH xyz.dDate
>>REPLACE tDateTime WITH xyz.tDateTime
>>RELEASE xyz
>>
>>Or you can use the blank forms directly:
>>
thisForm.myDateControl.Value     = CTOD("  /  /    ")
>>thisForm.myDatetimeControl.Value = CTOT("  /  /     :  :   AM")
>>REPLACE dDate     WITH CTOD("  /  /    ")
>>REPLACE tDateTime WITH CTOT("  /  /     :  :   AM")
>>
>>You can also use the BLANK command if it's in a table:
>>
BLANK dDate, tDateTime
>>
>>And if you need it set back to NULL, you can use:
>>
REPLACE dDate     WITH {  /  /  }
>>REPLACE tDateTime WITH {  /  /     :  :   AM}
>
>great guy to have around
>
>Thanks a lot
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform