Re: CURRENT does not work!

Posted in 1995

John Prideaux — 3 Jul 1995 12:54:26 GMT — source: Informix-list mailing list archive (1991-1998)

In <3t4n5u$1ndi@news.gate.net> stevie@gate.net writes: > >I am running 7.1 online on SCO ODT 3.2v4.2, and am experiencing an >interesting problem. When I assign "CURRENT" to a variable, the display >its contents, I get "0000-00-00 00:00:00". Today and time work just fine. I've got the same problem, but I had so many other problems during my recent upgrade (5 official bug numbers) that I forgot about it. I need to call Informix. In the mean time, I found a work around in those crazy first hours after our upgrade: SELECT CURRENT FROM SYSTABLES WHERE TABNAME = "systables". I know it is a horrible hack, but performance is good, and it returns the proper result. John Prideaux alastl@ix.netcom.com