Menu

#1 syntax error in MySQL_Compta_General.sql file

open-fixed
nobody
None
5
2004-12-24
2004-11-25
Marc Siramy
No

I have just been to test ' OpenSI Serveur 1.0RC4 '. I
think there is an error in
tomcat/webapps/OpenSI/database/MySQL_Compta_General.sql
file at line 186 col 43 : we should be not put a ',' here.
I think this is the correct code :
create table REGLES_BANQUE (
Login varchar(15) not null, #
Identifiant utilisateur
Dossier_Id varchar(8) not null, #
Identifiant dossier
Libelle varchar(100),
Type char(1), # Débit
('D') ou Crédit ('C')
Amount decimal(14,2), # Montant
Numero_Compte varchar(8) not null, # Numéro
de compte associé
Ratio decimal(14,4) not null #
Pourcentage du montant ŕ affecter au compte
);
(no semicolon at the end of the line Ratio ...

Cordially,
Marc SIRAMY

Discussion

  • Marc Siramy

    Marc Siramy - 2004-11-25

    MySQL_Compta_General.sql

     
  • Gilles Ballini

    Gilles Ballini - 2004-12-24
    • status: open --> open-fixed
     

Log in to post a comment.