Hi Bill, I’ve experienced strange problems with dates being displayed in the RBase default format even though my settings are different. Haven’t seen the problem in a couple of weeks now, so maybe the newest release fixed something or perhaps one of the two things I did helped:
1) Make sure you RBENGINE91_64.CFG file reflects the date format and sequence you want 2) In the Forms Designer, Tables/Display Format... explicitly set the date format to what you want for each column Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, March 22, 2012 2:35 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Date and Time Error Message 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" <[email protected]> Date: Thu, March 22, 2012 11:18 am To: [email protected] (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: [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
