Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: ADucci on March 01, 2018, 11:49:28 pm

Title: SQL Macros dont seem to work on JET DATABASES #DB=JET#
Post by: ADucci on March 01, 2018, 11:49:28 pm

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

Title: Re: SQL Macros dont seem to work on JET DATABASES #DB=JET#
Post by: qwerty on March 02, 2018, 12:13:33 am

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

q.

Title: Re: SQL Macros dont seem to work on JET DATABASES #DB=JET#
Post by: ADucci on March 02, 2018, 07:50:33 pm

Thanks! ..


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