Línguagem 4D Commands by theme QueriesVersão: 21 R3QueriesDESCRIBE 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< : Comparator})} {; *} ) ORDER BY FORMULA ( aTable : Table ; formula : Expression {;>,<} {; ...(formula : Expression {;>,<})} ) QUERY ( {tabela : Table }{;}{ criterioPesquisa : Expression {; *}} ) QUERY BY ATTRIBUTE ( {umaTabela}{;}{opConj : Operator ;} campoObjeto : Field ; caminhoAtributo : Text ; opPesq : Text, Operator ; valor : Text, Real, Date, Time {; *} ) QUERY BY EXAMPLE ( {tabela : Table}{;}{*} ) QUERY BY FORMULA ( tabela : Table {; formula : Boolean} ) QUERY SELECTION ( {tabela : Table }{;}{ criterioPesquisa : Expression {; *}} ) QUERY SELECTION BY ATTRIBUTE ( {umaTabela}{;}{operadorConj : Operator ;} campoObj : Field ; rotaAtributo : Text ; operadorPesq : Text, Operator ; valor : Text, Real, Date, Time {; *} ) QUERY SELECTION BY FORMULA ( tabela : Table {; formula : Boolean} ) 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}} ) SET QUERY LIMIT ( limite : Integer )