}
> - else if (tn.indexOf ("INT") != -1)
> + else if (tn.indexOf ("INT") != -1 ||
> + tn.indexOf ("NUMBER") != -1)
> {
> + if (size.indexOf(",") != -1)
> + {
> + torqueType = "FLOAT";
> + columnType = new Float (0);
> + }
> + else if (size.length() > 1)
> + {
> + torqueType = "NUMERIC";
> + columnType = new java.math.BigDecimal (0);
> + }
> + else
> + {
> torqueType = "INTEGER";
> columnType = new Integer (0);
> }
This looks to me that any numeric that has a size setting that includes
a comma will be a FLOAT, otherwise if it has a size argument at all it
is NUMERIC, otherwise it is an INTEGER. This does not look right. So
NUMERIC fields cannot hold decimals? Why is a SIZE=3 column a NUMERIC
and not an INTEGER? Will a FLOAT of SIZE=(100,50) work?
john mcnally
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
