Re: [libreoffice-users] Base & PostgreSQL Transactions

The ODF Authors are working on a DB guide, I do not know the current 
state of it, have you looked for it (or at it)?
https://wiki.documentfoundation.org/images/5/50/BH40-BaseHandbook.odt

These may also be of interest:

http://wiki.openoffice.org/wiki/Documentation/DevGuide/Database/Using_DBMS_Features#Transaction_Handling
http://wiki.openoffice.org/wiki/Documentation/DevGuide/Database/Using_DBMS_Features
http://www.openoffice.org/api/docs/common/ref/com/sun/star/sdbc/TransactionIsolation.html

This document mentions transactions in passing
http://www.baseprogramming.com/OOBasicDatabaseDev.pdf

I do not remember if I discuss transactions at all in AndrewBase.odt

On 07/18/2013 04:05 PM, Don Parris wrote:
> Hi all,
>
> I have a 4-table DB in PostgreSQL to which I connect using LibreOffice
> Base.  I have a form with 2 subforms in place that allows me to:
> Select an existing entity (from the ENTITY table)
> Add a new financial transaction (to the TRANSREC table)
> Add new line items for each transaction (to the TRANSDETAILS table).
>
> I would like to take advantage of PostGRESQL's underlying transaction
> (start, rollback, commit, etc.) to ensure that a given transaction and its
> line items are entered as one single transaction.  I just don't know how to
> implement that using Base as a front-end.
>
> Maybe I really need something like macros and BASIC or Python to make such
> a thing work?  If anyone knows a good tutorial on this subject, I can
> certainly read - just haven't really found anything yet.
>
>
> Thanks!
> Don

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted