Re: CURRENT TIME revisited
Posted in 1994
On Fri, 9 Dec 1994, Scott Holmes wrote: } I still don't know why the phrase; } let p_newmsg.msg_time= CURRENT, } or even: } let p_newmsg.msg_time = CURRENT hour to minute We have one just like it that works fine let string_out = current hour to minute In this case string_out is defined as char(8). It was defined this way because a function using called for char(8). We run i4gl 4.11.UC4. -- Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; cwoodall@vth1.vth.colostate.edu } didn't work. I did get an erroneous report on when it doesn't work, } however. In p-code, the statement works okay if the program is called } from the command line, it doesn't work if the program is called from a } menu system or part of a prepared run statement from within another } program. } } My work around was to declare a new global variable: sys_time char(8). } Then, I replaced the CURRENT statement with: } let sys_time = TIME } let p_newmsg_msg_time = sys_time[1,5] } } This appears to work. By the way, p_newmsg.msg_time is defined in a } record defined like table statement and the field is defined as a } datetime hour to minute. If anyone has problems with the function } CURRENT I would still be interested in hearing about it. } } ... "She turned me into a Newt". "A Newt?" "I got better." ... } } } ----------- There are more things in heaven and earth, Horatio, ---------------- } Scott Holmes <sholmes@netcom.com> Informix 4GL Applications } ---------------- Than are dreamt of in your philosophy. ------------------------ } }