Re: [MDB] manager does not create decimal fields with mysql

Hi, after some searches and saw how it was done ion other drivers, I made this change in mysql.php (v1.80.4.8): 1137,1138c1137,1138 < return("$name BIGINT". < (isset($field['default']) ? --- > return("$name DECIMAL(18,".$this->decimal_places.")". > (isset($field['default']) ? and MDB decimal fields are created fine now, and I don't see for the moment why there was BIGINT Thierry B. -- Click below to answer / cliquez ci dessous pour me repondre http://cerbermail.com/?MQkxTL4vUP "Thierry Bothorel" <thierry.bo@netcourrier.com> a écrit dans le message de news:20040113000222.33037.qmail@pb1.pair.com... > Hi, > > I use these statements in my xml schema : > > <field> > <name>PGHT</name> > <type>decimal</type> > <notnull>1</notnull> > <default>0.000</default> > </field> > > <field> > <name>PTIPS</name> > <type>decimal</type> > <notnull>1</notnull> > <default>0.00</default> > </field> > > but with mysql, mdb manager creates BIGINT(20) fields. That's a big problem. > I use MDB 1.2. > > Thierry Bothorel > -- > Click here to answer / cliquez ci dessous pour me repondre > http://cerbermail.com/?7O7SOrggJg