Yes.. I was talking about the SAVEPOINT syntax in SQL / oracle. Thank you. Will surely let you know..
Also, can you tell me how to configure EXEC SQL COMMIT WORK RELEASE; used in embedded sql in SOCI. Sent from my iPhone. Brevity may be excused. Thank You. Regards, Medhavi Mahansaria. > On 27-Nov-2014, at 8:42 pm, Mateusz Loskot <mate...@loskot.net> wrote: > > On 27 November 2014 at 13:14, Medhavi Mahansaria > <medhavi1...@yahoo.co.in> wrote: >> >> I would like to know how to configure savepoint and commit work release >> option using SOCI. > > Do you mean savepoint as SAVEPOINT syntax in SQL? > There is no built-in support for that in SOCI, but you should be able > to execute such statements > > sql.once << "SAVEPOINT myname"; > ... > sql.once << "ROLLBACK TO SAVEPOINT myname"; > > > It should be easy to create a RAII wrapper for this, > similar to soci::transaction > http://soci.sourceforge.net/doc/3.1/statements.html#transactions > > I'd be interested to know if SAVEPOINT statements worked for you, > so please let me know. > > Best regards, > -- > Mateusz Loskot, http://mateusz.loskot.net > > ------------------------------------------------------------------------------ > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk > _______________________________________________ > soci-users mailing list > soci-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/soci-users ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk _______________________________________________ soci-users mailing list soci-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/soci-users
