0 Replies Latest reply: May 13, 2011 10:30 AM by roldancito RSS

    well , if I got this context and I want introduce dynamic parameter

      well , if I got this context and I want introduce dynamic parameter

       

       

       

      SQL

      select

       

      I mean something  to can I introduce since graphic object

       

       

      distinct

       

      like a button or something to keep the value from the selection

       

      for example

      I got my query

      select *from V_detalleImportesNivelArt

      and I looking for something like this

      Select *from V_detalleImportesNivelArt where art=@var1art=@var1

       

      but @var1 is a dynamic value something to can introduce since a grphic obgect

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      from

       

      V_detalleImportesNivelArt

      v

      where

       

      movCte not

      like'canc%'

      order

       

      by

      fechacte

      ;

       

      v.*

      from

      V_detalleImportesNivelArt

      v

      where

       

      movCte not

      like'canc%'

      order

      by

      fechacte

      ;