Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
swdev:android:database_sqlite [2018/05/01 16:08]
smayr [MainActivity] 		swdev:android:database_sqlite [2018/05/02 20:30] (current)
smayr [Database Utils]
Line 222: Line 222:
         //String selection = DbContract.TeamEntry.COL_NAME + " = ?";         //String selection = DbContract.TeamEntry.COL_NAME + " = ?";
         //String[] selectionArgs = { "My Team" };         //String[] selectionArgs = { "My Team" };
 +        String selection = null;         // no filters
 +        String[] selectionArgs = null;   // no filters
  
         // How you want the results sorted in the resulting Cursor         // How you want the results sorted in the resulting Cursor
Line 230: Line 232:
                 DbContract.TeamEntry.TABLE_NAME,   // The table to query                 DbContract.TeamEntry.TABLE_NAME,   // The table to query
                 projection,             // The array of columns to return (pass null to get all)                 projection,             // The array of columns to return (pass null to get all)
-                //selection,              // The columns for the WHERE clause +                selection,              // The columns for the WHERE clause 
-                null, +                selectionArgs,          // The values for the WHERE clause
-                //selectionArgs,          // The values for the WHERE clause +
-                null,+
                 null,                   // don't group the rows                 null,                   // don't group the rows
                 null,                   // don't filter by row groups                 null,                   // don't filter by row groups
Line 270: Line 270:
         //String selection = DbContract.TeamEntry.COL_NAME + " = ?";         //String selection = DbContract.TeamEntry.COL_NAME + " = ?";
         //String[] selectionArgs = { "My Team" };         //String[] selectionArgs = { "My Team" };
 +        String selection = null;         // no filters
 +        String[] selectionArgs = null;   // no filters
  
         // How you want the results sorted in the resulting Cursor         // How you want the results sorted in the resulting Cursor
Line 279: Line 281:
                 projection,             // The array of columns to return (pass null to get all)                 projection,             // The array of columns to return (pass null to get all)
                 //selection,              // The columns for the WHERE clause                 //selection,              // The columns for the WHERE clause
-                null, 
                 //selectionArgs,          // The values for the WHERE clause                 //selectionArgs,          // The values for the WHERE clause
-                null, 
                 null,                   // don't group the rows                 null,                   // don't group the rows
                 null,                   // don't filter by row groups                 null,                   // don't filter by row groups
swdev/android/database_sqlite.1525205303.txt.gz · Last modified: 2018/05/01 16:08 by smayr
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International


  • Show page
  • Old revisions
  • Backlinks
  • Recent Changes
  • Media Manager
  • Sitemap