0
Patch(
    SOP10100,
    First(Filter(SOP10100,SOPNUMBE=SOGALLERY.Selected.SOPNUMBE)),
    {CUSTNAME:TextInput3.Text},{CUSTNMBR:TextInput4.Text},{SOPTYPE:Value(DataCardValue15.Text)},
    {DOCID:DataCardValue16.Text},{DOCDATE:DateValue3.SelectedDate},{BACHNUMB:DataCardValue18.Text},
    {LOCNCODE:DataCardValue7.Text},{CURNCYID:DataCardValue9.Text},{CSTPONBR:DataCardValue8.Text}
);

enter image description here

If I used collection it work fine, but when I wish to direct update current document inside database it come out this error. What does this sql error means?

Desmond Sim
  • 211
  • 2
  • 19

1 Answers1

0

This question was asked here a while back, hope this helps: Error when submitting "new" form to SQL

JBerg
  • 411
  • 1
  • 3
  • After I read it, the forum suggested that use store Procedures to do update. Have any suggestion other than this? Is it must use store procedures to create / update / delete in powerapps. – Desmond Sim Jul 04 '22 at 01:05