So far, none of the links really strike me as helpful. Sorry, but this is
fairly new territory to me.
I had hoped I would find a tutorial something along the lines of:
We're going to create a way for users to enter/update data across a few
tables in a single transaction.
Here's how you do it using macros/BASIC... Here's how you do it using the
DB's native capabilities...
In order to stop our form from entering the data into each field as we
type, we need to do so and so...
Now to collect all the data and click submit...
How does one prevent the form "inserting" the data "on the fly" - do I use
a macro? Should I write a function or procedure on my PGSQL server to run
when the user clicks "Submit" in the base form? And how do I get the
"Submit" action down to Postgres to run the transaction procedure?
I get the commit() function (
But isn't there a "BEGIN" statement?
I think what I will do is move my DB forward at its current level and read
up on transactions, triggers and procedures - as well as on LO Basic &
Macros - so I can implement the transaction stuff later. I bet it's a lot
simpler to understand than I think. But having to look in 20 different
locations for little pieces of info - and then figure which pieces go where
in my problem is more than I really have time for right now.
If & when I do figure it out, I'll have to write a tutorial on it for sure.
On Fri, Jul 19, 2013 at 8:56 AM, Andrew Douglas Pitonyak <
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)?
These may also be of interest:
This document mentions transactions in passing
I do not remember if I discuss transactions at all in AndrewBase.odt
On 07/18/2013 04:05 PM, Don Parris wrote:
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
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.
My Macro Document:
To unsubscribe e-mail to:
Posting guidelines + more: http://wiki.**documentfoundation.org/**
All messages sent to this list will be publicly archived and cannot be
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
GPG Key ID: F5E179BE
To unsubscribe e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy