Forms 5.0 SYSDATE bug
Date: 1997/12/31
Message-ID: <19971231013500.UAA25064_at_ladder01.news.aol.com>#1/1
Hi All
A warning about a "new feature" in Forms 5.0 (Scratch that new feature bit, support called me as I write - it's now bug # 605998)
SYSDATE returns the CLIENT date/time, not as you would expect the server value.
So
:my_block.my_date := SYSDATE;
displays a value which is different to
select SYSDATE
into :my_block.my_date;
Forms 4.5 and ealier releases returned the same value for both, which is what you would expect.
Very disconcerting when you convert an
application from 4.5 to 5.0, especially
when you have users in different time zones.
Another chance for me to ride one of my
hobby horses though - the modularise code
one. I had to update code in 3 or 4 library
functions and 95 percent of my problems
are fixed.
Regards
John
John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103
FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com
e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/
The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.
Received on Wed Dec 31 1997 - 00:00:00 CET