equal
deleted
inserted
replaced
89 _LIT( KSQLUpdateEntryUid, "EN_UID = :EN_UID " ); |
89 _LIT( KSQLUpdateEntryUid, "EN_UID = :EN_UID " ); |
90 _LIT( KSQLUpdateEntryUidNULL, "EN_UID = NULL " ); |
90 _LIT( KSQLUpdateEntryUidNULL, "EN_UID = NULL " ); |
91 _LIT( KSQLUpdateEntryFlags, "EN_FLAGS = :EN_FLAGS " ); |
91 _LIT( KSQLUpdateEntryFlags, "EN_FLAGS = :EN_FLAGS " ); |
92 _LIT( KSQLUpdateWhere, "WHERE ENTRY_ID = :ENTRY_ID " ); |
92 _LIT( KSQLUpdateWhere, "WHERE ENTRY_ID = :ENTRY_ID " ); |
93 |
93 |
|
94 // Null Icon params |
|
95 _LIT( KSQLEmptyIconFileName, "(IC_FILENAME IS NULL OR IC_FILENAME = '')" ); |
|
96 _LIT( KSQLEmptyIconSkinId, "(IC_SKIN_ID IS NULL OR IC_SKIN_ID = '')" ); |
|
97 _LIT( KSQLEmptyIconAppId, "(IC_APP_ID IS NULL OR IC_APP_ID = '')" ); |
94 |
98 |
95 // Update Icon |
99 // Update Icon |
96 _LIT( KSQLUpdateIconId, "ICON_ID = :ICON_ID " ); |
100 _LIT( KSQLUpdateIconId, "ICON_ID = :ICON_ID " ); |
97 _LIT( KSQLUpdateIconFileName, "IC_FILENAME = :IC_FILENAME " ); |
101 _LIT( KSQLUpdateIconFileName, "IC_FILENAME = :IC_FILENAME " ); |
98 _LIT( KSQLUpdateIconSkinId, "IC_SKIN_ID = :IC_SKIN_ID " ); |
102 _LIT( KSQLUpdateIconSkinId, "IC_SKIN_ID = :IC_SKIN_ID " ); |
173 _LIT( KSQLGetParentIds,"SELECT GE_GROUP_ID FROM CA_GROUP_ENTRY \ |
177 _LIT( KSQLGetParentIds,"SELECT GE_GROUP_ID FROM CA_GROUP_ENTRY \ |
174 WHERE GE_ENTRY_ID IN ( %S )" ); |
178 WHERE GE_ENTRY_ID IN ( %S )" ); |
175 |
179 |
176 _LIT( KSQLNotINIds," AND GE_GROUP_ID NOT IN( %S )" ); |
180 _LIT( KSQLNotINIds," AND GE_GROUP_ID NOT IN( %S )" ); |
177 |
181 |
178 _LIT( KSQLGetIconId,"SELECT ICON_ID AS Data FROM CA_ICON \ |
182 _LIT( KSQLGetIconIdWhere,"SELECT ICON_ID AS Data FROM CA_ICON WHERE "); |
179 WHERE IC_FILENAME = :IC_FILENAME AND \ |
|
180 IC_SKIN_ID = :IC_SKIN_ID AND \ |
|
181 IC_APP_ID = :IC_APP_ID"); |
|
182 |
183 |
183 _LIT( KSQLGetEntryIdFromEntryTable,"SELECT ENTRY_ID AS Data FROM CA_ENTRY \ |
184 _LIT( KSQLGetEntryIdFromEntryTable,"SELECT ENTRY_ID AS Data FROM CA_ENTRY \ |
184 WHERE ENTRY_ID = :ENTRY_ID"); |
185 WHERE ENTRY_ID = :ENTRY_ID"); |
185 |
186 |
186 _LIT( KSQLGETIconIdFromEntryTable, "SELECT EN_ICON_ID AS Data FROM CA_ENTRY \ |
187 _LIT( KSQLGETIconIdFromEntryTable, "SELECT EN_ICON_ID AS Data FROM CA_ENTRY \ |