473,320 Members | 1,881 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Question: VB.net Insert To Foxpro Date Field


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

Oct 23 '05 #1
2 6326
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

Oct 23 '05 #2

wow... It worked thanks..
--
kungfukittens
------------------------------------------------------------------------
kungfukittens's Profile: http://www.hightechtalks.com/m121
View this thread: http://www.hightechtalks.com/t2267573

Oct 25 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

16
by: jason | last post by:
I'm tearing out my hair here: ACCESS 2000: When I attempt to overwrite a date in my date field with a new user selected valid date eg: 05/23/99 my date field changes to the TIME I updated the...
4
by: Matt Young | last post by:
I've been tasked with integrating an older management system based on DBF files with my snappy new ASP application to provide users of the ASP application with real-time data from the management...
18
by: Guinness Mann | last post by:
Greetings, I think I saw an article yesterday in which you told someone not to make an Identity column a primary key. I seem to remember you saying something like "It undermines the entire...
1
by: sean | last post by:
Hi All, I have one table TABLE1 in access2k on machine PC1, that has one column named DO_DATE with "Date/Time" data type. Two other machines PC2 and PC3 also running access2k. Each PC has its...
5
by: Fabrice | last post by:
Hello everybody, I'm working with Access 2002. I have to import Data from a Foxpro table that contains 25000 records in an Access table. I have a couple of restrictions placed on me for the...
2
by: kungfukittens | last post by:
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 ...
5
by: robecflo | last post by:
Hi Forum, i have a problem, hope somebody can give me ideas. I'm developing with windows forms and vb.net, and oracle as a database. At this moment i have a table called amortizaciones, this table...
10
by: Johny | last post by:
Is there a module for reading/modifing db files from Python? Thanks for help B.
3
by: Kunal Desale | last post by:
Hi, How to insert/update data in foxpro table field having datatype MEMO using Linked Server? I have written sql insert queries in which i have used linked server to insert data into foxpro...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.