Hello,
I am currently researching ways to Track foxpro table changes from
sources outside of the foxpro Application specifically from ACCESS. So
far I have been able to determine this information from within Foxpro
using a Database container and triggers that populate Created,
created_by, Modified, and modified_by fields when the field states
change on a record. However, this only works 100% from within foxpro.
When the Tables are modifed from ACCESS using an ODBC Connection the
Triggers do not work correctly.
The modified and created fileds get populated with the system date and
time correctly. I am using sys(0) to capture the Maching name and
network login when the modification is made.
Sys(0) does not work when the modification is made through ODBC.
Does anyone have an idea as to how I can determine Who made the
Change?
Regards
Ernie
