Hi Tom,
thank you for reply. It could be a reasonable way to check the calling client, even if it needs more code and change each sql sequence. I'm looking for something more simple and fast, like Windows API: at least checking which client is connected, at the moment, to the server
Bye
>Hi Francesco,
>
>with GETENV([COMPUTERNAME]) and GETENV([USERNAME]) each client-pc can submit it's name and the user's name. To check, which data is being read, I would create a seperate table i.e. currenttasks containing information like
>
>id i (autoinc),
>computername c(20),
>username c(20),
>tablename c(20),
>accesstype i (INSERT=1/DELETE=2/UPDATE=3),
>beginwork t (datetime),
>endwork t (datetime)
>
>Before each sql sequence just call a routine i.e. filltaskstable(1|2|3). The given parameter defines the accesstype.
>
>A second possibility would be, to create triggers for those tables, that you are mostly interested in. However, AFAIK those wouldn't be able to set an endwork field.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement