nevermind. some more reading gave me the answer. patch applied.
john mcnally
On Mon, 2002-05-20 at 13:12, John McNally wrote:
> any mssql users out there have an opinion for or against this patch?
> Why is it needed?
>
> john mcnally
>
> On Tue, 2002-04-16 at 14:39, Skip Walker wrote:
> > cvs diff drop.vm (in directory
> > C:\Temp\jakarta-cvs\jakarta-turbine-torque\src\templates\sql\base\mssql\)
> > Index: drop.vm
> > ===================================================================
> > RCS file:
> > /home/cvspublic/jakarta-turbine-torque/src/templates/sql/base/mssql/drop.vm,
> > v
> > retrieving revision 1.2
> > diff -r1.2 drop.vm
> > 7c7
> > < DECLARE @reftable nvarchar(60), @constraintname nvarchar(60)
> > ---
> > > DECLARE @reftable_${velocityCount} nvarchar(60),
> > @constraintname_${velocityCount} nvarchar(60)
> > 9c9
> > < select reftables.name tablename, cons.name constraitname
> > ---
> > > select reftables.name tablename, cons.name constraintname
> > 19c19
> > < FETCH NEXT from refcursor into @reftable, @constraintname
> > ---
> > > FETCH NEXT from refcursor into @reftable_${velocityCount},
> > @constraintname_${velocityCount}
> > 22,23c22,23
> > < exec ('alter table '+@reftable+' drop constraint '+@constraintname)
> > < FETCH NEXT from refcursor into @reftable, @constraintname
> > ---
> > > exec ('alter table '+@reftable_${velocityCount}+' drop constraint
> > '+@constraintname_${velocityCount})
> > > FETCH NEXT from refcursor into @reftable_${velocityCount},
> > @constraintname_${velocityCount}
> >
> >
> > --
> > To unsubscribe, e-mail:
><mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail:
><mailto:[EMAIL PROTECTED]>
> >
>
>
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
