Ejemplo de una vista en fox pro
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.)...
Regístrate para leer el documento completo.