Hi,
we have a new entity (new_entity), weher we need to insert data to. Because it is much data, we want to do it via SQL. Therefore I´ve written a script, but I don´t get the right AccountID. I only get the error
error: The INSERT statement conflicted with the FOREIGN KEY constraint "new_entity_new_account". The conflict occurred in database "DBName", table "dbo.AccountBase", column 'AccountId'.
how can I get the accountID?
BEGIN
DECLARE @ListMemberId uniqueidentifier
DECLARE @CLASSID uniqueidentifier
DECLARE NewEntity_CUR CURSOR FOR
SELECT [ListMemberId]
FROM [ListMemberBase] WHERE [ListId] = (SELECT [ListId] FROM [ListBase] WHERE ListName='myTestList')
OPEN NewEntity_CUR
FETCH NEXT FROM NewEntity_CUR INTO @ListMemberId
-- loop over the cursor NewEntity_CUR
WHILE @@FETCH_STATUS = 0
BEGIN
SET @CLASSID = NEWID()
INSERT INTO [New_entityBase] ([New_entityId]) VALUES(@CLASSID)
INSERT INTO [New_entityExtensionBase] ([New_entityId],[New_Path],[New_AccountId]) VALUES(@CLASSID,'whatever',@ListMemberId)
-- error: The INSERT statement conflicted with the FOREIGN KEY constraint "new_entity_new_account". The conflict occurred in database "DBName", table "dbo.AccountBase", column 'AccountId'.
FETCH NEXT FROM NewEntity_CUR INTO @ListMemberId
END
-- close cursor
CLOSE CLASSIFICATION_CUR
DEALLOCATE CLASSIFICATION_CUR
END
THX
