Batch statements.

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Batch statements.

Logged in as: Guest

arrSession:exec spGetSession 2,3,61894

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> Batch statements.
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Batch statements. - 6/26/2008 5:00:45 AM

dodad

Posts: 3
Score: 0
Joined: 6/26/2008
Status: offline

Using vbscript and sql server 2000. Kind of new at this.

Been trying all morning to execute a group of insert statement in one call. Everything works fine but if there is an error in one of the statements I don't get an error in my vbscript page. I tried setting xact_abort to true which aborts and rollsback the batch but I still need to get an error.

NL is a new line.

any ideas?

Post #: 1

RE: Batch statements. - 6/28/2008 5:53:44 AM

webber123456

Posts: 37
Score: 0
Joined: 9/20/2007
Status: offline

try outputting the error first then doing a rollback...

(in reply to dodad)

Post #: 2

RE: Batch statements. - 6/30/2008 12:46:23 AM

dodad

Posts: 3
Score: 0
Joined: 6/26/2008
Status: offline

I can't get the error. Thats the problem. That sql string will execute just fine in SQL Server 2000 through ADO even though the sixth insert statement will error out.

(in reply to webber123456)