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: [email protected]
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
