Path: utzoo!mnetor!tmsoft!torsqnt!news-server.csri.toronto.edu!cs.utexas.edu!ubiquity
From: ubiquity@cs.utexas.edu (Richard Hoffman)
Newsgroups: comp.databases
Subject: Re: ingres embedded SQL/C problem
Message-ID: <17309@cs.utexas.edu>
Date: 27 Jan 91 14:35:15 GMT
References: <1991Jan27.023129.721@eng.ufl.edu>
Organization: Ubiquitous Productions, R. Hoffman Proprietor
Lines: 21

In article <1991Jan27.023129.721@eng.ufl.edu> tsao@helios.tcad.ee.ufl.edu 
(Tsao) writes:

>	I am trying to insert new data into a table, and I have compiled and
>run the program without any error, but then I check the table, new data
>is not there. 
>
>	exec sql SAVEPOINT savept;
>	exec sql insert into testtbl(name,age)
>		values (:tbl);
>	exec sql ROLLBACK to savept;

Uh, don't you want to COMMIT?  By using ROLLBACK, you are telling the engine
to dump all work since the savepoint, which it is apparently doing 
successfully.

-- 
Richard Hoffman       IBM Personal Systems Database Development   (512) 823-1822
1529 Ben Crenshaw Way
Austin, TX 78746         "Life is a gamble at terrible odds; 
(512) 327-9232            if it were a bet you wouldn't take it"  (Tom Stoppard)