Iniciar sesión
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Dynamic number of parameters for FilterClause

Odpowiedz Dynamic number of parameters for FilterClause

  • lunes, 09 de agosto de 2010 8:16
     
      Tiene código
    Inicie sesión para votar
    0

    Hi again,

    while digging deeper into my scenario i came across the problem of defining a SyncTable description with a set of multiple parameters. As far as i understood the docs this is not possible with the current CTP - but it would be a very handy feature.

    Having a hard time to express what i mean i just give you an example:

    SELECT * FROM MyTable WHERE MyColumn IN (4, 8, 15, 16, 23, 42)

    <SyncTable Name="MyTable" FilterClause="[side].MyColumn IN (@MyFilterArray)">

     

     

Todas las respuestas

  • lunes, 09 de agosto de 2010 18:32
    Moderador
     
     
    Inicie sesión para votar
    0

    What would be the SqlType of MyFilterArray? I dont think TSQL lets you specify an array. If your array length is always fixed then you can probably do the following

    FilterClause="[side].MyColumn IN (@p1, @p2, @p3)"

     

    Maheshwar Jayaraman - http://blogs.msdn.com/mahjayar
     
  • martes, 10 de agosto de 2010 7:27
     
     
    Inicie sesión para votar
    0

    Well, yes, of course you are right. I just wanted to give a simple example of what i would like to achieve - somehow. As the topic says i am looking for a dynamic number of parameters. All i can think of is some kind of hackish workarrounds, e.g. defined a fixed list of parameters and fill them with placeholder values in case they are not all needed.

    I was wondering if someone else comes up with a briliant idea?

     
  • martes, 10 de agosto de 2010 20:26
    Moderador
     
     Respondida
    Inicie sesión para votar
    0
    Not really as this is a property of the underlying SqlSyncProvider the service uses. The thing with dynamic filter values is that the provider still expects them to be same across sync sessions as it does not guarantee partition realignments if they change between sync calls. Hope that helps.
    Maheshwar Jayaraman - http://blogs.msdn.com/mahjayar
    • Marcado como respuesta M.Bi miércoles, 11 de agosto de 2010 6:55
    •