At 08:31 PM 7/1/2010, Howard Langfus wrote:rd
My config settings reflect the Century Threshold at 30 and
the Default Century at 19.
Howard,
Your config settings have nothing to do with the actual DATE
settings in your CONNected database. Default DATE settings
in RBENGINE90_32.CFG or RBENGINE90_64.CFG are useful and
enforced when a *new* database is created.
In your specific scenario, what you actually have to do is
to first CONNect the database, verify the DATE settings,
correct the settings accordingly.
Steps:
01. Start R:BASE eXtreme 9.0 and CONNect the database
02. At the R> Prompt:
SHOW DATE
This will display the current DATE settings for CONNected
database.
If you see a discrepancy, you may SET the DATE settings as
follows:
SET DATE FORMAT MM/DD/YY
SET DATE SEQUENCE MMDDYY
SET DATE YEAR 30
SET DATE CENTURY 19
Then, verify DATE settings:
SHOW DATE
You should see the following:
DATE format MM/DD/YYYY
DATE sequence MMDDYY
Century threshold YEAR is 30
Default CENTURY is 19
03. Now DISConnect the database, EXIT R:BASE, and repeat Step 01
to make sure that all is well.
You may also need to check any routine that CONNects the database
and changes the DATE settings.
Hope that provides you with some blue's clues ...
Very Best R:egards,
Razzak.
