Ver Mensaje Individual
  #9 (permalink)  
Antiguo 26/05/2009, 01:48
nervio
 
Fecha de Ingreso: abril-2009
Mensajes: 106
Antigüedad: 15 años, 1 mes
Puntos: 1
Respuesta: mysql dbf y php

ahi lo llevas y gracias eh.

INSERT INTO clientes
(CODIGO, NOMBRE, DIRECCION, POBLACION, CP_PROV, CIF, TEL_FAX, CTA_CTE, NOMBRE2, DIRECCION2, POBLACION2, CP_PROV2, TEL_FAX2, E_MAIL, INICIO, FIN, ESTADO, DESPLAZA, CUOTA, IMPORTE1, IMPORTE2, IMPORTE3, IMPORTE4, HORARIO, AVERIAS, TIPO_CON1, TIPO_CON2, TIPO_CON3, TIPO_CON4, TIPO_CON5, SOFT1, SOFT2, SOFT3, SOFT4, SOFT5, SOFT6, SOFT7, SOFT8, SOFT9, SOFT10, SOFT11, SOFT12, SOFT13, SOFT14, SOFT15, SOFT16, SOFT_OBS, HARD1, HARD2, HARD3, HARD4, HARD5, HARD6, HARD7, HARD8, HARD9, HARD10, HARD11, HARD12, HARD_OBS, ACC1, ACC2, ACC3, ACC4, ACC5, ACC6, ACC7, ACC8, ACC9, ACC10, ACC11, ACC12, ACC15, ACC16, ACCESO_OBS, SOFT20)
VALUES
(1, "NICOSAL", "URB. EL CAPISTRANO", "NERJA", "29780 MALAGA", "B-29383950", "952523882 / 952524337", "------------------------------", "NICASOL", "", "", "", "", "", "1/4/1999", "30/12/1899", 0, 2, 1, 150, 0, 0, 0, 2, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "GESTION DE RESERVAS FOXPRO 2.5", 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "TODO EL HARDWARE ES NUESTRO
", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", "NO HAY ACCESO REMOTO ", 0);

INSERT INTO clientes
(CODIGO, NOMBRE, DIRECCION, POBLACION, CP_PROV, CIF, TEL_FAX, CTA_CTE, NOMBRE2, DIRECCION2, POBLACION2, CP_PROV2, TEL_FAX2, E_MAIL, INICIO, FIN, ESTADO, DESPLAZA, CUOTA, IMPORTE1, IMPORTE2, IMPORTE3, IMPORTE4, HORARIO, AVERIAS, TIPO_CON1, TIPO_CON2, TIPO_CON3, TIPO_CON4, TIPO_CON5, SOFT1, SOFT2, SOFT3, SOFT4, SOFT5, SOFT6, SOFT7, SOFT8, SOFT9, SOFT10, SOFT11, SOFT12, SOFT13, SOFT14, SOFT15, SOFT16, SOFT_OBS, HARD1, HARD2, HARD3, HARD4, HARD5, HARD6, HARD7, HARD8, HARD9, HARD10, HARD11, HARD12, HARD_OBS, ACC1, ACC2, ACC3, ACC4, ACC5, ACC6, ACC7, ACC8, ACC9, ACC10, ACC11, ACC12, ACC15, ACC16, ACCESO_OBS, SOFT20)
VALUES
(2, "NERJAFRUT", "C/ RAMBLA DEL RIO CHILLAR, 5", "NERJA", "29780 MALAGA", "B-29.661.171", "952526114", "----------------------------------------", "NERJAFRUT", "", "", "", "", "", "1/4/1999", "31/12/2001", 1, 0, 4, 0, 0, 0, 396.72, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", "", 0);

INSERT INTO clientes
(CODIGO, NOMBRE, DIRECCION, POBLACION, CP_PROV, CIF, TEL_FAX, CTA_CTE, NOMBRE2, DIRECCION2, POBLACION2, CP_PROV2, TEL_FAX2, E_MAIL, INICIO, FIN, ESTADO, DESPLAZA, CUOTA, IMPORTE1, IMPORTE2, IMPORTE3, IMPORTE4, HORARIO, AVERIAS, TIPO_CON1, TIPO_CON2, TIPO_CON3, TIPO_CON4, TIPO_CON5, SOFT1, SOFT2, SOFT3, SOFT4, SOFT5, SOFT6, SOFT7, SOFT8, SOFT9, SOFT10, SOFT11, SOFT12, SOFT13, SOFT14, SOFT15, SOFT16, SOFT_OBS, HARD1, HARD2, HARD3, HARD4, HARD5, HARD6, HARD7, HARD8, HARD9, HARD10, HARD11, HARD12, HARD_OBS, ACC1, ACC2, ACC3, ACC4, ACC5, ACC6, ACC7, ACC8, ACC9, ACC10, ACC11, ACC12, ACC15, ACC16, ACCESO_OBS, SOFT20)
VALUES
(3, "JOAQUIN", "POLIGONO CASTILLO ALTO", "NERJA", "29780 MALAGA", "23.889.979-T", "952520178/952520178", "----------------------------------------", "CLIMA POOL", "", "", "", "", "", "1/4/1999", "31/12/2005", 1, 0, 4, 0, 0, 0, 261, 2, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", "", 0);

INSERT INTO clientes
(CODIGO, NOMBRE, DIRECCION, POBLACION, CP_PROV, CIF, TEL_FAX, CTA_CTE, NOMBRE2, DIRECCION2, POBLACION2, CP_PROV2, TEL_FAX2, E_MAIL, INICIO, FIN, ESTADO, DESPLAZA, CUOTA, IMPORTE1, IMPORTE2, IMPORTE3, IMPORTE4, HORARIO, AVERIAS, TIPO_CON1, TIPO_CON2, TIPO_CON3, TIPO_CON4, TIPO_CON5, SOFT1, SOFT2, SOFT3, SOFT4, SOFT5, SOFT6, SOFT7, SOFT8, SOFT9, SOFT10, SOFT11, SOFT12, SOFT13, SOFT14, SOFT15, SOFT16, SOFT_OBS, HARD1, HARD2, HARD3, HARD4, HARD5, HARD6, HARD7, HARD8, HARD9, HARD10, HARD11, HARD12, HARD_OBS, ACC1, ACC2, ACC3, ACC4, ACC5, ACC6, ACC7, ACC8, ACC9, ACC10, ACC11, ACC12, ACC15, ACC16, ACCESO_OBS, SOFT20)
VALUES
(4, "MANUEL", "PLAYA BURRIANA", "NERJA", "29780 MALAGA", "74.812.893-Q", "952525470", "----------------------------------------", "MERENDERO MORENO", "", "", "", "", "", "1/4/1999", "31/12/2002", 1, 0, 4, 0, 0, 0, 360.6, 2, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", "", 0);

INSERT INTO clientes
(CODIGO, NOMBRE, DIRECCION, POBLACION, CP_PROV, CIF, TEL_FAX, CTA_CTE, NOMBRE2, DIRECCION2, POBLACION2, CP_PROV2, TEL_FAX2, E_MAIL, INICIO, FIN, ESTADO, DESPLAZA, CUOTA, IMPORTE1, IMPORTE2, IMPORTE3, IMPORTE4, HORARIO, AVERIAS, TIPO_CON1, TIPO_CON2, TIPO_CON3, TIPO_CON4, TIPO_CON5, SOFT1, SOFT2, SOFT3, SOFT4, SOFT5, SOFT6, SOFT7, SOFT8, SOFT9, SOFT10, SOFT11, SOFT12, SOFT13, SOFT14, SOFT15, SOFT16, SOFT_OBS, HARD1, HARD2, HARD3, HARD4, HARD5, HARD6, HARD7, HARD8, HARD9, HARD10, HARD11, HARD12, HARD_OBS, ACC1, ACC2, ACC3, ACC4, ACC5, ACC6, ACC7, ACC8, ACC9, ACC10, ACC11, ACC12, ACC15, ACC16, ACCESO_OBS, SOFT20)
VALUES
(5, "EUROPE S.A.", "PASEO BALCON", "NERJA", "29780 MALAGA", "A-29.004.097", "952520802", "", "HOTEL BALCON DE EUROPA Y ECONOMATO", "", "", "", "", "", "1/4/1999", "30/12/1899", 1, 2, 1, 140, 0, 0, 360.6, 1, 2, 1, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "SOFTWARE GESTION ECONOMATO
", 1, 1, 0, 1, 0, 0, 0, 1, 0, 0, 1, 0, "", 1, 0, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, "\\CENTRAL3\C", "952527227", "", 0);

INSERT INTO clientes
(CODIGO, NOMBRE, DIRECCION, POBLACION, CP_PROV, CIF, TEL_FAX, CTA_CTE, NOMBRE2, DIRECCION2, POBLACION2, CP_PROV2, TEL_FAX2, E_MAIL, INICIO, FIN, ESTADO, DESPLAZA, CUOTA, IMPORTE1, IMPORTE2, IMPORTE3, IMPORTE4, HORARIO, AVERIAS, TIPO_CON1, TIPO_CON2, TIPO_CON3, TIPO_CON4, TIPO_CON5, SOFT1, SOFT2, SOFT3, SOFT4, SOFT5, SOFT6, SOFT7, SOFT8, SOFT9, SOFT10, SOFT11, SOFT12, SOFT13, SOFT14, SOFT15, SOFT16, SOFT_OBS, HARD1, HARD2, HARD3, HARD4, HARD5, HARD6, HARD7, HARD8, HARD9, HARD10, HARD11, HARD12, HARD_OBS, ACC1, ACC2, ACC3, ACC4, ACC5, ACC6, ACC7, ACC8, ACC9, ACC10, ACC11, ACC12, ACC15, ACC16, ACCESO_OBS, SOFT20)
VALUES
(6, "ICASA S.A.", "C/ DEL CARMEN", "NERJA", "29780 MALAGA", "A-43.133.771", "952520385 / 952522504", "----------------------------------", "ICASA S.A.", "", "", "", "", "", "1/4/1999", "31/12/2006", 1, 0, 4, 0, 0, 0, 480, 2, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", "", 0);