WHERE clause of a block

Dicas do Oracle Forms Builder - Blocos, Itens, LOV, Canvas, Triggers, comandos, PLL, d2kwutil, FMB, Alert, menus, etc

Poston Mon, 01 Aug 2011 7:38 pm

If I put in the clause WHERE a block, for example: field =: item_form and this item has not been writing anything on it. What is the behavior of the form? He ignores the condition, or WHERE field = ' '?
Location: Rio de Janeiro - RJ

Poston Mon, 01 Aug 2011 8:44 pm

Will be false, see these links: viewtopic.php?t=2012 viewtopic.php?p=343 http://glufke.net/2007/09/06/comparacao ... m-null/you should do this:
Code: Select all
WHERE ( :item_form  IS NULL OR campo = :item_form  )
Thus, if the ITEM is null, it will bring everything. If you have filled in, it will filter for this field.

Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?

  • See also
    Last Post

      Return to Forms

      Who is online

      Users browsing this forum: Bing [Bot] and 5 guests