Posted on 29/10/2025 13:38:35
Hi - I have the same problem.
When I try to insert a Prompt into the AiPrompt table, using this statement:
INSERT INTO AiPrompt (PromptId, PromptName, PromptDescription, PromptTaskText, PromptUseContext, PromptTemperature, PromptMaxTokens, PromptIsModification)
VALUES (2, 'Fiskeri Lang Tekst', 'Fiskeri Lang Tekst', 'Skriv en beskrivelse af produktet. Nævn hvor godt det er til fiskeri.', 0, 1.0, 200, 0);
I get this error:
Cannot insert explicit value for identity column in table 'AiPrompt' when IDENTITY_INSERT is set to OFF.
This StackOverflow answer suggest i try to turn of this protection of the Identity column.
Is this also DynamicWebs suggested solution to this problem?