1 2 3
| pb avec le send : [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Il y a moins de colonnes dans l'instruction INSERT que de valeurs spécifiées dans la clause VALUES. Le nombre de valeurs de la clause VALUES doit être le même que le nombre de colonnes de l'instruction INSERT.
INSERT SIRILOG_Acte2 ( AMC, ActeEnRapportALD, ActeFaitParRemplacant, ActeGratuit, Action_Prevention, Adressefacturation, Anesthesie, Anesthesiste, Appareil, CAC_Demandeur, Certification, Chambre, CleAccident, CliComment, Clot, Comptabilite, CompteRendu, CompteurAppareil2, Compteurappareil1, Couttotal, Date, DateAccident, DateCliche, DateMaternite, Date_Transmission, Debiteur_FT, Diagnostic, Equipe, ExamenDimanche, Examendenuit, Examenhorssalle, Examenurgent, FS_Impression, FT_Impression, FacturationCCAM, Facturation_FT, Fraisrappel, FraisrappelAMC, FraisrappelAMO, FraisrappelFBloc, FraisrappelFT, Heureentree, Heuresortie, Identification_Prescripteur, Indication, Injection, Interetscientifique, Interne, Issueexamen, KSup50, Libelle, Majoration_Coordination, Majoration_Dimanche, Majoration_Nuit, Manipulateur, Materielfacture, Materiel_Analytique, Modedereglement, Monnaie, MontantAMC, MontantAMO, MontantPatient, Montantfacture, Montant_FBloc, Montant_FT, Montant_MajoCoordination, NatureJustificatif, NumAVS, NumAccident, NumEntreprise, NumImmatriculation, Numerodossier, Numeroexamen, Numerosejour, Numero_Bordereau, Numero_Bordereau_AMC, Numero_Bordereau_FBloc, Numero_Bordereau_FT, Numero_FSE, Numero_facture, Numero_lot, Operateur, OrigineJustificatif, Parcours_Soin, Premedication, Prescripteur, PriseEnCharge, Prise_En_Charge, Private, Protocole, Relance1AMC, Relance1AMO, Relance1FBloc, Relance1FT, Relance1Patient, Relance2AMC, Relance2AMO, Relance2FBloc, Relance2FT, Relance2Patient, Relance3AMC, Relance3AMO, Relance3FBloc, Relance3FT, Relance3Patient, RelanceRealisee1AMC, RelanceRealisee1AMO, RelanceRealisee1FBloc, RelanceRealisee1FT, RelanceRealisee1Patient, RelanceRealisee2AMC, RelanceRealisee2AMO, RelanceRealisee2FBloc, RelanceRealisee2FT, RelanceRealisee2Patient, RelanceRealisee3AMC, RelanceRealisee3AMO, RelanceRealisee3FBloc, RelanceRealisee3FT, RelanceRealisee3Patient, Remarques, Risque, STM, Salle, Seance, SerieNouveauNe, SirNxSynchro, Solde, SoldeAMC, SoldeAMO, SoldePatient, Solde_FBloc, Solde_FT, Stamp_Transmission, Stamp_Transmission_Mat, Statut, T2A, T2A_Version, TextePied, Texteentete, TopMutualiste, TraitementExonerant, Transmis, Transmis2, TypeHonoraire, Typeexamen, TypeAnesthesie, Unitedemandeur, Uniteexecutante, Vacation, ValJF_Forfait, ValJF_Pourcentage, ValNuit_Forfait, ValNuit_Pourcentage, Valeurencaissement, ValiditeJustificatif, examenscompinduits, examensdesubstitution, examensprealables, xEtatB2, xFrais_plan_paiement, xPP_1_versement_date, xPP_Montant_versement, xPP_Nb_Versement, xPP_echelonnement, xstamp ) VALUES ('0','Faux','Faux','Faux','Faux',null, 'Faux',null, '4',null, '0','URGE',null, null, 'Vrai','00/00/00','Faux','0','0','0','15/06/07','00/00/00','00/00/00','00/00/00','00/00/00','0','0',null, 'Faux','Faux','Faux','Vrai','Faux','Faux','Vrai','Faux','0','0','0','0','0','16:50:12','16:50:59',null, '0','Faux','Faux',null, '-1','Faux','Panoramique dentomaxillaire',null, '0','0','DUBOEUF Béatrice','0',null, '1','1','0','0','34,02','34,02','0','0','0','0',null, null, null, null, '77021','318013','070383163','0','0','0','0','0','0','0',null, null, 'MTO','Faux','0',null, 'Faux','Faux','0','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00',null, '0','Faux','3','0','Faux','0','34,02','0','0','34,02','0','0','0','0','1','Vrai','2',null, null, '0','Faux','Vrai','Vrai','0','0','0','2342','9322','1','0','0','0','0','0','00/00/00','Faux','Faux','Faux','0','0','00/00/00','0','0','0','550774284' ,
'0','Faux','Faux','Faux','Faux',null, 'Faux',null, '3',null, '0','URGA',null, null, 'Vrai','00/00/00','Faux','0','0','0','15/06/07','00/00/00','00/00/00','00/00/00','00/00/00','0','0',' ','Faux','Faux','Faux','Vrai','Faux','Faux','Vrai','Faux','0','0','0','0','0','16:16:39','16:19:22',null, '0','Faux','Faux',null, '-1','Faux','Main ou doigt',null, '0','0','DUBOEUF Béatrice','0',null, '1','1','0','0','32,4','32,4','0','0','0','0',null, null, null, null, '77020','318007','070383017','0','0','0','0','0','0','0','M. DENNAWI',null, 'MTO','Faux','0',null, 'Faux','Faux','0','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00','00/00/00',null, '0','Faux','21','0','Faux','0','32,4','0','0','32,4','0','0','0','0','1','Vrai','2',null, null, '0','Faux','Vrai','Vrai','0','0','0','2341','9390','1','0','0','0','0','0','00/00/00','Faux','Faux','Faux','0','0','00/00/00','0','0','0','550772386' ,) |
Partager