|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Strange transaction behavior
Date: May 19 1998 10:10PM
Wechsler, Steven M writes:
> Is there something unusual you need to do in order to be able to use
> begin tran/commit tran with DBLib?
>
> Here's what I'm doing:
>
> begin tran
> do a bunch of ad-hoc updates to user tables in various databases
> do a bunch of updates to system tables via stored procedures
> commit tran
>
> This works fine in ISQL. It also works without the begin tran/commit
> tran
If it works in isql it should work with Sybase::DBlib. I suspect that
you are not processing the results correctly (ie you are maybe not
calling dbresults() until it returns NO_MORE_RESULTS each and every
time).
Michael
--
Michael Peppler -||- Data Migrations Inc.
mpeppler@datamig.com -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
|
