Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-23 Thread Don Parris
Thanks Mark, that certainly looks interesting. I may just check it out. Even so, that puts a damper on a short-term solution. On Fri, Jul 19, 2013 at 4:51 PM, Mark LaPierre marklap...@aol.com wrote: Hey Don, I've not bought one yet, but this is the best reference I've found out about for

Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-20 Thread Andrew Douglas Pitonyak
Let me start by saying that I am not a DB expert and, although I have done significant work using DB and using transactions, I have not done so using Base or LO in general. More comments in-line. On 07/19/2013 04:31 PM, Don Parris wrote: I had hoped I would find a tutorial something along

Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-19 Thread mcmurchy1917-libreoffice
Have you read this document? http://www.baseprogramming.com/OOBasicDatabaseDev.pdf Iain On Thursday 18 Jul 2013 18:32:01 Don Parris wrote: On Thu, Jul 18, 2013 at 4:27 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) If you are looking for a good guide about Macros then Andrew

Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-19 Thread Tom Davies
and time drifts.  Regards from Tom :)  From: Don Parris parri...@gmail.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 18 July 2013, 23:32 Subject: Re: [libreoffice-users] Base PostgreSQL Transactions On Thu, Jul 18, 2013 at 4

Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-19 Thread 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)? https://wiki.documentfoundation.org/images/5/50/BH40-BaseHandbook.odt These may also be of interest:

Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-19 Thread Mark LaPierre
Hey Don, I've not bought one yet, but this is the best reference I've found out about for LO Base. It's based on OOo Base, but that's most likely not a real issue. The one biggest problem with LO Base is the decided lack of documentation.

Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-19 Thread Don Parris
Thanks Andrew, 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

[libreoffice-users] Base PostgreSQL Transactions

2013-07-18 Thread Don Parris
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

Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-18 Thread Tom Davies
:)  From: Don Parris parri...@gmail.com To: users@global.libreoffice.org Sent: Thursday, 18 July 2013, 21:05 Subject: [libreoffice-users] Base PostgreSQL Transactions 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

Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-18 Thread Don Parris
On Thu, Jul 18, 2013 at 4:27 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) If you are looking for a good guide about Macros then Andrew Pitonyak's guide is supposedly the best https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers Apparently it