You can just instantiate your database class in your activity OpenHelper mOpenHelper = new OpenHelper(this); And create a method in your db class to create your tables public void createTable(String nomelistafinal ) { final SQLiteDatabase db = getWritableDatabase(); db.execSQL(“CREATE TABLE ” + nomelistafinal + ” (codigo text not null) “); db.close(); } 0 solved How … Read more
Try this : listview.setOnItemClickListener(new AdapterView.OnItemClickListener() { @Override public void onItemClick(AdapterView<?> parent, final View view, int position, long id) { //your code } }); 1 solved how to listview rows should be clickable? [closed]
Check this error here. Process: com.example.rockodile.contactsappliaction, PID: 5549 java.lang.IllegalStateException: Couldn’t read row 0, col -1 from CursorWindow. Make sure the Cursor is initialized correctly before accessing data from it. at android.database.CursorWindow.nativeGetString(Native Method) at android.database.CursorWindow.getString(CursorWindow.java:438) at android.database.AbstractWindowedCursor.getString(AbstractWindowedCursor.java:51) at com.example.rockodile.contactsappliaction.UserSQL.getContactList(UserSQL.java:105) at com.example.rockodile.contactsappliaction.MainActivity.onClick(MainActivity.java:52) Update. public ArrayList<HashMap<String, String>> getContactList() { //Open connection to read only SQLiteDatabase db = dbHelper.getReadableDatabase(); … Read more
Most modern databases including SQLite support rapid mass deletes. In practice there is not much to gain from dropping the table instead. solved Clear all items from a table in Sqlite3 IPHONE? supported? DROP TABLE? DELETE FROM TABLA_1? [duplicate]
It looks like you are trying to build a string. For that you can use snprintf. char sql[64]; int size = snprintf(sql, 64, “SELECT %lf/(%lf * %lf);”, peso, altura, altura); Note that I kept the return value. This is to handle any future error where you modify a statement in a way that might result … Read more
Your class member model from class InputTab has never initialized. Therefore, you got a NPE at line model.requery();. That’s why you saved your data, but right after that, you got a NPE. You don’t need any Cursor in this class and, of course, you don’t need to requery() anything. 2 solved Nullpointer Exception in SQL, … Read more
Here’s a great answer from the DuckDB people: Two functions will do the trick for you! String_split, and unnest. Unnest is a special function that takes lists and creates a separate row for each element. With lists_split_into_rows as ( select col1, unnest(string_split(col2, ‘ ‘)) as new_column from my_table ) Select new_column, count(*) as my_count from … Read more
You have an error concatenating your SQL statement: String selectQuery = “SELECT * FROM ” + TABLE_MURIDD + “ORDER BY” + COLUMN_NOMOR + “ASC”; should be: String selectQuery = “SELECT * FROM ” + TABLE_MURIDD + ” ORDER BY ” + COLUMN_NOMOR + ” ASC”; EDIT: (Thanks to Michael Dogg) A better way of protecting … Read more
try this, public void updateQty(Integer qty,String bookId) { int originalQty = getQuantity(bookId); int updateQty = originalQty – qty; try{ SQLiteDatabase db = this.getWritableDatabase(); String rawQuery = “update ” + BOOKS_TABLE + ” set ” + KEY_QTY + ” = ” + updateQty + ” where ” + KEY_BOOK_ID + ” = ‘” + bookId + … Read more
From your question I understand that you need to change the image on each button click. If I’m correct then change the changenext method like: -(IBAction)changenext { static int j = 0; if (j > 10) { j = 0; } [self Readthesqlitefile:j]; j++; } The above method will change the image on each button … Read more
Your b is null. You didn’t put anything in intent and you are fetching from intent. Put “score” in intent in SaveDataActivity then fetch from intent in ResultActivity. How to use putExtra() and getExtra() for string data 2 solved Android :: SQLIte Db don’t insert the datas
Replace your below code cursor.moveToFirst(); Note newNote=cursorToNote(cursor); cursor.close(); return newNote; With if (cursor != null && cursor.moveToFirst()) { Note newNote=cursorToNote(cursor); cursor.close(); return newNote; } else { return null; } 4 solved Android cursor out of bounds exception
Define you connection as below: import sqlite3 conn = sqlite3.connect(‘musicten.db’) 2 solved creating database based on two dataframes
You can create a Service an use it to add row when you only want (e.g. on boot completed, once per week, etc., etc.). Here you have good tutorial, how to create Service in Android OS. Read also more about AlarmManager to start your Service in specific schedule. Calendar cal = Calendar.getInstance(); Intent intent = … Read more
To get value or multiple values you need a cursor, see the following function (that return the first value it’s perfect to get id’s, for example): public String getSingular_Value_InTransaction(String query){ //Declaration of variables Cursor a1 = null; try{ a1 = database.rawQuery(query,null); a1.moveToFirst(); if(a1.getString(0) != null){ String result = a1.getString(0); a1.close(); return result; } else{ a1.close(); … Read more