Reportes con un filtro , apellidos TOLEDO<\/p>\n
1.a<\/p>\n
select tpersona.apellido, tpersona.nombres From tpersona Where tpersona.apellido like ‘TOLEDO’<\/strong><\/p>\n 2.a El filtro est\u00e1 como constante<\/p>\n Function rsqlpers<\/strong><\/p>\n LOCAL cSql<\/strong><\/p>\n cSql := “select tpersona.apellido, tpersona.nombres From tpersona Where tpersona.apellido like ‘TOLEDO'”<\/strong><\/p>\n RepSQL( cSql , ‘Personas con apellido TOLEDO’ )<\/strong><\/p>\n Return Nil<\/strong><\/p>\n 2.b Pidiendo el apellido a filtrar<\/p>\n Function rsqlpers<\/strong><\/p>\n LOCAL cSql , cAliasSql , cTipo := space(30)<\/strong><\/p>\n if PidoDato( @cTipo , ‘Apellido a filtrar’ , ‘Ingrese Apellido’ , ” )<\/strong><\/p>\n \u00a0 \u00a0 \u00a0 \u00a0cSql := “select tpersona.apellido, tpersona.nombres From tpersona Where tpersona.apellido like ” + “‘” + Alltrim( cTipo ) + “‘”<\/strong><\/p>\n \u00a0 \u00a0 \u00a0 RepSQL( cSql , ‘Personas con apellido ‘ + cTipo ) <\/strong><\/p>\n endif<\/strong><\/p>\n Return Nil<\/strong><\/p>\n 3.a\u00a0 Llamo a la entidad PERSONA con un filtro constante<\/p>\n Function rsqlpers<\/strong><\/p>\n LOCAL cSql , cAliasSql<\/strong><\/p>\n cSql :=”select tpersona.idc_con from tpersona Where tpersona.apellido like ‘TOLEDO'”<\/strong><\/p>\n cAliasSql := EjecutoSQL( cSql )<\/strong><\/p>\n BrwPersona<\/em>( , , cAliasSql , , ‘Personas con Apellido Toledo’ )<\/strong><\/p>\n Return Nil<\/strong><\/p>\n 3.b Llamo a la entidad PERSONA Pidiendo el apellido a filtrar<\/p>\n Function rsqlpers<\/strong><\/p>\n LOCAL cSql , cAliasSql , cTipo := space(30)<\/strong><\/p>\n if PidoDato( @cTipo ,’Apellido a filtrar’ , ‘Ingrese Apellido’ , ” )<\/strong><\/p>\n \u00a0 \u00a0cSql := “select idc_con from tpersona Where apellido like ” + “‘” + Alltrim( cTipo ) + “‘”<\/strong><\/p>\n \u00a0 \u00a0cAliasSql := EjecutoSQL( cSql )<\/strong><\/p>\n \u00a0 \u00a0BrwPersona<\/em>( , , cAliasSql , , ‘Personas con Apellido ‘ + Alltrim( cTipo ) )<\/strong><\/p>\n endif<\/strong><\/p>\n Return Nil<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" Reportes con un filtro , apellidos TOLEDO 1.a select tpersona.apellido, tpersona.nombres From tpersona Where tpersona.apellido like ‘TOLEDO’ 2.a El filtro est\u00e1 como constante Function rsqlpers LOCAL cSql cSql := “select tpersona.apellido, tpersona.nombres From tpersona Where tpersona.apellido like ‘TOLEDO’” RepSQL( cSql , ‘Personas con apellido TOLEDO’ ) Return Nil 2.b Pidiendo el apellido a filtrar Function […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":801,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-806","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/uniremunicipios.com.ar\/manual\/index.php?rest_route=\/wp\/v2\/pages\/806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/uniremunicipios.com.ar\/manual\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/uniremunicipios.com.ar\/manual\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/uniremunicipios.com.ar\/manual\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/uniremunicipios.com.ar\/manual\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=806"}],"version-history":[{"count":1,"href":"https:\/\/uniremunicipios.com.ar\/manual\/index.php?rest_route=\/wp\/v2\/pages\/806\/revisions"}],"predecessor-version":[{"id":807,"href":"https:\/\/uniremunicipios.com.ar\/manual\/index.php?rest_route=\/wp\/v2\/pages\/806\/revisions\/807"}],"up":[{"embeddable":true,"href":"https:\/\/uniremunicipios.com.ar\/manual\/index.php?rest_route=\/wp\/v2\/pages\/801"}],"wp:attachment":[{"href":"https:\/\/uniremunicipios.com.ar\/manual\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}