(RPG) updating row.status on upload

[DavidS]

Hello,

I'm working on a process to upload a batch of records from a local table on my mobile device to the iSeries server and I'm using selection criteria "row.status = 'M' or row.status = 'N'" similar to the shipped example "Example 302 - Upload changed TutorialContacts".

The problem I'm having is that I don't see any details on how to set the row.status value to U after the upload has taken place and so each time I'm uploading the same data.

Is there a simple way to do this? (I'm sure I'm missing an example or piece of documentation somewhere,) alternatively I was thinking of adding a new column to the table that we update when the record has been uploaded and use that but not sure if that would work well in terms of data transfer (read record, write to iSeries, then try to update the data on the table row.)

Hope that all makes sense and as always appreciative of any suggestions.

David

[tsupartono]

Hi David,

At the end of the upload, we need to indicate to the LongRange client that we have fully received the data. Once we do that, LongRange will reset the state of the data rows to unmodified, so you wouldn't keep getting the same rows uploaded.

An example of how to set this property:

LRNG_SetBoolProperty('/DB.OK' : TRUE );