Select FOR UPDATE and $update, is there a problem?
OK I got it to work by putting the “old row” variable into the parenth. Of the $update statement. It seems to require that you have an “oldrow” in there. Can anyone tell me why that is…why does it need to have the “old row” in there…does it compare?
> On Mar 1, 2018, at 1:29 PM, Das Goravani <das@Goravani.com> wrote:
> Is there a problem with using a $update to update a record that was SELECTED …. FOR UPDATE
> Do you have to do the update manually? Because it won’t work…the $update gives flag false and does not update the customer record. This is a straight forward thing..I’m updating the balance owed, this is a simple select fetch change a value and update scenario.
> Do iCustRow.$select(con(‘WHERE cust_id=’,iCustRow.cust_id,’ FOR UPDATE’)) Returns #F
> Do iCustRow.$update() Returns #S1
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:email@example.com