Message
From
10/03/2010 11:56:47
To
Todo
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Título:
SQL Server 2005 - date field and VFP
Miscellaneous
ID da thread:
01453773
ID da mensagem:
01453773
Views:
108
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
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