Update / Insert / Delete Record in DocuRef Table

(0) Share

Report

Posted on by Senthil Yadav

490

Hello Everyone,

We have a requirement to Update / Insert / Delete records from DocuRef Table. We are trying to do it using a Job.

We are uploading CSV file with Data to be uploaded in DocuRef Table. While uploading we need to check different conditions based upon the data present in CSV File and Docuref Table.

1. If the records exists within Notes Field containing different data as present in the CSV file. We will update the record with CSV File Details.

2. If the records exists within Notes Field containing same data as present in the CSV file. We will delete the record from DocuRef Table and insert new record present in the CSV File.

Can you please suggest Job for implementing the same. we have written a job and are not able to compare the field Notes with the data present in CSV File.

Error is shown as

Please guide, thank you.

All responses (1)

Answers (0)

Suggested answer

ergun sahin 8,816 Moderator on at

Like (1)

Report

RE: Update / Insert / Delete Record in DocuRef Table

use "while select", delete Note part. In while you can use if clause (assignment can be required and data loss may occur if size of memo is greater than str)

Or use query

www.1clickfactory.com/.../