Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server 2005 - date field and VFP
Message
 
 
À
10/03/2010 11:56:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01453773
Message ID:
01453777
Vues:
50
>Hi
>
>I want a simple date only field, which isn't possible in SQL Server (only datetime or smalldatetime), as I'd like to bind the SQL table field to an object on myForm.myDate. I'm using an updatable cursor to allow VFP to update SQL Server with any changes to the data. The SQL Server field needs to stay in date format as I'll need to use the date in select statements.
>
>How do I overcome this? Do I need to store the date in SQL Server as a text field, and then covert backwards and forwards?
>
>Regards

Don't bind directly to a field, bind to a form's property (Date field). Then do replace manually yourself. This is how we handle this problem.

We're using sqlexec.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform