General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Table Relation error
Our code was working and now all of a sudden we get an error: "Target table is already engaged in a relation". Below is the code line where we get the message: (it is marked with a ">")
SELECT Skill_position_courses
SET FILTER TO ISNULL(Initials).OR.Initials=Person
>SET RELATION TO Skill_position_courses.skill_code INTO Skills_log ADDITIVE
SET RELATION TO Skill_position_courses.what INTO Document_title ADDITIVE
I tried putting SET RELATION OFF INTO Skills_log and also to Skill_Position_Courses.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only