Hi Claudio,

Thank you, very fast responce

I'll look into your script

thanks
Ricky

--- On Thu, 16/9/10, Claudio Romero <clauslack@...> wrote:

> From: Claudio Romero <clauslack@...>
> Subject: Re: [firebird-support] Loggin pc-client name and/or client ip address
> To: firebird-support@yahoogroups.com
> Received: Thursday, 16 September, 2010, 5:46 PM
> Hello check this in Spanish
> --Connect
> SET TERM ^ ;
> create TRIGGER AL_CONECTAR ACTIVE
> POSITION 0
> AS
> declare variable IP_remotO varchar(253);
> declare variable proceso_remoto varchar(253);
> BEGIN
>     for select
> m.MON$REMOTE_ADDRESS,m.MON$REMOTE_PROCESS
>     from MON$ATTACHMENTS m where
> m.MON$ATTACHMENT_ID = CURRENT_CONNECTION
>     into :IP_remotO,:proceso_remoto
>     do
>     insert into LOG_INGRESOS_SALIDAS(usuario,
> fecha, hora,
> accion,coneccion,rol,IP_remotO,proceso_remoto)
>     values(current_user, current_date,
> current_time,
> 'I',current_connection,current_role,:IP_remotO,:proceso_remoto);
> END^
> SET TERM ; ^
>
> --Disconnect
> SET TERM ^ ;
> create TRIGGER AL_DESCONECTAR ACTIVE
> POSITION 0
> AS
>
> begin
>       insert into
> LOG_INGRESOS_SALIDAS(usuario, fecha, hora,
> accion,rol,coneccion)
>       values(current_user, current_date,
> current_time,
> 'S',current_role,current_connection);
> END^
> SET TERM ; ^
>
> Regards
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources
> item
> on the main (top) menu.  Try Knowledgebase and FAQ
> links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>     firebird-support-fullfeatured@yahoogroups.com
>
>
>