equal
deleted
inserted
replaced
194 // The column USAGE_DATA is used to order the items |
194 // The column USAGE_DATA is used to order the items |
195 _LIT( KSQLGetListByLaunchDataPart2,") LEFT JOIN("); |
195 _LIT( KSQLGetListByLaunchDataPart2,") LEFT JOIN("); |
196 _LIT( KSQLGetListByLaunchDataPart3,") ON ENTRY_ID = LA_ENTRY_ID \ |
196 _LIT( KSQLGetListByLaunchDataPart3,") ON ENTRY_ID = LA_ENTRY_ID \ |
197 ORDER BY USAGE_DATA"); |
197 ORDER BY USAGE_DATA"); |
198 |
198 |
199 _LIT( KSQLGetParentIds,"SELECT GE_GROUP_ID FROM CA_GROUP_ENTRY \ |
199 _LIT( KSQLGetParentIds,"SELECT DISTINCT GE_GROUP_ID FROM CA_GROUP_ENTRY \ |
200 WHERE GE_ENTRY_ID IN ( %S )" ); |
200 WHERE GE_ENTRY_ID IN ( %S )" ); |
201 |
201 |
202 _LIT( KSQLNotINIds," AND GE_GROUP_ID NOT IN( %S )" ); |
202 _LIT( KSQLNotINIds," AND GE_GROUP_ID NOT IN( %S )" ); |
203 |
203 |
204 _LIT( KSQLGetIconIdWhere,"SELECT ICON_ID AS Data FROM CA_ICON WHERE "); |
204 _LIT( KSQLGetIconIdWhere,"SELECT ICON_ID AS Data FROM CA_ICON WHERE "); |