Re: [libreoffice-users] Re: Macro to open form + pass on value from current form

On 12/17/2014 08:52 AM, Alexander Thurgood wrote:
> My own take on this, as I had something similar setup a long time ago,
> was to have a button that activated a macro which :
>
> - checked whether a value existed in another table via a parameterized
> query,
Do you have an example of how to do this? The online documentation is
quite scarce for base :-/
> - if the ID didn't exist, constructed and fired an INSERT statement to
> insert a new value into that table (either automatically if it was
> autoincrement, or using a previous last_insert_id() function to query
> the id counter and add 1 to it to create my new counter value ;
> - then return the inserted value and display it to the user via a
> message box.
>
> Alternatively, I guess I could've caused a second form to open up after
> successful completion of the INSERT statement, but that isn't what I needed.
>
> Not quite sure why you need to open a whole set of other forms though,
> as the value you obtain for BookID could be inserted programmatically
> without going through forced UI steps (unless that is what you want for
> some particular reason)
Well the button is basically "Book is Part of Series" - this opens a new
form "Series" which allows me to then either select a series that's
already entered, or if it's a new series that I'm just starting, allows
me to create a new series entry and attaches the bookID to that series.

Thanks Alex - been told you're one of the go to heroes in the db
community. I appreciate the help as this is all somewhat new to me.


Best,
Joel



-- 
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