You are storing the dates in the SQL database as text strings, but then asking SQL to return values between to limits and expecting it to interpret those limits as dates when it hasn’t been told that they are dates and wouldn’t know how to interpret the text format as a date if it did … Read more
The table name in the INSERT is wrong. And the column list must match the values list. Try INSERT correct table name (target columns) Values (vales for each column). Additionally if you omit any columns the insert will fail unless they have defaults. solved Why does insertion command is giving an error about new operator? … Read more
You are missing a closing paren on this line: connector.execute(”’update DATAGERMANY set title_abbreviation_langid=? , title_reliability_langid=? where id_db == ? ”’,(lan[-2], lan[-1])) # added paren here I added a closing paren, your code should be ok now. 4 solved Getting Syntax Error where none was before
Try parametrizing your query; all you should provide is date and let RDBMS do its work (formats, representation etc. included) // using – do not forget to Dispose (i.e. free resources) using (SQLiteCommand command = new SQLiteCommand(databaseConnection)) { // Do not build query, but parametrize it command.CommandText = @”update credits set lastDate = @prm_Date where … Read more
You can use Gson but you need to add Gson to your dependencies. Parse array to a string, store it in database as a string and convert it back to double 2D array when you need the array. Gson gson = new GsonBuilder().create(); double[][] multiDoubleArray = new double[][]{{1.0, 2.0, 3.0}, {4.0, 5.0, 6.0}}; // to … Read more
You are overcomplicating things with the use of the aggregate function MAX(). This part of your code: EXISTS ( SELECT 1 FROM ( SELECT MAX(TourCompletionDateTime) AS TourCompletionDateTime FROM Details WHERE TourCompletionDateTime < ‘2022-07-26T09:36:00.730589Z’ ) WHERE TourCompletionDateTime IS NOT NULL ) is equivalent to just: EXISTS ( SELECT 1 FROM Details WHERE TourCompletionDateTime < ‘2022-07-26T09:36:00.730589Z’ ) … Read more
build the Intent alike this: Intent intent = new Intent(activity, UserActivity.class); Bundle extras = new Bundle(); extras.putString(“Email”, email.getText().toString().trim()); extras.putString(“Name”, name_db); extras.putString(“User_Id”, user_id_db); extras.putString(“Contact”, contact_db); intent.putExtras(extras); startActivity(intent); while the List<String> contactNumber = db.getContactNumber() already seems unfortunate. it might be rather elegant to return some class Contact (to be defined) instead of a List<String> … so that … Read more
According to your code and stacktrace, you didn’t add a space ” ” between the CREATE TABLE and TABLE_NAME. Add a ” ” after TABLE_NAME too. solved Why does the application crash when I press the button to insert the values in the table? [duplicate]
You can improve speed for Multiple/Batch Database Inserting or Replacing operation using concept of transaction and compileStatement so your query will be compiled only once. For Example: db.beginTransaction(); try { String sql = “Insert or Replace into Items (itemNumber, description,unitOfMeasure, weight) values(?,?,?,?)”; ArrayList<ItemMaster> itemsList = // Retrieve your items list here for(int i=0;i<itemsList.size();i++) { SQLiteStatement … Read more
Since you are not going to keep any records offline after pushing to server. you can just delete all the records of the table after the successful API call. public void deleteAll(String tableName){ SQLiteDatabase db = this.getWritableDatabase(); db.execSQL(“DELETE FROM “+tableName); db.close(); } if you plan to keep records offline you can have a separate column … Read more
From you log i see Caused by: java.lang.NullPointerException 06-14 19:12:06.723: E/AndroidRuntime(5930): at com.tanzanite.operasoft.database.DataBaseHelper.fetchdata(DataBaseHelper.java:224) 06-14 19:12:06.723: E/AndroidRuntime(5930): at com.tanzanite.operasoft.activity.Sw_LoginScreenActivity.onCreate(Sw_LoginScreenActivity.java:49) So, you need use debuger and set breackpoints on Sw_LoginScreenActivity.java – on line 49 (i think there you try to fetch data) DataBaseHelper.java – on 224 – there you try to fetch data from myDataBase public Cursor … Read more
A cursor allows you to access the query result set. The query result set does not change if you insert new data after querying. Hence the cursor count stays at 0. You need to query your database again to see the new data. The NPE seen as warning in your System.err log is not produced … Read more
As said above you have to use an Adapter I would create your own and add this to you ListView. This is roughly how you would do it, code bit rough as type it straigh into text editor here: public class ContactListAdapter extends ListAdapter<String> { private final List contacts; //Call to super to set up … Read more
What do you mean by “calculate data” Do you mean normal operator like +,-,*,/ If yes, you have to SELECT the data from SQLite first. If no, please clarify your question. 2 solved How to calculate data from table SQLite Android Dev [closed]
you can use the following code :- ContentValues cv = new ContentValues(); cv.put(“Field1″,”Bob”); //These Fields should be your String values of actual column names cv.put(“Field2″,”19”); cv.put(“Field2″,”Male”); myDB.update(TableName, cv, “_id>=120 and _id<=150”, null); solved Android Sqlite update between