| Reg Domaratzki \(iAnywhere Solutions\) 2005-07-11, 8:23 pm |
| The connection ID you're getting in the EVENT is the connection that is made
to execute the event, not the connection_id that triggered the event.
You'll want to use the EVENT_PARAMETER function to get the connection id of
the connection that caused the event to be triggered. Where you used
" connection_property(
'Number')", substitute "EVENT_PARAMETER (
'ConnectionID' )"
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"Bob Piskac" <Bob@pbsoftware.com> wrote in message
news:42d2c88c$1@foru
ms-1-dub...
> I need to track people logging into the database. I setup two events for
> User Connected and User Disconnected. I then ran select
> connection_property(
'Number') but the number it returns is different in
each
> event. Is there a better way to track user connections and disconnects?
>
>
|