02-20-2012 10:10 AM
I'd like to know the last date and time the ACT! database fields were modified/edited using the "Define Fields" menu item under "Tools".
Is it possible to get this info in a Plugin?
02-22-2012 07:17 AM
02-22-2012 10:09 AM
Vivek is unfortunately correct. The information can be found in TBL_SYSCOLUMN, it's not an available view in the OLE provider either so the only solution is to get the data directly from SQL server.
02-22-2012 11:57 AM
Since you're just reading, there aren't really any risks. TBL_SYSCOLUMN.EDIT_DATE has what you're looking for, though I'm not sure if this only applies to changes made on the layout editor or also changes made in define fields. Further, I'm not sure it'd consider it an edit, if it were only moved on the layout.