UINT ACTION_CCPSearch(MSIPACKAGE *package) { static const WCHAR query[] = { 's','e','l','e','c','t',' ','*',' ', 'f','r','o','m',' ', 'C','C','P','S','e','a','r','c','h',0}; MSIQUERY *view = NULL; UINT r; if (check_unique_action(package, szCCPSearch)) { TRACE("Skipping AppSearch action: already done in UI sequence\n"); return ERROR_SUCCESS; } else register_unique_action(package, szCCPSearch); r = MSI_OpenQuery(package->db, &view, query); if (r != ERROR_SUCCESS) return ERROR_SUCCESS; r = MSI_IterateRecords(view, NULL, ITERATE_CCPSearch, package); msiobj_release(&view->hdr); return r; }
static BOOL check_column_exists(MSIDATABASE *db, LPCWSTR table, LPCWSTR column) { MSIQUERY *view; MSIRECORD *rec; UINT r; static const WCHAR query[] = { 'S','E','L','E','C','T',' ','*',' ','F','R','O','M',' ', '`','_','C','o','l','u','m','n','s','`',' ','W','H','E','R','E',' ', '`','T','a','b','l','e','`','=','\'','%','s','\'',' ','A','N','D',' ', '`','N','a','m','e','`','=','\'','%','s','\'',0 }; r = MSI_OpenQuery(db, &view, query, table, column); if (r != ERROR_SUCCESS) return FALSE; r = MSI_ViewExecute(view, NULL); if (r != ERROR_SUCCESS) goto done; r = MSI_ViewFetch(view, &rec); if (r == ERROR_SUCCESS) msiobj_release(&rec->hdr); done: msiobj_release(&view->hdr); return (r == ERROR_SUCCESS); }
UINT ACTION_CCPSearch(MSIPACKAGE *package) { static const WCHAR query[] = { 's','e','l','e','c','t',' ','*',' ', 'f','r','o','m',' ', 'C','C','P','S','e','a','r','c','h',0}; MSIQUERY *view = NULL; UINT r; r = MSI_OpenQuery(package->db, &view, query); if (r != ERROR_SUCCESS) return ERROR_SUCCESS; r = MSI_IterateRecords(view, NULL, ITERATE_CCPSearch, package); msiobj_release(&view->hdr); return r; }
UINT ACTION_AppSearch(MSIPACKAGE *package) { static const WCHAR query[] = { 'S','E','L','E','C','T',' ','*',' ','F','R','O','M',' ', 'A','p','p','S','e','a','r','c','h',0}; MSIQUERY *view; UINT r; if (msi_action_is_unique(package, szAppSearch)) { TRACE("Skipping AppSearch action: already done in UI sequence\n"); return ERROR_SUCCESS; } else msi_register_unique_action(package, szAppSearch); r = MSI_OpenQuery( package->db, &view, query ); if (r != ERROR_SUCCESS) return ERROR_SUCCESS; r = MSI_IterateRecords( view, NULL, ITERATE_AppSearch, package ); msiobj_release( &view->hdr ); return r; }
'`','_','C','o','l','u','m','n','s','`',' ','W','H','E','R','E',' ', '`','T','a','b','l','e','`','=','\'','%','s','\'',' ','O','R','D','E','R',' ', 'B','Y',' ','`','N','u','m','b','e','r','`',0 }; r = TABLE_CreateView(av->db, szColumns, &columns); if (r != ERROR_SUCCESS) return r; if (check_column_exists(av->db, av->colinfo->table, av->colinfo->column)) { columns->ops->delete(columns); return ERROR_BAD_QUERY_SYNTAX; } r = MSI_OpenQuery(av->db, &view, query, av->colinfo->table, av->colinfo->column); if (r == ERROR_SUCCESS) { r = MSI_IterateRecords(view, NULL, ITERATE_columns, &colnum); msiobj_release(&view->hdr); if (r != ERROR_SUCCESS) { columns->ops->delete(columns); return r; } } r = columns->ops->add_column(columns, av->colinfo->table, colnum, av->colinfo->column, av->colinfo->type, (av->hold == 1)); columns->ops->delete(columns);