I created my own problem and now will always use Razz's startup settings for everything Tom Hart
________________________________ From: Karen Tellef <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, January 13, 2014 9:37 AM Subject: [RBASE-L] - Re: Datetime issue One thing I'll share that caused us a weird issue regarding "time". All my clients use this time format: TIME format HH:MM:SS TIME sequence HHMMSS At one of them, we started having a problem where an old program would select a Max(datetimecolumn) from a table, and then do an "edit using <form> where datetimecolumn = .theValue". And it all of a sudden started failing. It took a "bug" report to RBTI for them to point out what my problem was! The time settings had changed to this: TIME format HH:MM AP TIME sequence HHMMSS Using 9.5's "find in forms" feature, I found that another programmer on the job had used some RRBYW code that had specified that time format! So there was a mismatch between the sequence and the format and that prevented the "where" clause from working. Whoopsy! Karen -----Original Message----- From: A. Razzak Memon <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Sun, Jan 12, 2014 6:34 pm Subject: [RBASE-L] - Re: Datetime issue At 06:41 PM 1/11/2014, Tom Hart wrote: >That is what I did different, I copied from your earlier post but >somehow the set time format was HH:MM:SS, I have that resolved now. Tom, I am >glad to hear that. >Why does that affect the datetime stamp? For your >education ... Every UNLOAD routine (except AS ASCII), always carries the native settings as follows: CHARACTER Settings BLANK DELIMIT LINEEND SEMI QUOTES PLUS SINGLE MANY IDQUOTES CURRENCY Settings SYMBOL PREF and SUFF Subunit Digits FORMAT Operating Conditions CASE AUTOSKIP REVERSE BELL TOLERANCE ZERO Special Character NULL DATE Settings YEAR CENTURY SEQUENCE TIME Settings SEQUENCE These settings are enforced to assure the successful LOAD of the unloaded file. So, when you are loading and implementing someone else's form, external form, label, report, or table/view structure, after a successful load, it is your responsibility to verify and reset your database settings, if necessary. Thus, the need to enforce all default settings in your startup application file, as suggested in my earlier reply. Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
