jmcnally 02/05/20 14:26:59
Modified: src/templates/sql/base/mssql drop.vm
Log:
patch by Skip Walker <[EMAIL PROTECTED]>
Adds a counter to the local variables @constraintname and @reftable, fixing the
bug described in
http://www.mail-archive.com/[email protected]/msg07101.html
Revision Changes Path
1.3 +5 -5 jakarta-turbine-torque/src/templates/sql/base/mssql/drop.vm
Index: drop.vm
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/base/mssql/drop.vm,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- drop.vm 22 Aug 2001 20:14:15 -0000 1.2
+++ drop.vm 20 May 2002 21:26:59 -0000 1.3
@@ -4,9 +4,9 @@
#end
IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = '$table.Name')
BEGIN
- DECLARE @reftable nvarchar(60), @constraintname nvarchar(60)
+ DECLARE @reftable_${velocityCount} nvarchar(60),
@constraintname_${velocityCount} nvarchar(60)
DECLARE refcursor CURSOR FOR
- select reftables.name tablename, cons.name constraitname
+ select reftables.name tablename, cons.name constraintname
from sysobjects tables,
sysobjects reftables,
sysobjects cons,
@@ -16,11 +16,11 @@
and reftables.id = ref.fkeyid
and tables.name = '$table.Name'
OPEN refcursor
- FETCH NEXT from refcursor into @reftable, @constraintname
+ FETCH NEXT from refcursor into @reftable_${velocityCount},
@constraintname_${velocityCount}
while @@FETCH_STATUS = 0
BEGIN
- 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}
END
CLOSE refcursor
DEALLOCATE refcursor
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
