I am trying to update the status of an Order record using:-
Patch(
'[dbo].[OrderJob]',
LookUp(
'[dbo].[OrderJob]',
OrderJobId = SelectedJob.OrderJobId
),
{
JobStatusId: ddStatus.Selected.JobStatusId,
LastUpdatedBy: User().FullName,
LastUpdated: Now(),
Comments: txtNotes.Text
}
)
nothing happens but when I go back into edit mode for the code, the above code looks like it is erroring and I have this error message:
An error occurred on the server. Server Response: [dbo].[OrderJob] failed: BadGateway.
The OrderJob table has a Primary key which is OrderJobId.
I am at a total loss, have looked on Google but can find nothing that helps.
