SQL Macros dont seem to work on JET DATABASES #DB=JET#

[ADucci]

I am trying to get these SQL macros working.

The following query works perfectly in a MS SQL database, however, does not work when running in the direct database connection (MS JET)

any ideas?



select top 10 name,
   stereotype
   #DB=JET#, 'MSJET' as source#DB=JET#
   #DB=SQLSVR#, 'SQLSERVER' as source #DB=SQLSVR#
from
   t_object

[qwerty]

It does not work in the scratch pad, but only in the user defined searches.

q.

[ADucci]

Thanks! ..


I really struggled... cant believe it was so easy.