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: [email protected] [mailto:[email protected]] On Behalf Of [email protected] 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
