Page 3 of 3 FirstFirst 123
Results 21 to 22 of 22

Thread: OnConstrain on Web

  1. #21
    Join Date
    Jul 2014
    Posts
    206

    Default Re: OnConstrain on Web

    hi Edgar, i have written some webprompt with sqlfilters, some time it work some time no, i guess it is because the db complexity, i'll share some code that works well ok.

    Code:
        Object oBANCO_DD is a cBANCOWsDataDictionary
            Set pbUseDDSQLFilters to True
            
            Procedure OnConstrain
                Integer iRegistros
                String  sValor sSql
                Forward Send OnConstrain
                
                If (IsLoggedIn(ghoWebSessionManager)) Begin
                    WebGet psValue of oComboAtivo to iRegistros
                    WebGet psValue of oFormConsulta to sValor
                    If (iRegistros <> 2) Append sSql "BANCO.ATIVO=" (String(iRegistros))
                    If (sValor <> "") Begin
                        Append sSql (If(sSql<>""," AND ",""))
                        Append sSql " BANCO.DESCRICAO LIKE '%" sValor "%'"
                    End
                    Set psSQLFilter to sSql
                End
            End_Procedure
        End_Object
    and the list, is just a normal entry_item type:

    Code:
            Object oPromptList is a cWebPromptlistPrompt
                
                Object oBANCODESCRICAO is a cWebColumn
                    Entry_Item BANCO.DESCRICAO
                    Set psCaption to "Descrição"
                    Set piWidth to 400
                End_Object 
    
    
                Object oBANCOCODIGO is a cWebColumn
                    Entry_Item BANCO.CODIGO
                    Set psCaption to "Código"
                    Set piWidth to 152
                End_Object  
                
                 Object oSingleBtnCol is a cWebColumnButton
                    Set piWidth to 50
                End_Object  
            End_Object
    notes:
    Code:
    Forward Send OnConstrain
    i forward send onContrain because on my main datadictionary i'm filtering my tenancy

    Code:
     If (IsLoggedIn(ghoWebSessionManager)) Begin
    when i use a web property (process pooling), i always check if my user is already logged in, to be sure thats webproperty system is ready, and to avoid filtering the data in a initializing state and loss app performance.


    so in resume, SqlFilter works well, but you need to figure out what are you doing that make it not work for you.

  2. #22
    Join Date
    Feb 2009
    Location
    Colombia
    Posts
    2,508

    Default Re: OnConstrain on Web

    Hi Salvadori:


    Just adding Forward Send OnConstrain
    it worked perfectly.

    thanks to everyone

    Edgar

Page 3 of 3 FirstFirst 123

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •