Re: [libreoffice-users] Re: Base - a risky feature of the document display?

Hi Harvey,
> > here is a little example-database for executing SQL by a macro.
> > http://robert.familiegrosskopf.de/download/Example_InsertUpdateDelete
> > _SQL.odb
> > Open the form and try. Could be constructed a little bit better, but
> > works when code is right.
> >
> > Regards
> >
> > Robert
>
> Hi Robert,
>
> I think I can see what you are trying to do, but nothing happens on
> clicking the button. 

First there should appear a messagebox with question: "Should the code
... be executed?"
If you click "yes" here the update will be executed.

> The values of 'class' remain fixed at 1,3,2. Also
> I get no messages like warning of macro execution. (Macro Security
> level Medium)

I have the same: Security medium, my only documents in Trusted Sources >
Trusted File Locations.

Macro will be executed here and update to 2,4,3 will be executed.

Don't know what is going wrong there with your installation.

If you have opened the table at the same time you have to refresh the
data of the table afterwords - but if you don't see the messagebox there
is something totally wrong with macro-executing.

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted