Re: [libreoffice-users] Do Macros run serially or in parallel?

Hi Noel

So are you trigering these events and running the macros to populate a form from two separate 
tables?

Alex


On Sunday 06 Apr 2014 00:13:31 Marion & Noel Lodge wrote:
> Hi,
>
> Sorry I've been slow to respond to all your posts.  It has taken me a while
> to sort out what I think is happening.
>
> Fernand, thanks for your code suggestion.  I pasted it into the start of my
> macros and the Wait() statement worked perfectly.  Then I incorporated it
> into my Init macro and discovered that none of my Wait() statements
> worked.  The same applied to the AccName macro.  I was really puzzled and
> probably spent longer than I should have on the problem, but I felt I
> really needed an answer.  Finally, through much trial and error I found
> which macros Wait() worked in and which it didn't.  My testing was not
> exhaustive, but it seems that Wait() doesn't work in any macro that is
> called from one of the Form's events.  When I got back to reading my
> emails, I discovered that Andrew was predicting that this might be the
> case!
>
> Then it occurred to me that, rather than use separate text files for
> printing out the Now() values, if I used just one file, it would give me
> the order of processing, and the exact times would not be so important.  So
> I did that and also added System Ticks / 1000.  The result was as follows -
>
> Init 1.  05/04/2014 23:20:37  43421.801
> Init 2.  05/04/2014 23:20:37  43421.801
> Init 3.  05/04/2014 23:20:37  43421.817
> Init 4.  05/04/2014 23:20:37  43421.833
> Init 5.  05/04/2014 23:20:37  43421.848
> Init 6.  05/04/2014 23:20:40  43424.36
> Init 7.  05/04/2014 23:20:40  43424.375
> Name 1.  05/04/2014 23:20:40  43424.625
> Name 2.  05/04/2014 23:20:40  43424.625
> Name 3.  05/04/2014 23:20:40  43424.625
>
> This demonstrates that macro Init ran before macro Name.
>
> > From this, and a number of other tests I ran, I believe that -
> 1.  Macros are always processed serially on a first come first served basis.
> 2.  If macro A calls macro B, then Macro A waits until macro B has
> completed before the remaining code of macro A is processed.
>
> These were the conclusions that I was hoping for.  As well, I now have a
> mechanism for checking out other timing situations where I'm not sure what
> is going on.
>
> So thank you all for your input - it has been an interesting journey!
>
> Noel
> --
> Noel Lodge
> lodgemn@gmail.com
>
> PS Alex, Yes you are right - the account name needs to be fetched from
> another table.

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