Got it, thanks. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MikeB Sent: Friday, February 21, 2014 11:15 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: [No Subject]
No difference as long as it is part of the startup of any session. Everything stays the same across the user group for certain.. > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Brad > Davidson > Sent: Friday, February 21, 2014 1:41 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: [No Subject] > > Mike, > > We're talking here of a RUN SELECT statement against the table's > varchar, right? And if so, any advantage (or same thing) in this > method vs say, a main menu's form Before Start EEP? Just curious... if > I understood correctly in the first place! > > Brad Davidson > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of MikeB > Sent: Friday, February 21, 2014 10:06 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: [No Subject] > > 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. > ================================================
