|3010 day(s) ago||#47|
|Name: Raj jde geek
Date: 2012-02-27 17:31:39
Value of SV File_IO_Status in Table IO Update/DeleteOn an Update or Delete, SV File_IO_Status will always return “CO SUCCESS” even if the update or delete is not successful because the record does not exist. Per Development Standards, it is Working as Designed as stated in SAR 3434592.
According to SQL Database Standard, an Update or Delete is considered successful even when “zero” row records is returned by the Database Update or Delete.
The workaround is to issue a FetchSingle on the record to be updated/deleted and use the result of the SV File_IO_Status of the FetchSingle to issue the update or delete.
|Disclaimer:||Most of the posts in this blog cater solutions/suggestions/workaround to issues for specific tools release or JDE E1 version and are just information only. Please be carefule while applying it in your environment. JDEthread will not be responsible for any data loss or spec corruption (if any).|
Copyright Â© 2010 - 2020 JDEthread.in