1
Bugs and Issues / #DB=<DBNAME># macro in SQL Search not works in EA 16.1
« on: November 03, 2023, 01:30:57 am »
Hi,
I tried to use the #DB=<DBNAME># type of macro in SQL searches in EA 16.1, but it doesn't seem to work. I got errors for these searches in .qea (SL3 = sqlite) and Oracle db repositories too.
Example query:
However #WC# and #Package# macro works perfectly in all cases.
Examples:
Please correct me if I missed something, or please investigate this and fix it!
I tried to use the #DB=<DBNAME># type of macro in SQL searches in EA 16.1, but it doesn't seem to work. I got errors for these searches in .qea (SL3 = sqlite) and Oracle db repositories too.
Example query:
Code: [Select]
SELECT p1.Package_ID, p1.Parent_ID, o1.Stereotype
FROM T_PACKAGE p1
#DB=SL3# inner join t_object o1 on o1.PDATA1=p1.Package_ID #DB=SL3#
#DB=Oracle# inner join t_object o1 on o1.PDATA1=TO_CHAR(p1.Package_ID) #DB=Oracle#
WHERE p1.Package_ID = #Package#
However #WC# and #Package# macro works perfectly in all cases.
Examples:
Code: [Select]
SELECT p1.Package_ID, p1.Parent_ID, o1.Stereotype
FROM T_PACKAGE p1
inner join t_object o1 on o1.PDATA1=p1.Package_ID
WHERE p1.Package_ID = #Package#
(like the one above, but only for SL3/.qea)Code: [Select]
SELECT o1.*
FROM t_object o1
WHERE o1.Name like "Control#WC#"
(this uses #WC# perfectly in .qea and in Oracle too)Please correct me if I missed something, or please investigate this and fix it!