I create trigger on all tables to track the deletions.

I need to be able to track the deletion from which computer in the trigger. How can I do that?


Many thanks,

Jianfei

Jianfei,

I'm not sure I understand what you want to do: do you mean you want to identify,
from inside the trigger, what computer fired it?
Also, are you using Client/Server or File Sharing?

--
Fernando Dias
[Team Elevate]

Hi, Fernando:

Yes, I want to identify from inside the trigger what computer fired it.

I am just using the file sharing.

Jianfei

Jianfei,

Since you are using file sharing the trigger is executed at the computer that
fires it, but I don't know any way to get the computer id except to create an
external function, in a DLL, that returns the computer name and call it from
inside the trigger. You can get help on the syntax to create external functions
here:
http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=10&topic=162

If what you wanted to get was the user name, then you could get it with the
function CURRENT_USER, but the computer id, I really don't know of a better
solution... I hope someone else here can come up with something better..

--
Fernando Dias
[Team Elevate]

Jianfei,

<< I need to be able to track the deletion from which computer in the
trigger. How can I do that? >>

Fernando is correct - you can't do so currently without using an external
procedure.  However, I'll see about adding such an SQL function.

--
Tim Young
Elevate Software
www.elevatesoft.com