Power Platform Community Forum Thread Details

Hello,

I have the following error for the flow 'run sql request':

Incorrect syntax near the keyword 'ON'.
clientRequestId: 5fd63968-323f-4692-be74-e48aa4790cfb

I checked the syntax and there is no error, I try to make an upsert in sql.

I don't know where could be the error.

Here the request content:

INSERT INTO
 dim_customer_contract (
 idcustomer,
 Distribution_contract,
 contract_std,
 QTA,
 QTA_Type
 )
VALUES
 (
 '0000600029',
 'Yes',
 'old standard',
 '',
 ''
 ),(
 '0000600029',
 'Yes',
 'old standard',
 '',
 ''
 ) ON DUPLICATE KEY
UPDATE;

Thank you for your help.

Categories:

General topics

Ok the

ON DUPLICATE KEY
UPDATE;

Not working with sql-server, I don't know why everSQL said there is no error with this version of sql.

The solution:

MERGE dim_customer_contract AS target
USING (VALUES@{variables('tableUpsertFormatted')}) AS source (idcustomer,Distribution_contract,contract_std,QTA,QTA_Type)
ON target.idcustomer = source.idcustomer
WHEN MATCHED THEN
	UPDATE SET target.idcustomer = source.idcustomer, target.Distribution_contract = source.Distribution_contract, target.contract_std = source.contract_std, target.QTA = source.QTA, target.QTA_Type= source.QTA_Type
WHEN NOT MATCHED BY TARGET THEN
	INSERT (idcustomer,Distribution_contract,contract_std,QTA,QTA_Type)
	VALUES (source.idcustomer, source.Distribution_contract, source.contract_std,source.QTA,source.QTA_Type);