This is a migrated thread and some comments may be shown as answers.

Telerik.OpenAccess.RT.sql.SQLException: INSERT

1 Answer 129 Views
OQL (OQL specific questions)
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
shane
Top achievements
Rank 1
shane asked on 04 Mar 2010, 12:24 AM
Database relation Image


my code:

DataServices.HRMPerson p = new DataServices.HRMPerson();  
            p.PersonId = Guid.NewGuid();  
            p.Name = "shane";  
 
            HRMAffairCollection ef1 = new HRMAffairCollection();  
            ef1.AffairCollectionId = Guid.NewGuid();  
            DataServices.HRMFeature d = new DataServices.HRMFeature();  
            d.FeatureId = Guid.NewGuid();  
            d.BloodType = "b";  
            ef1.HRMFeature = d;  
            p.HRMAffairCollection = ef1;  
 
            dwcf.CreateHRMPerson(p); 

error info:
Insert of '660258325-b07df7a9-756f-4b1f-9158-c608a9c90551' failed: Telerik.OpenAccess.RT.sql.SQLException: INSERT 语句与 FOREIGN KEY 约束"FK_HRM_Feature_HRM_Person"冲突。该冲突发生于数据库"HRMTest",表"dbo.HRM_Feature", column 'FeatureId'。
语句已终止。
   在

1 Answer, 1 is accepted

Sort by
0
Jan Blessenohl
Telerik team
answered on 05 Mar 2010, 09:48 PM
Hello shane,
Can you enable logging and set it to 'all'. You can see the parameter values for the insert statement now. Are we setting wrong data?

You can enable logging the the backend configuration dialog.

Regards,
Jan Blessenohl
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
OQL (OQL specific questions)
Asked by
shane
Top achievements
Rank 1
Answers by
Jan Blessenohl
Telerik team
Share this question
or