Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Get current_timestamp - avoid Session.GetRemoteDateTime
Tue, Nov 16 2010 9:24 AMPermanent Link

durumdara

Hi!

2.0.3.23.

When I debug a code, I always got "Manager cannot lock the session" errors.
Many times I got these errors on Session.GetRemoteDateTime.

How can I get the current_timestamp with a Query expression to I can get one row?
I search for the fastest way.

select count(*), current_timestamp from information.TemporaryViews

This retreive one row. But I don't know is this the fastest way or not?

Thanks:
  dd
Wed, Nov 17 2010 2:03 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

<< When I debug a code, I always got "Manager cannot lock the session"
errors. Many times I got these errors on Session.GetRemoteDateTime. >>

Just ignore them, they are trapped by EDB and handled.  This was corrected
in 2.04 B4.

<< How can I get the current_timestamp with a Query expression to I can get
one row?  I search for the fastest way. >>

Do you absolutely need to use a query ?  This method is the fastest way to
get the server date/time from a client's remote session:

http://www.elevatesoft.com/manual?action=viewmethod&id=edb2&product=d&version=7&comp=TEDBSession&method=GetRemoteDateTime
http://www.elevatesoft.com/manual?action=viewmethod&id=edb2&product=d&version=7&comp=TEDBSession&method=GetRemoteUTCDateTime

--
Tim Young
Elevate Software
www.elevatesoft.com
Image