commit require in query analyzer?
Posted on 2006-04-28
The SP is much bigger then this but here is the top few lines.
--clear out the old values
delete from table where field_id = @id;
--copy all the new values into the table
insert into table (field_id, field_code, field_value)
select @id, field_code, 0
If I use the query analyzer the above two queries will not work unless I put the word commit under each but if I call this SP from VB it works. I have a problem with the SP and it is very difficult to trouble shoot it unless I can get it to work in both environment which are query analyzer and in VB.