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