[There are small variations to this answer depending on
the version of Turbine you are using.]
The mappings for each type are under
torque/templates/sql/base/<DB>/db.props [DB is mssql in your case]
I can see that for MSSQL, JDBC type FLOAT has no mapping defined.
What would be the correct type for a JDBC FLOAT in MSSQL? Stick it
in there, and try. And if you think it is the correct answer
always, submit a patch (or at least a message with the
type mapping you come up with).
--
Gonzalo A. Diethelm
[EMAIL PROTECTED]
> -----Original Message-----
> From: Humberto Hernadez Torres [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 23, 2001 10:02 AM
> To: [EMAIL PROTECTED]
> Subject: Torque is not generating FLOAT type
>
>
> 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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
