My Question to you all is GUID parameter is not syncing.

• Question

• 

  

  0

  Sign in to vote

  Hi All,

  I have 3 parameters one of them is GUID and i have OR Conditions. When i pass guid it is not syncing back to other user.

  Basically i have 3 level of approval process when any of the approver change status it has to sync back to central and every one local db.

  Please see below of the my sample code. Please advise if miss any thing. Thank you.

  serverTemplate.Tables[

  "Table1"].AddFilterColumn("ID"

  );

  serverTemplate.Tables[

  "Table1"].AddFilterColumn("Reviewer"

  );

  serverTemplate.Tables[

  "Table1"].AddFilterColumn("ReportedBy"

  );

  serverTemplate.Tables[

  "Table1"].FilterClause = "[side].[ID] = @Seq OR [side].[Reviewer] = @Reviewer OR [side].[ReportedBy] = @Author"

  ;

   

  SqlParameter param = new SqlParameter("@Reviewer", SqlDbType

  .NVarChar, 100);

   

  SqlParameter param1 = new SqlParameter("@Author", SqlDbType

  .NVarChar, 100);

   

  SqlParameter param2 = new SqlParameter("@Seq", SqlDbType

  .UniqueIdentifier);

  serverTemplate.Tables[

  "Table1"

  ].FilterParameters.Add(param);

  serverTemplate.Tables[

  "Table1"

  ].FilterParameters.Add(param1);

  serverTemplate.Tables[

  "Table1"

  ].FilterParameters.Add(param2);

  serverProvParam.Tables[

  "Table1"].FilterParameters["@Reviewer"

  ].Value = reviewer;

  serverProvParam.Tables[

  "Table1"].FilterParameters["@Author"

  ].Value = author;

  serverProvParam.Tables[

  "Table1"].FilterParameters["@Seq"].Value = new Guid("4b3f8047-de05-4c6d-ad05-8c261cb9c9de");

  // Seq;

   

  Sync Framework Developer forums

  ---

  sample

  Monday, November 7, 2011 2:10 PM