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 > > > > > > > > >
