Finance | Project Operations, Human Resources, ...

How to validate the insert/writing of a record without necessity of a trigger event?

(0) Share

Report

Posted on by Community Member

Consider I have just read a row from this csv file, each column is a field of a table, I have been asked to verify that the value in that record of a certain field is plausible for writing/updating in the associated table.

For example, field X can accept as values only the integers 10, 11, 12, 13......if on my csv file I read a record in which the field X has been set to 22, I should throw an error before I start any update/insert and prevent any processing of the whole row/record I read.

I usually always worked with validating the data that users inserted on forms the moment they inserted it, I never had a situation like this.

How can I call the validateWrite method without any triggerring event and verify that the value I just read is fit for writing?

Thank you very much.

All responses (4)

Answers (0)

Sort by

Suggested answer

Martin Dráb 240,922 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You can populate a table buffer with field values and call validateField() and/or validateWrite() methods. It doesn't save anything; that would require calling insert() or write().
Evaldas 1,800 on at

Like (1)

Report
Copy link

Link copied!

You can always call table buffer methods by directly calling them e.g. custTable.validateWrite or custTable.validateMethod(fieldId) for every field you need to validate.

Or you can create your own validation methods and call from the class you are importing the CSV file.

If you are using data entities, you should check data entity validation methods.

Various options. Depends on what exactly you need.
WillWU 22,363 on at

Like (0)

Report
Copy link

Link copied!
Hi Fabio,

You can verify this field when importing a CSV file.

Refer to the following codes:

CommaTextIo iO; FilenameOpen filename = @"C:\testFile.csv"; Container record; boolean first = true; Table1 table1; iO = new CommaTextIo(filename,'R'); while (iO.status() == IO_Status::Ok) { record = iO.read(); if (record) { if (first) { first = false;// skip the header } else { int num=conpeek(record, 1); if(isInteger(num)) { table1.yourfield)=num; } table1.otherfiled = conpeek(record, 2); //... table1.insert(); } } }
Suggested answer

Rahul Mohta 21,046 on at

Like (0)

Report
Copy link

Link copied!

also could explore option f using temp table and create copy over to temp and then use validation on temp rather on main table