Welcome Guest Login SignUp

Home

Technical

Functional

CNC

AS400

DB2

    Citrix

JDE News

Live Radio

Feedback

JDE Forum Comments/Reviews/Queries
3010 day(s) ago   #47
Name: Raj jde geek
Category: Technical
Location: 185
Date: 2012-02-27 17:31:39
Replies(0)

Status:
  #47

Value of SV File_IO_Status in Table IO Update/Delete

On 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.
Post Comments/Queries
Email:*
Name:*
Details:*
 
   
* Required Entry Field(s).  * Your comments may subject to varification.  * Your email ID will not appear in the forum.
 
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