I experienced a similar problem yesterday when testing an app for a client. When I put a SHOW DATE into the code it turned out a subroutine (that I hadn't written) was changing the DATE SEQUENCE which caused the -DATE- format error. I would suggest writing the date settings to a file just before the troublesome commands are executed then you can be sure something wierd isn't going on.
If this were a general RBase problem you can bet we would have heard about it from someone else by now. --------------------------------------- At 10:12 AM 6/24/2002 -0400, you wrote: >I have been having trouble lately with getting an "Invalid -DATE- format" >error in my programs. It is not consistent or predictable. The problem >seems to involve the use of variables in my code. I set date variables in >my code and then update, delete or insert rows into tables based on the >dotted date variables. In one particular program, for instance, I create a >temporary view with dotted date variables in the definition so that the >actual view definition contains a date reference like '06/16/2002'. This >has worked beautifully for weeks. Now today the only way I could get the >program to run was to change the reference to the dotted variables to >function variables by enclosing them in parens. i.e. instead of just using >.vstarting I had to use (.vstarting). > >I have gone over my code with a fine toothed comb. Sometimes the code works >fine other times it croaks on the date format error. Yes, I have made >absolutely sure that my date format is set correctly and consistently. I >have stepped through my code, I have examined the variables to make sure >there's nothing screwy about them. I get the error when I'm dealing with >different tables, so it's not just restricted to one table which may >indicate a data problem. I am using the latest official release of R:Base >for Windows on a Windows 2000 system. > >Has anyone experienced a similar problem? If so what was the solution? Is >it better to use variable references using the parens in the code -- >(.varname) vs .varname -- or shouldn't it work by just using a regular >dotted variable? This is driving me crazy not to mention screwing up the >data. > >Please, suggestions anyone? > >Thanks > >Mike Ramsour >================================================ >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/
