Skip to main content
Question

API_edit record not updating records if there is no change

  • November 14, 2023
  • 0 replies
  • 83 views
Forum|alt.badge.img+8

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
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Registered
    • November 14, 2023

    Do you have a field or data value in the first table that has some kind of timestamp associated with the table load? If you just want to see that something ran/changed - you can add a date/time field to table (2) and when you make your edit record call, include the value of 'Now' into that date/time field to enforce that at least one data point is changing with each daily run. 



    ------------------------------
    Chayce Duncan
    ------------------------------
    Terms & ConditionsAccessibility statement