One learns something every day, Bill, and I appreciate the lesson given.
Karen is correct in that EVERY form date/time that I see in the DB explorer changes EVERY time I get into the DB. I only want the date/time it to change when I make changes in the form I am working on. James Belisle Making Information Systems People Friendly Since 1990 From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Friday, February 21, 2014 11:29 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: [No Subject] Jim, Why would your date settings not affect the form dates? DATE SEQ is not just for manual data entry, but for all incoming dates. When you update or create a new form, R:BASE is inserting or updating the value in sys_forms3.sys_form_mod_ts. I think your incorrect setting in you DAT file is causing having with your dates, not just in sys_forms3, sys_reports3, and sys_labels3. Do you ever have dates in other tables that do not seem to be sorting correctly? Maybe some of them are set 20 centuries too early. Bill On Fri, Feb 21, 2014 at 12:15 PM, Jim Belisle <[email protected]> wrote: Bill, I understand what you are saying about the input of DATES on data entry. However I do not see how that affects when I EDIT a form and save it and what I see in the DB designer. The date/times shown in the DB designer should only change when I save a particular form. Not all of them change every time I get out of the DB and back in. This is the problem I am trying to resolve. James Belisle Making Information Systems People Friendly Since 1990 From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Friday, February 21, 2014 11:08 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: [No Subject] Jim, DATE SEQUENCE should almost never have four Ys in it. That means on input, R:BASE will require all four digits. Any date that comes in with only two will be treated, for example, as the year 0014 instead of the year 2014. Once you correct that in your startup DAT file, you may still have a lot of confused dates on your forms, reports, and labels, until the next time you edit and save them. Bill My suspicion is that this database has a peculiar detting saved for its dates. On Fri, Feb 21, 2014 at 11:55 AM, Jim Belisle <[email protected]> wrote: At the beginning of the month, I had sent out this question. I have still not been able to resolve the problem. Up until three weeks ago, the only time the date column updated on my forms/reports was when I would make changes to the form. This would be the fifth column while looking at the forms in the DB explorer. Since then the date time always updates every time I open the DB. This only happens on this particular DB. My other two DB are just fine as is the sample DB. I did an unload/reload. No problems. The only two boxes checked on my Form designer settings are: use compression and show action designer hints. Below is the DAT I use to open the DB. DISCONNECT -- clear scratch files SET ERROR MESSAGE 2077 OFF CLEAR VAR vChkFile SET VAR vChkFile INTEGER = NULL SET VAR vChkFile = (CHKFILE('C:\TEMP')) IF vChkFile <> 1 THEN MD C:\TEMP ENDIF SET SCRATCH C:\TEMP SET ERROR MESSAGE 2262 OFF SET ERROR MESSAGE 2926 OFF SET ERROR MESSAGE 2077 OFF ERASE C:\Temp\*.$$$ SET ERROR MESSAGE 2926 ON SET ERROR MESSAGE 2262 ON SET ERROR MESSAGE 2077 ON SET QUOTES=NULL SET QUOTES=' SET DELIMIT=NULL SET DELIMIT=',' SET LINEEND=NULL SET LINEEND='^' SET SEMI=NULL SET SEMI=';' SET PLUS=NULL SET PLUS='+' SET SINGLE=NULL SET SINGLE='_' SET MANY=NULL SET MANY='%' SET IDQUOTES=NULL SET IDQUOTES='`' set files 200 set staticdb Off set fastlock Off {set staticdb on set fastlock on set qualcols 10 connect dbName} set messages on set error messages on set multi on set zero on set trace off SET Walkmenu on set null -0- set date for mm/dd/yyyy set date seq mmddyyyy set currency '$' pref 2 b -- connect to database CONNECT labor RETURN The CFG file has these settings AUTOCOMM OFF AUTOCONV ON AUTORECO OFF AUTOROWV OFF AUTOSYNC OFF AUTOUPGR ON COMPATIB ON ERROR ON MESSAGES ON BELL ON INSERT ON ZERO ON HEADINGS ON CLEAR ON AUTOSKIP OFF REVERSE ON CASE OFF SHORTNAM OFF ECHO OFF WINAUTH OFF UINOTIF ON RULES ON ESCAPE ON AND ON SCRATCH ON RBADMIN OFF TRACE OFF SORT OFF LAYOUT OFF ANSI ON WRAP ON EQNULL OFF OLDLINE ON MANOPT OFF INTENSIT OFF FEEDBACK OFF PROGRESS OFF ONELINE OFF FIXED OFF SELMARGIN 0 TIMEOUT 0 WRITECHK OFF WINBEEP OFF WHILEOPT ON PASSTHROUGH OFF INDEXONLY ON FASTFK OFF EOFCHAR ON DEBUG OFF WALKMENU ON SORTMENU ON SERVER ON LOOKUPS 50 QUALCOLS 10 NAMEWIDTH 18 NULL -0- WIDTH 79 LINES 20 FILES 200 TOLERANC 0. NOTE_PAD 10 MULTI ON STATICDB OFF NAME USER20131219121818 VERIFY COLUMN ROWLOCKS ON FASTLOCK OFF WAIT 4 INTERVAL 5 REFRESH 0 TRANSACT OFF MAXTRANS 201 MDI ON AUTODROP OFF RECYCLE OFF Any suggestions on where to look would be appreciated. James Belisle Making Information Systems People Friendly Since 1990
