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.
