Issue 49185 - Queries can't call macro functions
Summary: Queries can't call macro functions
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0 Beta
Hardware: PC Windows NT
: P3 Trivial with 5 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-05-12 21:05 UTC by macuser_winpgmr
Modified: 2017-06-21 11:24 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description macuser_winpgmr 2005-05-12 21:05:10 UTC
Queries don't support the calling of macro functions. In Access, a query field
expression can reference any VBA function in the database. This adds unlimited
power and allows complex expressions to be moved out of the query field and into
code where they can be documented and tested independent of the query.
Comment 1 marc.neumann 2005-05-13 07:48:55 UTC

I reassign it to the User Experience Team for evaluating.

Bye Marc
Comment 2 oooforum (fr) 2009-11-09 13:38:45 UTC

Now from 3.1.0, we can embedded macro in ODB file. This is very helpful to use
our own functions.

Thanks in advance.

Comment 3 BRAIT 2017-06-21 11:24:30 UTC
Hello Folk !

Very very interested by this new functionnality, too !

Should we endly access to our user define functions ? 
Ooobasic, python, java compatible ?

What about triggers, that we can't use in hsql 1.8 ?

I know you are doing your best !
Thanks a lot.