Ejemplo de una vista en fox pro

Solo disponible en BuenasTareas
  • Páginas : 4 (765 palabras )
  • Descarga(s) : 0
  • Publicado : 14 de febrero de 2012
Leer documento completo
Vista previa del texto
SELECT General.no_policia, General.appat, General.apmat, General.nombre, General.rfc, Nivpol.descrip, General.cias, General.batallon, General.nue, General.fech_ing, Delega.nom_deleg,Partida.descrip, Fuente.descrip, General.sexo, General.cuip, edad(General.fech_ing), Escolar.descrip, General.curp, General.imss, edad(General.fech_nac), General.fech_nac, General.exmilitar
FROMarchivo!general INNER JOIN catals!nivpol ON General.nivel = Nivpol.clave INNER JOIN catals!escolar ON General.esco = Escolar.clave INNER JOIN dgspe!partida ON General.deleg = Partida.delega ANDGeneral.partida = Partida.partid INNER JOIN dgspe!delega ON Partida.delega = Delega.cve_deleg INNER JOIN catals!fuente ON General.fuente = Fuente.fuente WHERE ORDER BY General.appat,General.apmat, General.nombre

DBSetProp(ThisView,"View","SeGeneral.vacante = ( .F. ) AND ALLTRIM(General.fuente)$opcion = ( .T. ) ndUpdates",.F.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)DBSetProp(ThisView,"View","Tables","archivo!general,catals!nivpol,dgspe!delega,dgspe!partida,catals!fuente,catals!escolar")
DBSetProp(ThisView,"View","WhereType",3)

DBSetProp(ThisView+".no_policia","Field","DataType","N(4)")DBSetProp(ThisView+".no_policia","Field","UpdateName","archivo!general.no_policia")
DBSetProp(ThisView+".no_policia","Field","KeyField",.F.)
DBSetProp(ThisView+".no_policia","Field","Updatable",.T.)DBSetProp(ThisView+".appat","Field","DataType","C(20)")
DBSetProp(ThisView+".appat","Field","UpdateName","archivo!general.appat")
DBSetProp(ThisView+".appat","Field","KeyField",.F.)...
tracking img