dpcampos
[ID]
NUMERO=0002
NOMBRE=DPCAMPOS
DESCRIPCION=Campos de las Tablas
CONFIG=Y
SINGUL=
APLICA=20
PRIMARY_KEY=”
[END_ID]
[FIELDS]
C001=CAM_AFECTA ,’L’,001,0,”,’Afecta’,0
C002=CAM_ALTER ,’L’,001,0,”,’Alterado’,0
C003=CAM_CODADD ,’C’,006,0,”,’Código de Add-On’,0
C004=CAM_COMMAN ,’C’,080,0,”,’Comentario’,0
C005=CAM_DEC ,’N’,002,0,”,’Decimales’,0
C006=CAM_DEFAUL ,’C’,200,0,”,’Hora’,0
C007=CAM_DEFFIJ ,’L’,001,0,”,’Definición Fija’,0
C008=CAM_DESCRI ,’C’,040,0,”,’Descripciðn’,0
C009=CAM_FECHA ,’D’,008,0,”,’Fecha’,0
C010=CAM_FORMAT ,’C’,050,0,”,’Formato’,0
C011=CAM_HORA ,’C’,008,0,”,’Hora’,0
C012=CAM_LEN ,’N’,003,0,”,’Longitud’,0
C013=CAM_MILES ,’L’,001,0,”,’Logico’,0
C014=CAM_NAME ,’C’,020,0,”,’Nombre’,0
C015=CAM_NUMTAB ,’C’,004,0,”,’N+mero de tabla Asociada’,1
C016=CAM_TABLE ,’C’,024,0,”,’Nombre de la Tabla’,0
C017=CAM_TEXTCD ,’C’,030,0,”,’Texto en Consulta Dinámica’,0
C018=CAM_TYPE ,’C’,001,0,”,’Tipo de Dato’,0
C019=CAM_UPDATE ,’L’,001,0,”,’Actualiza Campos Vinculados’,0
C020=CAM_ZERO ,’L’,001,0,”,’Rellena Cero Izquierda’,0
[END_FIELDS]
[TABLE_MAIN]
T001=DPTABLAS , CAM_TABLE=TAB_NOMBRE <UPDATE> <DELETE> <RUN>
[END_TABLE_MAIN]
[TABLE_REL]
T001=DPCAMPOSOP , CAM_TABLE,CAM_NAME=OPC_TABLE,OPC_CAMPO, <UPDATE> <DELETE> <RUN>
[END_TABLE_REL
[INNER_JOIN]
SELECT * FROM DPCAMPOS INNER JOIN DPCAMPOSOP ON OPC_TABLE=CAM_TABLE AND OPC_CAMPO=CAM_NAME
SELECT * FROM DPCAMPOS INNER JOIN DPTABLAS ON CAM_TABLE=TAB_NOMBRE
[END_INNER_JOIN]
[OPTIONS]
C001=CAM_TYPE ,Caracter
C002=CAM_TYPE ,Date
C003=CAM_TYPE ,Lógico
C004=CAM_TYPE ,Numérico
[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]