locked
My Question to you all is GUID parameter is not syncing. RRS feed

  • Question

  • 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

All replies

  • do you have other scopes or templates defined on the same table?

    is it synching if you only have two parameters and without the uniqueidentifier parameter?

    can you run a SQL Profiler and look at the query being sent to SQL Server, run it yourself and see if it returns rows.

    Tuesday, November 8, 2011 2:46 AM