Tom:
Also, be alert to controlling the time sequence during Gateway Import operations, to ensure you're getting what you want and avoid do-overs. For example, Excel INSISTS I take seconds from a time column, when all I want is hours and minutes. Child's play in RBase: SET TIME SEQUENCE HHMMSS <gateway import xls d:\blahblah> SET TIME SEQUENCE HHMM Thanks to Dennis McGrath for that tip. Cheers, Bruce From: [email protected] [mailto:[email protected]] On Behalf Of TOM HART Sent: Monday, January 13, 2014 7:44 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Datetime issue I created my own problem and now will always use Razz's startup settings for everything Tom Hart _____ From: Karen Tellef <[email protected] <mailto:[email protected]> > To: RBASE-L Mailing List <[email protected] <mailto:[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] <mailto:[email protected]> > To: RBASE-L Mailing List <[email protected] <mailto:[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 <http://www.rbase.com/> www.facebook.com/rbase <http://www.facebook.com/rbase> -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
