Utility and use of find method.

Utility and use of find method.

hi Ravindra,

Hope this will be useful.


All tables should have at least one find Method that selects and returns one record method should be a Boolean variable called method.

from the table that matches the unique index specified by the input parameters.

The last input parameter in a find

‘forupdate’ or ‘update’ that is defaulted to false. When it is set to true, the caller object

can update the record that is returned by the find

Example from the InventTable:

static InventTable find(ItemId itemId,

boolean update = false)


InventTable inventTable;



if (itemId)


select firstonly inventTable

index hint ItemIdx

where inventTable.ItemId == itemId;


return inventTable;


thanks jasmine