i load this table .. but its refresh each time .. what i want is a new table which adds the new records from TABLE or changes the record in the new table if any item of TABLE is changed.
plus an additional LastMuteDate in the new table. This field is updated if a new record is added or a change is made.
Hi, you may check the OL-Help for sequential load, but for some of your requirements you would need "Last Modified"-field or the like. Alternatively you may concatenate the existing entries and compare with the SQL-table (AUTONUMBER() and EXISTS() might help), but then you will have to reload the entire table.