GRID Error using "First" method returning False when there are items in grid

• 06-05-2008 11:44 AM

  NeilC Joined on 06-05-2008 Posts 1

  GRID Error using "First" method returning False when there are items in grid Reply Contact Using the object model we are importing Purchase Orders from another system into Solomon.  We are see the following error behavior:  When a Po already exists in the system, we search the detail grid to see if the item has already been entered If found we will update it, if not we will create it. Per the example given in the Object Model documentation, we first see if the Purchase order has any records using the following code bRecordFound = (solomonOMSPOConnect.First(StrDataEntity) = sivRecFndFound) The problem is that it appears that solomonOMSPOConnect.First(StrDataEntity)  will sometimes return false even when the PO item grid  has one of more detail records.  This results in us creating a new item (since we don't think there is anything in the Grid) when in fact there is already an irtem in the grid, in other words a duplicate. Has anyone else seen this behavior?  Is there an effective workaroud