Fetch won’t work, and how much do you error check?

I have this code and it’s stopping on the fetch, I don’t know why, the record is there to be fetched, it fetched correctly to be put into the invoice…now I’m attempting to change quantity on hand levels in the save process and it won’t fetch, it gives flag false. Do I have something wrong in using #F or any ideas why it won’t fetch…is the flag erroneous sometimes?

Do iProdRow.$select(con(‘WHERE prod_id=’,iLineItemsList.line_prod_id,’ FOR UPDATE’)) Returns #F
If flag false
Do method $rollbackokmessagequit (‘Selecting or Locking an Inventory Item’)
End If
Do iProdRow.$fetch() Returns #F
If flag false
Do method $rollbackokmessagequit (‘Fetching an Inventory Item’)
End If
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com