API_edit record not updating records if there is no change
Hello,
I have two tables that use API_edit to update records. One of them works like a charm and I can see that the table has been updated daily irrespective of a change in data. This table that works well has fields which are all populated with data. That is every field has a data element.
The other table that runs without error as shown below:
<?xml version="1.0" ?>
<qdbapi>
<action>API_EditRecord</action>
<errcode>0</errcode>
<errtext>No error</errtext>
<rid>459</rid>
<num_fields_changed>0</num_fields_changed>
<update_id>1699466034771</update_id>
</qdbapi>
does not update the table. Zero fields were changed. This table has fields that may or may not hold data for that record. There is no other difference that I have been able to discern between the two tables. I would like to see this table also show an update date even if there is no change.
Does anyone know what may be causing this?
Thanks
Deepa
------------------------------
Deepa Prashant
------------------------------