Re: [PATCH] conf/torque/templates/sql/base/Control.vm,... Changed FK Create Order, Added MS SQL Server support

[Jon Stevens <jo...@latchkey.com>]

on 4/24/01 3:25 PM, "Dave Polito" <da...@planetcad.com> wrote:

> This is an update to the sql script creation process.  The foreign keys are
> now created after all tables are created.  A new template file tablefk.vm
> will be in each database directory.  I did not move all of the fk creation
> from the table.vm to tablefk.vm yet.  Maybe I can get some help with that?
> 
> Added MS SQL Server support.  I created separate directories called mssql.
> I know that the sybase support is similar, but I am not able to test against
> sybase.
> 
> In the sybase version of drop.vm template did not work in mssql for a table
> that was referenced by a foreign key.  So I changed the drop.vm in mssql to
> drop any foreign keys pointing to it first, then drop the table.
> 
> I hope this isn't too messy.
> 
> Dave Polito

I'm working on some torque changes right now...I will take care of these
patches...

Thanks!

-jon

-- 
If you come from a Perl or PHP background, JSP is a way to take
your pain to new levels. --Anonymous
<http://jakarta.apache.org/velocity/ymtd/ymtd.html>


---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org