• State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 94 subscribers
  • Views 982 views
  • Users 0 members are here
Options
Related

Setting log changes for all fields of a table

ermes.crico
over 3 years ago

Hi all,

The customer would like to store on history DB all field changes of a table.

I thought about using the following sql example code for adsaccount table:

Update dialogcolumn
set isTowatch=1, istowatchdelete=1
where UID_DialogTable like '%ADSAccount%'
and ColumnName not like 'X%'
and ColumnName not like 'Extension%'
and ColumnName not like 'Terminal%'

Is this update enough or is it necessary to do something else?

Thank you very much and best regards

Ermes

Parents
  • 0 over 3 years ago

    Hi Ermes,

    I'm pretty certain that setting the istowatch values generates jobs into the DBQ to create the required triggers.  I'm not certain this will happen if you bypass the object layer.

    If you still want to do this in bulk you could always use the DataImporter tool or if you really want to use SQL then perform the updates via the object layer using 'exec dbo.QBM_PJobCreate_HOUpdate ..............'

    HTH, Barry.

Reply
  • 0 over 3 years ago

    Hi Ermes,

    I'm pretty certain that setting the istowatch values generates jobs into the DBQ to create the required triggers.  I'm not certain this will happen if you bypass the object layer.

    If you still want to do this in bulk you could always use the DataImporter tool or if you really want to use SQL then perform the updates via the object layer using 'exec dbo.QBM_PJobCreate_HOUpdate ..............'

    HTH, Barry.

Children
No Data