You’re offline. This is a read only version of the page.
492
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.
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
Share
Report
All responses (
Answers (
