Error updating table on button press

[shaz68]

I have a headerless detail that is not attached to a BSVW. It has columns for Work Order Number (DOCO) and Percent Complete (PC). The user can key in data or import from a spreadsheet.

When I press the 'post' button, it validates all records, and if no errors occurred, it SHOULD update the work orders with the new PC along with some audit data. Instead, I'm getting a CO ERROR returned from the Update operation.

Can anyone see what I'm doing wrong?

<font class="small">Code:</font><hr /><pre>
Get Audit Information
VA frm_mnCurrentRow_INT01 = "0"
Get Max Grid Rows(FC Grid, VA frm_mnMaxRows_INT01)
While VA frm_mnCurrentRow_INT01 is less than or equal to VA frm_mnMaxRows_INT01
Get Grid Row(FC Grid, VA frm_mnCurrentRow_INT01)
If GC Work Order Number is not equal to <Blank>
F4801.Update
GC Work Order Number = TK Document (Order No, Invoice, etc.)
GC Cmp -> TK Percent Complete
SL UserId -> TK User Id
SL ReportName -> TK Program ID
VA frm_WorkStationId -> TK Work Station ID
SL DateToday -> TK Date - Updated
VA frm_TimeOfDay -> TK Time of Day
If SV File_IO_Status is not equal to CO SUCCESS
VA frm_cErrorsFound_EV01 = "1"
End If
VA frm_mnCurrentRow_INT01 = [VA frm_mnCurrentRow_INT01]+1
End If
End While
</pre><hr />

SV File_IO_Status is always CO ERROR after this. The work order number does exist.

 

[Dhaval Soni]

Hi Shaz,

Try to assign the "1" instead of "0"to the following variable:

VA frm_mnCurrentRow_INT01 = "1"

Thanks,

Dhaval

 

[shaz68]

I gave that a go, with the same results.

I had the application deployed to our test environment, and when I run it on the web client, it works - the appropriate fields are updated. However, if I run it on my fat client, I still get the error.

So the issue seems to be NOT related to my code above, but it's something to do with fat vs web client. I've never run into anything like this before.

 

[shaz68]

I'm not sure what happened there, but it's now working on my fat client too.

I guess the issue is resolved, though I'd be really interested to know what might cause it to NOT work on the fat client, and then later to start working.