|
![]() |
#1 |
Участник
|
Well... you can set a trigger on the SqlDictionary table insert/delete to get an alert when a new field (or table/view!) is kinda created "physically" in the database (or when a table/view/field is dropped). In a database trigger you'll have to somehow connect to an AOS, enumerate user session objects and find an information about a user session that is currently using the database session in which a trigger is running (by the session SPID or something). Then you can find a record with this user session id in the SysClientSessions table and find out the userId.
Note that this way you can't monitor changes that don't alter the database scheme, e.g. changes in a field's label or EDT. Последний раз редактировалось gl00mie; 17.06.2011 в 14:38. |
|
![]() |
#2 |
Junior AX Developer
|
At first thank you for the answer.
The solution may work well no question but in my case i have to monitor property changes (label, mandatory, EDT) also. Do you have any other idea or approach how to do that ? Some more details: i want to monitor whenever there are changes for a protokoll. Normally we comment our changes e.g. on classes or form methods. But on tablefields (and EDT's etc) it's difficult to insert a comment. So for that i want to intervene in the insert/update/delete process so i get automatically a protokoll of the changes without doing anything manually expect the changes themselfs
__________________
Kind Regards Robin Последний раз редактировалось Dark Smile; 17.06.2011 в 15:05. |
|
|
Опции темы | Поиск в этой теме |
Опции просмотра | |
|