Problems creating DataTable in .DBF File

Snaider

Hi!! I'm having a problem( again) while creating a .dbf file. First, I have this line to create the table: Create Table Results.dbf (BuyDate Date) And this worked well. Now, I've this line to add a date in the table: Insert Into Results.dbf (20070922) But it gives me a "Data type mismacth" error. I've already saw that the date format is YYYYMMDD. So where is the error here?? :confused:

ChandraRam

Rafael Carmo wrote:

Hi!! I'm having a problem( again) while creating a .dbf file. First, I have this line to create the table: Create Table Results.dbf (BuyDate Date) And this worked well. Now, I've this line to add a date in the table: Insert Into Results.dbf (20070922) But it gives me a "Data type mismacth" error. I've already saw that the date format is YYYYMMDD. So where is the error here??

AFAIK, a DBF file stores all data as ASCII text only - maybe this is the issue here...

Snaider

Just only ASCII text?? So why is there a Date format for .dbf file...??? I tried to insert '20070922', "20070922" and this didn't work as well... :(

ChandraRam

Snaider wrote:

Just only ASCII text?? So why is there a Date format for .dbf file...??? I tried to insert '20070922', "20070922" and this didn't work as well...

It's been a while since I have seen a DBF file... I think the Date type in a DBF file is a 10-char storage. Maybe you could try '03/13/2008' (depending upon your system locale)

Khawar Abbas1

Try this Insert Into Test2 values ('09/22/2007'); and check the data in database.

Do good and have good.

Snaider

It didn't worked...but I've just find out how to do it: Insert Into Results.dbf Values (CtoD([06/18/2005])) Only by this way it worked. Thx for everybody's help :laugh:

perryf_00

Dang. I'm stuck doing DBF stuff again! But to answer your question, you can use the "CTOD" function as you've seen. Or you can use {} as the field delimiters for an actual date field. So: Insert into Results({09/22/2007})