Hi,
I need to use sql query in custom code for reminder emails.
I refered below code :
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);
But my query would return multiple rows with different types of column data.
What will be the return type of Query Results?
How to fetch multiple rows, where to return them?
Please guide me through.
Thanks,
Saloni