Does DML issued via PCC need a commit

#1

I am newbie to Pervasive SQL 2000i. I issued some deletes
from the Pervasive control center. Do I need to issue some
kind of commit or save command. I have pored through their
docs, but havn't found anything yet.

Any suggestions are much appreciated.

Piyush

#2

piyush.mehta (AT) gmail (DOT) com wrote:

Quote:

I am newbie to Pervasive SQL 2000i. I issued some deletes
from the Pervasive control center. Do I need to issue some
kind of commit or save command. I have pored through their
docs, but havn't found anything yet.

Any suggestions are much appreciated.

Piyush

Every SQL statement issued will complete within its own database
transaction. You do not need to explicitly commit any statements
unless you are building a procedure using "BEGIN TRANSACTION" and want
to group MULTIPLE statements together in a transaction.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Sydney: Pervasive.SQL Service & Support Class - 02/27/06 ***
*** Chicago: Pervasive.SQL Service & Support Class - 03/27/06 ***

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Does DML issued via PCC need a commit

comp.databases.btrieve comp.databases.btrieve

Does DML issued via PCC need a commit - 02-01-2006 , 04:41 PM

Re: Does DML issued via PCC need a commit - 02-02-2006 , 08:47 AM