Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best way to edit SQL datetime
Message
De
13/02/2007 04:59:30
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
01194784
Message ID:
01194989
Vues:
17
>I'm looking for suggestions on entering data into SQL datetime fields. The client currently inputs the date portion into a textbox, the hour and minutes in 12-hour format using separate spinners for each and the am/pm portions using radio buttons. All 7 of these controls are bound to variables that are built into or parsed from time fields in the table each time one of the controls is accessed. Now that the data will be in SQL, I'd like to simplify the entry and editing if possible. I still need to display the date, start time and end time separately for the event. Does anyone have an easy/intuitive way to handle datetime entry?

Lynda,
You can use datetimepicker for date/time or datetime entry.
FoxyClasses for example has 2 sets of datetime control classes (one of them uses datetimepicker) that you can bind to a date,datetime or time string field (or unbound) and get input as date, time or datetime.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform