how to find datasourse status before commit

Hi Suranga,

The API api_datasource.isDirty(in_datasourcename_tx IN varchar2) returns whether any rows in the datasource has changed.

The API api_dataource.isDMLNecessary(in_datasourcename_tx IN varchar2) returns whether the datasource has changes in it that will be applied to the database in the next api_aplication.doCommit.

The difference between the two being that you may have a column in a datasource with updateable checkbox unchecked. If the data in such a column is modified, isDirty returns Y but isDMLNecessary returns N.

Each row in a datasource has an additional columns called DS_ROWSTATUS. If you retrieve the rows in a datasource using a datasource API such as getRow,getRowByPK,getQuery or getRows etc... then the record or the collection you will receive will have this additional column to indicate the status of the row. The valid values for the DS_ROWSTATUS column are implemented as constants in the api_datasource package as:

row_status_deleted: Constant that represents the deleted row status. row_status_new: Constant that represents the new row status. row_status_temp: Constant that represents the new row status which is not modified yet. row_status_updated: Constant that represents the updated status.

The row status might also be null which means that the row is queried from the database but no changes has been made on it.

Additionally you may use the api_datasource.getRowStatus or api_datasource.getRowStatusByPK API's.

Hope this helps.

Kind Regards, Yalim