OWXer
Active Member
Hi List,
I created a customed application using a custom business view which joins F4301 & F4311 together (I understand there is a BV out there but I just used only some of the user reserved fields on F4311 so I created my own); the application is used to update the F4311 after the user reserved fields have been filled. It's a very simple application but ....
After all fields are filled, I pressed OK to update the file. I found that some key fields (SDKCOO, SDDOCO, SDDCTO, SDSFXO) are blanked out on the F4311 for those records I updated. The values of these fields showed up on the grid. I checked the debug log and found that the SQL statement to update the file is UPDATE TESTDTA/F4311 SET SDKCOO=' ', SDDOCO=0,SDDCTO=' '.... I am not sure what caused this to issue a statement like this.
I did, however, turn on process all grid rows on the form properties. (I need that turned on since some of the fields in the rows are filled using some default values when the grid are displayed; so, even the user didn't update the row, it did get updated behind the screen so I required this feature to write back to the file)
Your help would be very much appreciated.
Thanks,
OWXe SP13, NT
AS/400 V4R5, Citrix
I created a customed application using a custom business view which joins F4301 & F4311 together (I understand there is a BV out there but I just used only some of the user reserved fields on F4311 so I created my own); the application is used to update the F4311 after the user reserved fields have been filled. It's a very simple application but ....
After all fields are filled, I pressed OK to update the file. I found that some key fields (SDKCOO, SDDOCO, SDDCTO, SDSFXO) are blanked out on the F4311 for those records I updated. The values of these fields showed up on the grid. I checked the debug log and found that the SQL statement to update the file is UPDATE TESTDTA/F4311 SET SDKCOO=' ', SDDOCO=0,SDDCTO=' '.... I am not sure what caused this to issue a statement like this.
I did, however, turn on process all grid rows on the form properties. (I need that turned on since some of the fields in the rows are filled using some default values when the grid are displayed; so, even the user didn't update the row, it did get updated behind the screen so I required this feature to write back to the file)
Your help would be very much appreciated.
Thanks,
OWXe SP13, NT
AS/400 V4R5, Citrix