Para que quede un poco más claro lo que solicito pongo la DLL de mi tbla Clientes de mi programa
Código Delphi
[-]/******************************************************************************/
/* Generated by IBExpert 30/07/2011 9:20:06 */
/******************************************************************************/
/******************************************************************************/
/* Tables */
/******************************************************************************/
CREATE TABLE CLIENTES (
CODIGO CODIGO NOT NULL /* CODIGO = VARCHAR(20) NOT NULL */,
FECHA_ALTA DFECHA /* DFECHA = DATE */,
NIF_CIF DVARCHAR12NIFCIF /* DVARCHAR12NIFCIF = VARCHAR(15) */,
NOMBRE_COMERCIAL DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
DIRECCION DVCHAR50 /* DVCHAR50 = VARCHAR(50) */,
CODIGO_POSTAL DVARCHAR5 /* DVARCHAR5 = VARCHAR(5) */,
POBLACION DVARCHAR30 /* DVARCHAR30 = VARCHAR(30) */,
PROVINCIA DVARCHAR30 /* DVARCHAR30 = VARCHAR(30) */,
WEB DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
EMAIL_1 DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
EMAIL_2 DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
BANCO DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
ENTIDAD DCHAR4 /* DCHAR4 = CHAR(4) */,
OFICINA DCHAR4 /* DCHAR4 = CHAR(4) */,
DIGITO_CONTROL DCHAR2 /* DCHAR2 = CHAR(2) */,
NUMERO_CUENTA CHAR10NCC /* CHAR10NCC = CHAR(10) */,
TELEFONO_1 DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
TELEFONO_2 DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
FAX DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
MOVIL DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
PERSONA_CONTACTO DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
EMAIL_PC DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
MOVIL_PC DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
FORMA_PAGO DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
FECHAS_PAGO DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
CONFIANZA DNIVEL /* DNIVEL = CHAR(1) DEFAULT '0' NOT NULL CHECK (VALUE IN('0','1','2','3','4','5','6','7','8','9')) */,
LIMITE_CREDITO DIMPORTE /* DIMPORTE = NUMERIC(15,3) */,
PENDIENTE_PAGO DIMPORTE /* DIMPORTE = NUMERIC(15,3) */,
AVISOS DMEMO /* DMEMO = BLOB SUB_TYPE 1 SEGMENT SIZE 80 */,
OBSERVACIONES DMEMO /* DMEMO = BLOB SUB_TYPE 1 SEGMENT SIZE 80 */,
NOTAS DMEMO /* DMEMO = BLOB SUB_TYPE 1 SEGMENT SIZE 80 */,
IMAGEN DIMAGEN /* DIMAGEN = BLOB SUB_TYPE 0 SEGMENT SIZE 80 */,
RAPEL DLOGICO /* DLOGICO = CHAR(2) DEFAULT 'NO' NOT NULL CHECK (VALUE IN('SI','Si','si','NO','No','no')) */,
GRUPO DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
PAIS DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
IMPUESTOS DLOGICO /* DLOGICO = CHAR(2) DEFAULT 'NO' NOT NULL CHECK (VALUE IN('SI','Si','si','NO','No','no')) */,
REQ DLOGICO /* DLOGICO = CHAR(2) DEFAULT 'NO' NOT NULL CHECK (VALUE IN('SI','Si','si','NO','No','no')) */,
TIPO_IMP DDECIMAL /* DDECIMAL = NUMERIC(2,2) */,
DTO DDECIMAL /* DDECIMAL = NUMERIC(2,2) */,
TARIFA INTEGER,
DIAS_PRESENTACION DVARCHAR20 /* DVARCHAR20 = VARCHAR(20) */,
SECTOR DVARCHAR40 /* DVARCHAR40 = VARCHAR(40) */,
AGENTE DCLAVE /* DCLAVE = VARCHAR(20) */,
CUMP_PC DFECHA /* DFECHA = DATE */
);
/******************************************************************************/
/* Primary Keys */
/******************************************************************************/
ALTER TABLE CLIENTES ADD CONSTRAINT PK_CLIENTES PRIMARY KEY (CODIGO);
/* Fields descriptions */
COMMENT ON COLUMN CLIENTES.CONFIANZA IS
'COMFIANZA PARA CONTROL DE AVISOS Y LIMITES DE CREDITO';
/******************************************************************************/
/* Privileges */
/******************************************************************************/