0 Replies Latest reply: Apr 5, 2013 11:46 AM by Wilfer RSS

    DBFW 5.1 mode DPE, substitute client statement that contains WHERE

    Wilfer
      Hi,
      Please if anyone can help me fix this problem
      _1._ I have configured the DBFW 5.1 in DPE mode, and works correctly
      _2._ On the client side you run the following statement:
      select ff, clave from prueba_pracso where ff = 256
      _3._ ANALYZER application I use to create the substitution ruleand I note that captures the following statement:
      select ff, clave from prueba_pracso where ff = 000
      ------
      The statement ff = identified the data as 000
      ------
      _4._ I want to replace with a similar statement in the detail of the field increase you character 'clave'
      select ff, clave +|| ‘-AB’+ from prueba_pracso where ff = 000
      ------
      No matter what field approach 'ff' client chose
      ------
      Example:
      Example 1
      Client:
      select ff, clave from prueba_pracso where ff = 256
      Substitute
      select ff, clave || ‘-AB’ from prueba_pracso where ff = 256
      Example 2
      Client:
      select ff, clave from prueba_pracso where ff = 432
      Substitute
      select ff, clave || ‘-AB’ from prueba_pracso where ff = 432
      etc.