dpbancosper
[ID]
NUMERO=9549
NOMBRE=DPBANCOSPER
DESCRIPCION=Personal del Banco
CONFIG=F
SINGUL=Persona del Banco
APLICA=01
PRIMARY_KEY=”
[END_ID]
[FIELDS]
C001=PDC_ACTIVO ,’L’,001,0,”,’Activo’,0
C002=PDC_CARGO ,’C’,035,0,”,”,0
C003=PDC_CELULA ,’C’,012,0,”,”,0
C004=PDC_CI ,’C’,011,0,”,”,0
C005=PDC_CLAVE ,’C’,020,0,”,”,0
C006=PDC_CODIGO ,’C’,010,0,”,”,0
C007=PDC_COMENT ,’C’,040,0,”,”,0
C008=PDC_EMAIL ,’C’,070,0,”,”,0
C009=PDC_EXTENS ,’C’,004,0,”,”,0
C010=PDC_LOGIN ,’C’,020,0,”,”,0
C011=PDC_MEMO ,’N’,019,0,”,”,0
C012=PDC_PERSON ,’C’,040,0,”,”,0
C013=PDC_PIN ,’C’,008,0,”,”,0
C014=PDC_TELEFO ,’C’,012,0,”,”,0
C015=PDC_TIPO ,’C’,010,0,”,”,0
[END_FIELDS]
[TABLE_MAIN]
T001=DPBANCOS , PDC_CODIGO=BAN_CODIGO <UPDATE> <DELETE> <RUN>
[END_TABLE_MAIN]
[INNER_JOIN]
SELECT * FROM DPBANCOSPER INNER JOIN DPBANCOS ON PDC_CODIGO=BAN_CODIGO
[END_INNER_JOIN]
[OPTIONS]
C001=PDC_TIPO ,Externo
C002=PDC_TIPO ,Trabajador
[END_OPTIONS]
[COMENTARIOS]
C: CHAR
D: DATE
L: LOGICAL 1=T 0=F
N: NUMERICO
M: MEMO
[SQL]
SELECT <CAMPOS> FROM <TABLA>
INNER JOIN XTABLA ON XCAMPO=YCAMPO
[ENDSQL]