duplicate key value in SQL

(0) Share

Report

Posted on by WFCH

Hi All,

I am currently working on a flow that writes data from 7 different forms (MSForms) into a SQL database.

I am currently receiving an error message: Violation of PRIMARY KEY constraint 'dbo.MY_DB'. Cannot insert duplicate key in object 'dbo.MY_DB'. The duplicate key value is (5).

This happens because I have multiple forms running in the same table in my SQL DB. Since each form has a separate form ID, this causes problems in the SQL DB afterwards. e.g. Id 3 from Form1 and Id 3 from Form7.

Now my question: Is there a way that the form ID's (primarykeys) are always incremented so all the id's of all forms are always unique?

Thanks in advance and best regards

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

Form Response ID across different forms wont be unique. You will have first response Id as 1 in every form. But Form ID which is a GUID will be different. You can Append Form ID with Form Response ID and then make that as a Primary Key.

Was this reply helpful? Yes No
WFCH 4 on at

Like (0)

Report
Copy link

Link copied!

Hello Prasad,

Thanks for your reply.

And how exactly would I do this? Does this mean i should connect Form ID with the Form Responce ID and make them together one primary key?

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

Yes that is what I recommend.

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

@WFCH - Did you get chance to alter Key and see if it works?

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

@WFCH - Do you have any update if you manage to alter key?

Was this reply helpful? Yes No