The very reason I have startup values stored as varchar in the DB and those are set with each login. Those extraneous .DAT files and .CFG will get you at some point or another.
> -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Bill > Downall > Sent: Friday, February 21, 2014 12:29 PM > 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 > > > > > > > > > > --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
