Why does SalesLogix automatically update the modifydate when I update a table?

 Question:

When creating a new Integrity Checker test to update a table
it seems to automatically update the MODIFYDATE of that table, even
though it is not in the UPDATE statement for the test.  Is there any way
of stopping that from happening.  We have sometimes to fix the data in
one field in all records in the table due to a bug but don’t want to
change the modifydate as there is some other functionality that relies
on this date to include/exclude records in an automated export – this
should be based on user modification.

 

Answer:

It’s the SalesLogix provider that is doing it automatically. IF an
Update or Insert (be it SQL statements or an ADO recordset) does to
specify a value for:

   A – CREATEDATE

   B – CREATEUSER

   C – MODIFYDATE

   D – MODIFYUSER

Then the provider will do it automatically.

 

 

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!