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]>
