Post reply

row filter

  • January 12, 2005 at 8:28 pm

    #87781

    hi

          i got a strange problem , firstly i only select one order table which has startdate and enddate fields as publiction article, then i did row filter based on date.

          after i run this publication and subscription . the data of order been transfer to subscripter, but the  problem is it should has five records after filter, in fact it only transfer 3 records. 

            i test my filter query by query analyzer , it does select 5 records in order table by the date filter query.

     

          so any idea about this strange problem

  • January 17, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • January 17, 2005 at 2:13 pm

    #537727

    Are you generating a snapshot to sincronize data? You can open the snapshot.cab file (with expand.exe) and open the .bcp file of the table, and check how many records are in the file.

    Also check the stored procedures to replicate data (sp_HelpArticle [ArticleName]) will tell you the names of the sp. Run sp_Helptext so see the context, and check that there is no aditional filter.

    Also check in the subscriber for any trigger that may be filtering the data.

     

  • January 17, 2005 at 2:58 pm

    #537741

    Thanks very much.

    i will do what you said .

     

    see any mistakes i made.

     

    Cheers

    nick

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply