Is anyone genenerating their XML schema from an existing database? I'm beginning the process of moving some of our old old old (its really old!) software over to have its interface "in the browser". I haven't gotten very far.
I use the "jdbc" option of torque - ant -f build-torque.xml jdbc - and it generates the schema.xml file. I go in and look at that file and it looks pretty good - EXCEPT: There is no decimal precision. The decimal fields all have the proper size, but no scale - no decimal precision. In other words, I get a "<column name="MRATE" required="true" size="7" type="DECIMAL"/> - _unfortunately_ the field definition is MRATE DECIMAL(7,2). If I then go and "ant init" this to the new database, I get MRATE DECIMAL(7,0). Not good. Obviously I could correct this myself, but as I mentioned, I'm moving over a preexisting system - it has a _lot_ of tables (which means a heckuva lot of fields!!). There's got to be a way to get torque to generate the correct column definitions. Thanks for any help! Jeff Owens -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
