dpempregdig
[ID]
NUMERO=9874
NOMBRE=DPEMPREGDIG
DESCRIPCION=Digitalización por Empresa
CONFIG=Y
SINGUL=Digitalización
APLICA=19
PRIMARY_KEY=”
[END_ID]
[FIELDS]
C001=RXE_CODDIG ,’C’,080,0,”,’Código Registro Digitalización’,0
C002=RXE_CODEMP ,’C’,006,0,”,’Código de Empresa’,0
C003=RXE_FECHA ,’D’,008,0,”,’Registro’,0
C004=RXE_FILMAI ,’N’,007,0,”,’Registro para Digitalización’,0
C005=RXE_HASTA ,’D’,008,0,”,’Vigencia Hasta’,0
C006=RXE_ID ,’C’,003,0,”,’ID’,0
C007=RXE_FREQUE ,’C’,010,0,”,’Frecuencia’,0
[END_FIELDS]
[TABLE_MAIN]
T001=DPEMPRESA , RXE_CODEMP=EMP_CODIGO <UPDATE> <DELETE> <RUN>
T002=DPREGDIGITALIZACION , RXE_CODDIG=RED_CODIGO <UPDATE> <DELETE> <RUN>
[END_TABLE_MAIN]
[INNER_JOIN]
SELECT * FROM DPEMPREGDIG INNER JOIN DPEMPRESA ON RXE_CODEMP=EMP_CODIGO
SELECT * FROM DPEMPREGDIG INNER JOIN DPREGDIGITALIZACION ON RXE_CODDIG=RED_CODIGO
[END_INNER_JOIN]
[OPTIONS]
[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]