Cursor is closed after an insert into another table? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Cursor is closed after an insert into another table?

Message

From

08/03/2002 16:42:26

Stephen Russell
S. R. & Associates
Memphis, Tennessee, United States

To

08/03/2002 15:57:15

Stephen Russell
S. R. & Associates
Memphis, Tennessee, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Cursor is closed after an insert into another table?

Miscellaneous

Thread ID:

00630349

Message ID:

00630426

Views:

25

>I needed to Begin Transaction before the 2nd cursor and then commit the transaction(s) after closing down the cursors.
>
>__Stephen

OK that gets me through the SECOND trans of the cursor, but now 3, 4,...

Any ideas?

__Stephen Russell
>>
"Simplicity is the ultimate sophistication."

Leonardo da Vinci

>> My old crummy site.

Click here to load this message in the networking platform