[b][red]This message was edited by j.haaksma at 2003-9-28 11:41:40[/red][/b][hr]
[b][red]This message was edited by j.haaksma at 2003-9-28 11:38:34[/red][/b][hr]
In my app I use a dbgrid and a local foxpro table. ( created using foxpro for dos version 2.6)
In the dbgrid a date field is shown as dd-mm-yy format with the yy being 19 or 20 (the century)
I would like this to be a yyyy format, how do I change this?
shortdateformat and longdateformat don't make a difference
also I have set the fourdigityear in the database engine to true.
no luck either.
Also when deleting a record this record is not really deleted.
It is marked deleted, but the actual record is still there
( for example the table1.recordcount says there is just 1 record while the table1.recno variable shows there are more than 10!)
I looked at cache settings, but can't find the solution
Please help me out here...