Not an answer, but what was the reason for using cursors? Ade
-----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 04 June 2003 11:24 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] OT: SQL: copying text columns Hi all, I have a Stored Procedure that copies rows in a SQL 7 database back into the same table, but with a different primary key, so that a user can quickly clone and edit records in an application. This SP uses cursors to achieve this (as we discussed on this list a while back) This works fine, but now one of the columns that needs to be copies is of the TEXT datatype, which can't be set to a local variable. So this means I can't do this: DECLARE @group_name VARCHAR(250), @group_description TEXT DECLARE groupCursor CURSOR LOCAL FOR SELECT group_name, group_description FROM groups WHERE group_id = @oldgroup OPEN groupCursor FETCH NEXT FROM groupCursor INTO @group_name,@group_description WHILE @@FETCH_STATUS = 0 BEGIN INSERT INTO groups(group_name, group_description) VALUES(@group_name,@group_description) FETCH NEXT FROM groupCursor INTO @group_name,@group_description END CLOSE groupCursor DEALLOCATE groupCursor Can anyone think of another way to do this? ta. ------------------------------------------------------- Rich Wild Senior Web Developer ------------------------------------------------------- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. ------------------------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
