Copy/Backup record to an Audit Table the easy way
One of the most common pieces of code developers have to write is to copy a record from one table to another. Recently I had to copy a record from …
One of the most common pieces of code developers have to write is to copy a record from one table to another. Recently I had to copy a record from …
Does that title sound funny? Can you update your Primary Keys of a record in a table too? Ofcourse you can, SQL does allow it. But does that work in …
Create a RTF template with OBIP for JD Edwards. We will do a tutorial with the AP Ledger file, and try to create a report with Amounts for an address number
In OneWorld XE/8.0 days, we used to have an application – P80010 – Table Definition Browser Application. This application was of great help, as it showed the database fields in the Table, its indexes, the DD item name, description, the Data type of the field etc.
You can do the same in the Newer versions of EnterpriseOne too, with a very simple app as shown in the article.
For people who have problems with SQL, there’s an easier way of changing backend database values. How about using MS Access where you can directly type in the values, and it gets updated or you can Insert, Update Delete & you can export, import…. and all.
Following is the tutorial for setting up MS Access with Oracle Database Backend for JD Edwards EnterpriseOne.
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.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.