Hi KungFuKittens,
There are 2 ways to represent FoxPro dates in a text string. One is to use
the Date(Y, M, D) function. The other is to use curly braces: {mm/dd/yyyy}
(depends on your system settings) or {^yyyy/mm/dd}.
cSQL = "Insert Into TableName (DateField) Values (Date(2005, 10, 23))"
cSQL = "Insert Into TableName (DateField) Values ({10/23/2005})"
cSQL = "Insert Into TableName (DateField) Values ({^2005/10/23})"
--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
ci**************@msn.com www.cindywinegarden.com
Blog:
http://spaces.msn.com/members/cindywinegarden
"kungfukittens" <ku******************@no-mx.forums.yourdomain.com.au> wrote
in message news:ku******************@no-mx.forums.yourdomain.com.au...
Hi, question how do you insert from VB.net to a foxpro date field
eg insert into temp values('07/31/05', 2)
i keep getting a type mismatch error on the date field
temp table
date date
no integer :confused:
--
kungfukittens
------------------------------------------------------------------------
kungfukittens's Profile: http://www.hightechtalks.com/m121
View this thread: http://www.hightechtalks.com/t2267573