Table does not update real information
I have one table in zoho that I need to update everyday, the problem is that if the query i am using does not retrieve any row, the table keeps the information for the last day, showing old information
This is the parameters i am using for the upload tool:
<Query dbname="ReportingDB" tablename="MacCalls" importtype="TRUNCATEADD" matchingcols="" selectcols="" skiptop="" batchsize="1000" queuesize="-1">
How can I make the table update information even there is not information retrieved for the query?
Betza