Separator for multi-statement sql query in search

[amacara1]

I am trying to write a multi-statement sql search query and it looks to me this is not supported.

This works fine, in the sense that it prints content of t_object:
select * from t_object

But, this does seem to not execute at all, without even returning error messages:
declare v as int; select * from t_object
(I can even write typos and nothing is reported)

Using ENTER or Ctrl+ENTER or even removing ; do not seem to help. What am I missing, please?

[Geert Bellekens]

In EA search you can only use a query that starts with "select". If it doesn't start with "select" EA doesn't even try processing it.
It won't execute any non-query commands.

Geert

[amacara1]

Thank you!
Is then there a way to create a variable somehow? My query needs name/guid of a package in several places (I am using that 'pragmatic' search for all-elements-in-a-subtree) and I would like to write the name just once.

[Geert Bellekens]

Thank you!
Is then there a way to create a variable somehow? My query needs name/guid of a package in several places (I am using that 'pragmatic' search for all-elements-in-a-subtree) and I would like to write the name just once.

No, but you can use the #Branch# macro if you want to select all in a subtree.
There's also a macro for the selected package, but you'll have to look that one up in the manual.

Geert

[amacara1]

I understand, but I use the sql query for a matrix specification