[RBASE-L] - RE: Date and Time Error Message

[beyring]

Buddy

 

This is a relatively new database and I checked to make sure there were absolutely NO Date data in any table. 

 

Autochk'd full - no errors.

 

Whatever directory or database I use, I get these errors.

 

I've loaded some date data, no error messages when I load.

 

Bill

-------- Original Message --------
Subject: [RBASE-L] - RE: Date and Time Error Message
From: "Walker, Buddy" <bu...@medschool.pitt.edu>
Date: Thu, March 22, 2012 11:18 am
To: rbase-l@rbase.com (RBASE-L Mailing List)

Bill

  I would do a couple of things to try and find the bad date (format).

 

1.       BRO ALL IN tableName WHERE dateField NOT BETWEEN 1/1/1800 AND 12/31/2199

 

2.       If the above fails trying using R:Scope to check the data.

 

3.       Make a copy of the database in a different folder. Unload all to a filename.all. Delete / Rename your copy of the database. Make sure “ERR MESS ON” and MESSAGES ON. Now run filename.all and correct any errors you may find. If there is a bad date it should error there when trying to load the data.

 

Buddy

 

 

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of beyr...@lampsoftware.com
Sent: Thursday, March 22, 2012 2:08 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Date and Time Error Message

 

Using the latest release of Extreme 9.1-64 I keep getting the following error messages in forms;

 

-ERROR - Illegal date formt specification (206) [OK]

-ERROR - Illegal time format specification (390) [OK]

 

In my startup file I put these lines;

SET MESSAGES OFF

SET ERROR MESSAGES OFF

 

This does not stop the display of these error messages.

 

These error messages started appearing with Version 9.1.5.20317.

 

My date settings are;

DATE format     MM/DD/YYYY
 DATE sequence   MMDDYY
 Century threshold YEAR is 50
 Default CENTURY is  19

 

My time settings are;

TIME format     HH:MM:SS
 TIME sequence   HHMM

 

My character settings are;

BLANK       
DELIMIT     ,
LINEEND     ^
SEMI        ;
QUOTES      '
PLUS        +
SINGLE      _
MANY        %
IDQUOTES    `

 

There is no date data in any of my tables at this point. Most times these error messages occur after menu choices are clicked OR whe the RETURN button is clicked to close a form and return to the Main Menu.

 

I revert RBASE 9.1 back 2 versions of Extreme 9.1-64 and these error messages DO NOT appear under similar circumstances.

 

Has anyone seen this behavior or does anyone have an idea as to why this may be happening ? Could it have to do with date variables in forms ?

 

HELP !

 

Bill Eyring