Ask a can analyze a program for small database SQLite monitoring (increase and modify) records,
Such as: branch transfer desk SQLite database, when families pass the front desk in the business operation (increase and change), I want to monitor the changes in database and data table reaction (increase or decrease),
Analyze the business procedure control points of data table,

CodePudding user response:

You may be looking for the writing of the database triggers method, consider this: https://blog.csdn.net/u013600225/article/details/53932695

CodePudding user response:

The To doloopcn:
Thank you for your reply, I am not looking for a trigger to write, I am looking for a similar monitoring data to the database and modification of records, the convenient I parse section at the front desk know when business operations a feature will trigger the table and the content,

CodePudding user response:

Supplement: due to special reasons I need to pass the front desk system version 3.1 data structure is analyzed, and no documents online, he thought the only way, is through to monitor database, to master the inside structure to analyze the program logic, then directly to the SQLite database through the program I wrote batch write sales list and detail,

CodePudding user response:

Write some specific test data, and then find the related data in which tables which fields, basically can guess,