We are generating the project-sql with torque but it is not generating
the type column for the FLOAT types. We are using MS SQL.

An example of our project-schema.xml is:
<database>
    <table name="PROMOCION" idMethod="idbroker">
       <column name="IDE_PROMOCION"  required="true" primaryKey="true"
type="INTEGER"/>
       <column name="PRO_MARCA"      size="60" type="VARCHAR"/>
       <column name="PRO_MODELO"     size="60" type="VARCHAR"/>
       <column name="PRO_CANTIDAD"   type="INTEGER"/>
       <column name="PRO_PRECIO"     type="FLOAT"/>
    </table>
</database>

This is the resulting project-schema.sql file:
// Some lines deleted. Notice the type in the PRO_PRECIO Column.

CREATE TABLE PROMOCION
(
    IDE_PROMOCION INT NOT NULL,
    PRO_MARCA VARCHAR (60) NULL,
    PRO_MODELO VARCHAR (60) NULL,
    PRO_CANTIDAD INT NULL,
    PRO_PRECIO NULL,

    CONSTRAINT PROMOCION_PK PRIMARY KEY(IDE_PROMOCION),);

 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to