Otis wrote:
Could you please check what the generated relations are and paste them here in the routine BuildRelationSet() ?
Also, which designer version are you using? (please state the date in the about box).
Not sure if the ResultSet matters, so I'm throwing it in as well:
private void BuildRelationSet()
{
_filterBucket.Relations.ObeyWeakRelations = base.ObeyWeakRelations;
_filterBucket.Relations.Add(MemberEntity.Relations.TaskMemberEntityUsingMemberID, "", "", JoinHint.None);
_filterBucket.Relations.Add(TaskEntity.Relations.TaskTypeEntityUsingTaskTypeID, "", "", JoinHint.None);
_filterBucket.Relations.Add(TaskEntity.Relations.TaskMemberEntityUsingTaskID, "", "", JoinHint.None);
}
private void BuildResultset()
{
_fields = new ResultsetFields(AmountOfFields);
_fields.DefineField(TaskMemberFieldIndex.MemberID, 0, "MemberID", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.TaskID, 1, "TaskID", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.ParentTaskID, 2, "ParentTaskID", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.Title, 3, "Title", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.IsReminder, 4, "IsReminder", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.IsRecurring, 5, "IsRecurring", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.Location, 6, "Location", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.Priority, 7, "Priority", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.Notes, 8, "Notes", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.Duration, 9, "Duration", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.Visibility, 10, "Visibility", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.ShowTimeAs, 11, "ShowTimeAs", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.Url, 12, "Url", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.PercentComplete, 13, "PercentComplete", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.DueDate, 14, "DueDate", "", AggregateFunction.None);
_fields.DefineField(TaskTypeFieldIndex.Description, 15, "TaskType", "", AggregateFunction.None);
_fields.DefineField(MemberFieldIndex.DisplayName, 16, "MemberDisplayName", "", AggregateFunction.None);
_fields.DefineField(TaskFieldIndex.StatusID, 17, "StatusID", "", AggregateFunction.None);
}
Designer version is 1.0.2004.2 Final (released May 26th, 2005). Thanks in advance for any thoughts you may have.