As the old database is Dbase IV,
the old system DO NOT use 'date' format as field....

The date field data Maybe:
i) Aug. 23, 96
ii) Aug. 24, 96.
iii) Aug 25,97.
....

I need to transform to correct date format!!
Currently I use character(old format) to get this string...

That is, Table 'Orders' with date field 'Order_date' (Old Format)
and I add a new empty Column 'Orderdate' for transform date....

I Don't Know how to write a .prg to handle the database....

I just know little on SQL command...
Select field(s) from database!table where [condition];
Delete from database!table for [condition];
update database!table SET field = ... for [condition];

Anyone can tell me the open file and close release structure on VFP??
Thanks a lot, pls mail a copy to my mailbox!! ^-^"" Thanks