Sorry I am starting a lot of threads at the moment.

Can anyone explain this to me:

SELECT
ID,
Name,
IF(Current_SessionID = ID THEN 'Yes' ELSE 'No') as "IsItCurrent",
Current_SessionID
FROM Configuration.ServerSessions
WHERE ID = Current_SessionID

Run the above against a remote instance of EDB Server, ideally running a few sessions.

It returns a row (ie the WHERE statement returns true) but the computed field returns "No" ... HUM, scratches head ...

I ask because it is useful for me to identify the current thread in this way in certain circumstances, and the above ought to work!

Adam

I suspect that its some sort of timing or context problem. What happens if you take the WHERE clause out?

I can't test here because I no longer run a server.

Roy Lambert

I ran it on one of my servers that always has lots of connections (2.28b6) and it returned "Yes".  There must be more variables we are not aware of . . . yet

gbh100 wrote:

>> it returned "Yes".  

OK, thanks for this, your system is working as I would expect, but mine is not. I am calling the Query from EDB manager and from a Delphi EXE, both definitely accessing EDB via the server.

I will try to figure out what I am doing differently!

If I find out anything useful I'll post about it.