Hello,
Can you please explain to me how I can accomplish the following?
1. At start-up of my application I load serveral tables in memory.
These tables are used for LookupComboBox-fields.
2. All changes to databasetables will be recorded in a log-table
showing tablename, username and change-datetime
3. Application will run SQL (Threaded Timer) in order to determine
tables that were changed after last check and will ideally only retrieve
changed records (based on last change DateTime of records).
Example:
Databasetable MyTableA contains 3 records
- 1 name1
- 2 name2
- 3 name3
MyTableA is loaded into Memory_MyTableA + LastReload-DateTime is recorded
MyTableA is changed.
- 2 newname 23-01-2009 12:30
Log-table entry is added
- 23-01-2009 12:30 MyTableA User1
Application will retrieve changed records from MyTableA
- 2 newname 23-01-2009 12:30
MyTableA is updated
- 1 name1
- 2 newname
- 3 name3
Is there a way to remove, add and update records in memory based on retrieved changes from database (see 3)? In other words is it possible to limit networktrafic and not load all records when some table is changed?
Do you have some best practice for this kind of situation? How to set it up?
Thanks, Stef