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.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

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().

Was this reply helpful? Yes No
Evaldas 1,800 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
WillWU 22,363 on at

Like (0)

Report
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(); } } }

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

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

Was this reply helpful? Yes No