Utah Jeff wrote:
>
> I looked at the BDE Init
> settings and tried all combinations of FOURDIGITYEAR and YEARBIASED.
> I keep seeing references to changing a Windows date format. Is there a
> fix for this problem since we do not have the source code? Where is
> the Windows date format setting they are talking about?
The first thing is to peek what is actually stored to the Paradox/dBase
database field. The BDE programmer's way to see inside database files is
to use the Database Desktop application that comes with Delphi
development environment.
But if you do not have Delphi, you do not have access to that tool. Then
you could use some free replacement tool like this for instance
http://prdownloads.sourceforge.net/jedidbd/jedidbd_install_0.2.0.0.exe?download
If your application has internal program fault that makes some
calculations with two year digits, and then stores a wrong century to
the database, then there's not much you can do, but to abandon the
application. Or to find a skillfull hacker who possibly could hack the
EXE file, but this is not likely.
Date/Time values can be stored as a Float number, and Date values as
Integer numbers to some numeric DB field, and the programmer could have
used these tricks also. Then your Database Desktop tool may not even
find a Date Field that would look like a Date at all, like 17 May 2006,
but a integer representation 732448 of that date.
Of course, if you are lucky you could find some Win/BDE setting that
turns everything back to order again.
DB-1
|
