Using SQL in a validation script

[Former Member]

Hi Experts!

Can you give me an example code part of using a SQL select query in a validation script?

My aim is to query an extension table with a parameterized select and extract a single field value,

which can be used for further processing.

Regards,

Zolchee

[Former Member]

Hi

Plz take a look at IapiDbHandleIfc. There are many methods like "beginTransaction()", "executeQuery" etc. that can take care of your requirements.

Regards

Mudit Saini

[Former Member]

import com.frictionless.api.common.platform.IapiDbHandleIfc;

dbHandle = session.getDbHandle();
dbHandle.beginTransaction();
sQuery = "SELECT DOC_DESCRIPTION " +
     "FROM " +
     "FCI_CUSTOM_MD2 " +
     "WHERE " +
     "EID = '" + sParameter + "'";
dbHandle.executeQuery(sQuery);

This is an example how the query should look like, but can you please tell me how to use the results of the query?

Are the results stored in a ResultSet? How to extract them? The above query should return only one item - how to get that?

[Former Member]

Hi

Istead of executeQuery(), try using executeIsolatedQuery() for e.g.

Description = dbHandle.executeIsolatedQuery(sQuery);

Regards

Mudit Saini

[Former Member]

Thank you Mudit, your answer helped me to resolve the issue.

Best regards,

Zoltan Desztics