The hint to me is the "out of dynamic space" message. When I get it that
the command has misplaced or missing parentheses or quotes. I did have
one glitch while I was having fun with the tests - I was bored, and this
is an interesting problem - when I had mixed up / and - as the separator
in the date. If ZZG_Enddate_T is not exactly the format of the date
database date settings, it bombs out. My thought is that perhaps
ZZG_Enddate_T ended up as dd/mm/yyyy, and it won;t work. It's an
interesting situation, for sure. Another possibility is that your format
and sequence are not identical. I have always used the single SET DATE
and don't use the two line date setting commands. My sequence was four
digit year, as was the format.
Albert
On 3/28/2014 3:07 AM, Tony IJntema wrote:
Albert,
You are right it works on an individual level.
But if I try to update all the columns in one go I receive an error message
update IPT_Import_Care set ZZG_Enddate = ZZG_Enddate_T
-ERROR- Expression does not return a valid DATE. (2158)
-INTERNAL ERROR- Out of dynamic space
ZZG_Enddate column with date setting
ZZG_Enddate_T column with text setting
Tony
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry
Sent: vrijdag 28 maart 2014 4:39
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Date problem while importing Excel sheet
Actually it works that way just the same. Canada is half and half -
officially dd/mm/yyyy, but being next door to mm/dd/yyyy we never know what
to expect.
R>SET DATE DD/MM/YYYY
R>SET VAR vDateText TEXT = '30/06/2014'
R>set var vdate date = .vDateText
R>show var
Variable =
Value Type
-------------------------------- ------------------------------
-------
#DATE =
27/03/2014 DATE
#TIME =
21:36 TIME
#PI =
3.14159265358979 DOUBLE
SQLCODE =
0 INTEGER
SQLSTATE =
21S01 TEXT
#NOW = 27/03/2014
21:36 DATETIME
vDate =
30/06/2014 DATE
vDateText =
30/06/2014 TEXT
On 3/27/2014 1:00 PM, Tony IJntema wrote:
Thank you all for your support.
Albert, I think that one of my problems is the date setting. In
Holland commonly the setting dd-mm-yyyy is used.
>From a long time ago I can remember that there was no issue
converting text
to date if dd/mm/yyyy is used.
