Re: [libreoffice-users] Re: Need help with Base

On 6/05/2014 22:35, Girvin Herr wrote:
> Tom & Milica,
> No! No! No!  I am not offering to do the work.  I apologize if I 
> somehow implied that.  I  have zero experience writing LO macros of 
> any sort.  I was just suggesting to avoid macros wherever possible. 
> Recreating data entry forms and reports when there is a need to 
> migrate to another client (front end) is enough of a problem without 
> having to re-write macros too.
>
> I use the Base query editor as Tom suggests, which is a nice GUI shell 
> around the SQL, to create my table data relationships, aliases and 
> sorts.  It is very similar to what Access 1.1 had to define similar 
> relationships.  It works great.  If you want to see the underlying 
> SQL, it can switch modes to show the SQL and even test run it to see 
> the resultant output in table form.
>
> I was just suggesting to look at using a query or two rather than 
> macros, wherever possible.  Another aspect of this is that a query 
> should run the actions, such as a sort, on the database server 
> (back-end) and should run faster than a macro running in Base.
Using a proper SQL server + Macro's + dialogs (no forms) but using the 
dialog controls to visualise the data is not the easyist way but opens a 
never ending route.
> I am curious: Does the Base macro "engine" run in Java?  Has anyone 
> tested this probable speed difference?
not the macro's make a difference , you just use a macro visualise the 
data and to pass the SQL statements to the server who change , update or 
delivers the data. Only the connection with your server and the data 
volumes influence the speed.
> Girvin
>
>
>
> On 05/06/2014 03:52 AM, Tom Davies wrote:
> > Hi :)
> > Can you post some of the old macros as plain text and give a rough 
> > idea of
> > what each does.  SQL is usually easier because you get a nice gui to 
> > do a
> > lot of the work in a nice point&click way.  Some of the algebraic 
> > formulae
> > might be much the same or perhaps a little less convoluted.
> >
> > Plus Sql is more generic and less dependant on specific product and
> > versions.  On the other hand the LibreOffice/OpenOffice macro 
> > language is
> > also much less version-specific than MS macros.
> >
> > I'm not certain that Girvin is offering to do the work for free.  
> > Knowing
> > him he probably is but it might be better if there was a potential for
> > payment for work done, unless exchange-rates make that unworkable (as 
> > often
> > happens).
> > Regards from
> > Tom :)
> >
> >
> >
> > On 6 May 2014 07:45, milica <miljkovic.milica.83@gmail.com> wrote:
> >
> > > Dear Girvin,
> > > I have that base that we use in our workshop like warehouse
> > > management,(select product, type amount that needs to be 
> > > added/removed from
> > > warehouse and macro does it) and also base needs to create work orders
> > > based on calculation (for every product, how many half products 
> > > there is to
> > > be made) times number of products needs to be made,and then write 
> > > that on
> > > some report.
> > > I pretty mush did all the work in LO Calc, and the SQL is too much 
> > > for me
> > > currently. And I do that for personal use, since we have to switch from
> > > XP/Access to Ubutu/LO on our workshop computer.
> > > I cannot ask you to do that work for me, and I'm not sure If I could 
> > > handle
> > > that myself.
> > > Thanks,
> > > Milica
> > >
> > >
> > >
> > >
> > > On Tue, May 6, 2014 at 12:07 AM, Girvin Herr [via Document 
> > > Foundation Mail
> > > Archive] <ml-node+s969070n4107732h84@n3.nabble.com> wrote:
> > >
> > > > I have not been tracking MS Access system design since version 1.1, 
> > > > but
> > > > back then Access did have an external database back-end (server) 
> > > > engine
> > > > called Jet.  Jet was bundled in with Access, much like Base uses 
> > > > HSQLDB,
> > > > but I think it could be used by other front-end clients than Access.
> > > > So, the MS Access client-server  topology was not that unlike Base.
> > > > Base just allows one to get out of the MS Access proprietary "silo" 
> > > > and
> > > > allow much more control of the database system.
> > > >
> > > > For the record, I am using MySQL with Base, soon to be switching to
> > > > MariaDB.  I have not needed to use any macros in my work with Base 
> > > > forms
> > > > or reports.  I have made it a point to avoid macros because they are
> > > > very client-dependent and they would lock me in to a specific client,
> > > > much as the MS Access macros in your database are causing you problems
> > > > now.  I have been able to do some of what you are needing to do with
> > > > forms, only I used queries.  Many of my forms have list boxes where I
> > > > select one of a list of options to be inserted into a database field.
> > > > Although I have not used it, there is another type of drop-down 
> > > > listbox
> > > > that presents options, but if an option not in the list is needed, the
> > > > user may enter that option into the field.  I may have misread your
> > > > posting, but that may be what you need.  I can see that there are 
> > > > times
> > > > when macros would be the only answer to a problem, such as with custom
> > > > forms, but my recommendation is to avoid them whenever you can.
> > > > Girvin Herr
> > > >
> > > >
> > > > On 05/05/2014 12:28 PM, milica wrote:
> > > >
> > > > > Thanks,
> > > > > Actually, that base in ms access is kind of start point, and needs to
> > > be
> > > > > more developed,so I have to learn LO macros anyway :(
> > > > >    I'm reading the book OpenOffice.org Macros Explained (great 
> > > > > book!),
> > > > and
> > > > > making new version in LO but in LO Calc.
> > > > > Thank you once again :))
> > > > >
> > > > >
> > > > > On Mon, May 5, 2014 at 7:29 PM, TomD [via Document Foundation Mail
> > > > Archive]
> > > > > <[hidden email] <http://user/SendEmail.jtp?type=node&node=4107732&i=0
> > > > wrote:
> > > > > > Hi :)
> > > > > > Good point!!
> > > > > >
> > > > > > An external database is a really good approach.  Many people go for
> > > > MySql
> > > > > > or MariaDb (unless using a Mac) but that's owned by Oracle and some
> > > > worry
> > > > > > about the future of "free" or "Open Source" under Oracle.  Many 
> > > > > > go for
> > > > > > faster, lighter java back-ends such as Hsqldb as an external but
> > > others
> > > > > > worry about the whole java issue.
> > > > > >
> > > > > > So Postgresql might well be a good choice.  They have put a lot of
> > > work
> > > > > > into building a decent connector for Base.
> > > > > > Regards from
> > > > > > Tom :)
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > On 5 May 2014 15:44, Wolfgang Keller <[hidden email]<
> > > > http://user/SendEmail.jtp?type=node&node=4107696&i=0>>
> > > > > > wrote:
> > > > > >
> > > > > > > > I'm new user of LO Base, we are transitioning from MS Access, 
> > > > > > > > and I
> > > > > > > > need to redesign our db from it.
> > > > > > > One word of advice based on experience:
> > > > > > >
> > > > > > > Avoid use of the "built in" database.
> > > > > > >
> > > > > > > Use a proper client-server RDBMS. Preferrably PostgreSQL, as it's
> > > > > > > reliable and the driver comes with LO.
> > > > > > >
> > > > > > > Otherwise you *will* regret it the day your data has gone to 
> > > > > > > Nirvana.
> > > > > > >
> > > > > > > Sincerely,
> > > > > > >
> > > > > > > Wolfgang
> > > > > > >
> > > > > > > --
> > > > > > > To unsubscribe e-mail to: [hidden email]<
> > > > http://user/SendEmail.jtp?type=node&node=4107696&i=1>
> > > > > > > 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
> > > > > > --
> > > > > > To unsubscribe e-mail to: [hidden email]<
> > > > http://user/SendEmail.jtp?type=node&node=4107696&i=2>
> > > > > > 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
> > > > > >
> > > > > >
> > > > > > ------------------------------
> > > > > >    If you reply to this email, your message will be added to the
> > > > discussion
> > > > > > below:
> > > http://nabble.documentfoundation.org/Need-help-with-Base-tp4107400p4107696.html 
> > >
> > > > > >    To unsubscribe from Need help with Base, click here<
> > > > > > .
> > > > > > NAML<
> > > http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml 
> > >
> > > > >
> > > >
> > > > --
> > > > To unsubscribe e-mail to: [hidden email]<
> > > http://user/SendEmail.jtp?type=node&node=4107732&i=1>
> > > > 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
> > > >
> > > >
> > > >
> > > > ------------------------------
> > > >   If you reply to this email, your message will be added to the 
> > > > discussion
> > > > below:
> > > http://nabble.documentfoundation.org/Need-help-with-Base-tp4107400p4107732.html 
> > >
> > > >   To unsubscribe from Need help with Base, click here<
> > > http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4107400&code=bWlsamtvdmljLm1pbGljYS44M0BnbWFpbC5jb218NDEwNzQwMHwxODIyNjg3NDEz 
> > >
> > > > .
> > > > NAML<
> > > http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml 
> > >
> > > >
> > >
> > >
> > > --
> > > If you can imagine it, you can achieve it; if you can dream it, you can
> > > become it.
> > >
> > >
> > >
> > >
> > > --
> > > View this message in context:
> > > http://nabble.documentfoundation.org/Need-help-with-Base-tp4107400p4107761.html 
> > >
> > > Sent from the Users mailing list archive at Nabble.com.
> > > --
> > > 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


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