Hi :) Sorry about my replies to this idea of using macros! i don't use nor understand macros at all. From what people have been saying to me off-list it sounds like they are much more efficient than i had assumed. Plus it sounds like there is some scope for building a whole proper app that way. It sounds well worth exploring! :)
Anyway, many apols and regards from Tom :) On 7 May 2014 10:17, Tom Davies <tomc...@gmail.com> wrote: > Hi :) > Macros are code running on a desktop machine right? So don't they take up > cpu cycles? If the macro code is then running stuff through Sql code then > it's going to take more Cpu cycles than just running Sql alone. So in > terms of network traffic they might not count for much but in terms of > end-user experience it might be critical on low-spec machines. > > As for visualisation of data SQL statements built-up through the Base gui > can show the resultant data neatly in a table that looks like a > spreadsheet. I don't think macros can do that. > > A proper programmer might be able to visualise data more easily without > the distraction of something being right in front of her/his eyes and thus > obscuring abstractions and specific cases at extreme ends of the possible > data but most of us need to see something 'concrete' before we can begin to > start on that sort of visualisation. > > On the other hand if macro language is easier to understand and code for > then that might well be the best route for surest victory right now. > Perhaps look into using a gui to build Sql statements after you have first > got something running using macros. "Release early and release often". > The macro version would be the 1.1 and the non-macro would be the 2.0 with > advantages such as being faster. People could buy into either one without > having to worry about incompatibility issues when trying to communicate > with people using the other. Also learning the LO macro language means you > can write macros to do other things and unlike with MS macros don't have to > worry much about those macros becoming out-dated by the next release of LO > or AOO or AndrOO or whatever. > > Regards from > Tom :) > > > > > On 7 May 2014 08:20, Fernand Vanrie <s...@pmgroup.be> wrote: > >> 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...@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+s969070n4107732...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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