Mike, I believe setting the date format while operating as the OWNER impacts all users.
I used to SET DATE FORMAT MM/DD/YYYY, import some data, and then SET DATE FORMAT MM/DD/YY. At the time, I thought it was necessary to do that to read my data correctly. Other users were typing data with two digit years and their dates ended up with years like 00YY. Even thought my date format switch was rapid, occasionally we saw the funny years. Since it didn't happen a lot, it took us a while to discover what was causing it. It has been quite some time since we had this problem and it was on an earlier version of R:Base. It may also be that my memory is flawed! However, I will repeat what I think is the essential element involved. "I believe setting the date format while operating as the OWNER impacts all users." If someone knows better - by all means correct my impression. Bill Cook Kent WA USA ----- Original Message ----- From: "Ramsour Mike" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 5:32 AM Subject: Invalid date value (2418) error > Good morning to all: > > I am having an ongoing problem in R:Base (6.5++ for Windows) that is driving > me bonkers. The biggest problem I am currently having is that my programs > which use DATE variables, will sporadically throw an "Invalid date value > (2418)" error. I say sporadically because I can run a given program and it > will display this error and then I can immediately rerun the same program > with no changes in anything and the error will not appear. I have been > through my code with a fine-toothed comb and can find no plausible reason > for this. I make absolutely sure I am using a standard format and my > variables are all typed at the time of creation. > > Periodically I will enter a SELECT statement at the R> such SELECT <columns> > FROM table WHERE date_column BETWEEN 09/01/2002 AND 09/20/2002 and R:Base > will complain saying Invalid date value. I can sometimes place the date > values in single quotes and R:Base is happy. The frustrating thing is that > this is not consistent. Most times it works properly other times it > complains. > > Is there something I should be looking for in my code or is there something > going on with R:Base and the way it handles date values -- whether as > variables or as hard-coded values? > > On another note, I run R:Base on a Windows 2000 system. I run nearly 100 > programs each morning that vary from loading new data into the database to > printing out reports. It takes about 3 hours for all of the programs to > run. I can go for days and everything runs perfectly. This week, however, > R:Base is crashing every morning at various points in the morning update > routine with a Windows memory error. There are usually 3 separate messages > that you have to click through with the final result being that R:Base has > crashed. The message is to the effect that An error has occurred in RBG65 > at <memory address>. Windows was unable to read the memory at address <such > and such>. > > Cany anyone tell me if this is a Windows issue or an R:Base issue? I will > sometimes get a similar message when I'm running Excel. > > My PC has dual 550 mhz Intel processors with 256 MB of RAM. > > Any help is greatly appreciated. > > Thanks > > Mike Ramsour > Voice: 740-829-4340 > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
