Línguagem 4D Commands by theme QueriesVersão: 21 R4 BETAQueriesDESCRIBE QUERY EXECUTION ( estado : Boolean ) Find in field ( campoAlvo : Field ; valor : Field, Variable ) : Integer GET QUERY DESTINATION ( destinoTipo : Integer ; destinoObjeto : Text ; destinoPont : Pointer ) Get query limit : Integer Last query path ( formatDescr : Integer ) : Text Last query plan ( formatDescr : Integer ) : Text ORDER BY ( {aTable : Table ;}{; ...(aField : Field {; > or <}) } {; *} ) ORDER BY ATTRIBUTE ( {aTable : Table ;} {; ...(objectField : Field ; attributePath : Text {; >or< :>, <})} {; *} ) *ORDER BY FORMULA ( aTable : Table ; { ...(formula : Expression {; formula :>, <})} ) QUERY ( {tabela : Table }{;}{ criterioPesquisa : Expression {; *}} ) QUERY BY ATTRIBUTE ( {umaTabela : Table ;}{opConj : &, |, # ;} campoObjeto : Field ; caminhoAtributo : Text ; opPesq : Text,>, <,>=, <=, #, =, |, % ; valor : Text, Real, Date, Time {; *} ) QUERY BY EXAMPLE ( {tabela : Table}{;}{*} ) QUERY BY FORMULA ( tabela : Table {; formula : Expression} ) QUERY SELECTION ( {tabela : Table }{;}{ criterioPesquisa : Expression {; *}} ) QUERY SELECTION BY ATTRIBUTE ( {umaTabela : Table ;}{operadorConj : &, |, # ;} campoObj : Field ; rotaAtributo : Text ; operadorPesq : Text,>, <,>=, <=, #, =, |, % ; valor : Text, Real, Date, Time {; *} ) QUERY SELECTION BY FORMULA ( tabela : Table {; formula : Expression} ) QUERY SELECTION WITH ARRAY ( campoAlvo : Field ; array : Array ) QUERY WITH ARRAY ( campoAlvo : Field ; array : Array ) SET QUERY AND LOCK ( bloq : Boolean ) SET QUERY DESTINATION ( tipoDestino : Integer {; objetoDestino : Text, Variable {; destPonteiro : Pointer}} ) SET QUERY LIMIT ( limite : Integer )