Using variable on virtual table

[phabio]

Hi all,
when I create a new virtualtable, can I use a macro or a memory variable?

for example:

select * from SalesOrders where OrderDate > &fromDate

I remember something.. but I don't find the right syntax

thanks
Fabio

[barrymavin]

See "Development Essentials" | Understanding macros.
https://www.lianja.com/doc/index.php...tanding_Macros

and

Using parameterized Views.
https://www.lianja.com/doc/index.php...rameters_Views

[phabio]

thanks Barry