Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.paradox    |    To crash or not to crash, asks Borland    |    9,834 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 9,551 of 9,834    |
|    Joseph Misko to All    |
|    String to Date Conversion Error    |
|    18 Dec 08 16:48:08    |
      From: pnews@sendto.org              I have a script that has been working for years. It is on a machine that       needed some rehaul due to a virus (I did not do the rehaul). Everything is       clean and otherwise working as before for a few weeks now.              In the script, I build a string based on criteria that is later converted to       a date. In this case the string is "07/01/2008" and I am getting the       following errors on the stack in Paradox X3.              (1) Date:Proc:Date: The value of the parameter, 'value', is not legal.       Cannot convert parameter to a date.              (2) Could not convert data of type 'String' to type Date'. The types are       mismatched or the values are incompatible.              (3) Invalid character: 07/01/20"0"8              So, it obviously does not like the third digit in a four digit year, but I       have never had this problem before with four digit years. I have already       verified that the BDE is set to FOURDIGITYEAR (TRUE). Must be some other       mysterious setting.              Has anyone seen this before?              Many thanks, --Joe              P. S. I guess there is a bit of Paradox trivia in message #2. I did type it       correctly and the first single quote before Date is missing. Guess that       coding/formatting issue was never picked up.              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca