I have a login in my project but always when I open my app after I close it, have to login again. I use Firebase to authenticate, but I want something like: check if user is logged -> if not - open login, else - open my main activity" I don't know
I am creating an application in which i would like to know whether is it possible to show the list view inside a bottom sheet view .If so can anyone can tell me how i can do it because the examples which i have seen in bottom sheet shows only the sha
This question already has an answer here: iOS offline data storage tutorial 2 answers I am new for Swift iOS development. I want to store my data (name, image_path) locally while my app is not able to upload it (no internet connection etc). I have st
I would like to create a simple registration form for WINDOWS application. I am using SQLite database which can be embedded into the project as I need to create a .exe file and mail it to my friend. Now my registration form has 2 text boxes. textBox1
This question already has an answer here: When is SQLiteOpenHelper onCreate() / onUpgrade() run? 12 answers public static final String TABLENAME = "EMPLOYEES"; public static final String TABLE = "CUSTOMER"; public static final String[]
columnx 1425795755580/0 1425785965412/3 i have inserted milliseconds/noofdays in db in columnx.Now i want to retrieve that using the currenttime is equal to that milliseconds so for that i have written a query as follows. SELECT substr(reminder,0,14)
I have called a function returnCurrentNameById() by passing the id of the particular row. But it gives an error. String[] s1; public String[] returnCurrentNameById(int k) throws SQLException{ String[] columns = new String[]{ KEY_ID1, KEY_NAME, Key_DO
This question already has an answer here: When is SQLiteOpenHelper onCreate() / onUpgrade() run? 12 answers I'm making the app that stores a list of the user's purchases in a SQLite database in android. A problem I'm having is I can't delete any of t
I am writing an android app but using JUnit to test it out some of the more java-specific functionality before creating activities and the android-specific functions. As I write out the JUnit tests and execute them bit by bit, I am finding failures a
I search a lot, lots of about this. But little helps. The matter is the upgrade and downgrade of database. If just upgrade or downgrade, it's simple. when upgrade,modify or add tables(keep data,it is important), when downgrade, delete the known table
I have two Queries which are related to two identical tables (Column names and everything is same) Query1: "SELECT * FROM Notifications ORDER BY SUBSTR(DATE('NOW'), 0)>SUBSTR(DateToNotify, 0), SUBSTR(DateToNotify, 0)"; Query2: "SELECT *
I'm saving float data in sqlite trough in my aplicaton. The problem is that when I saving the value 99999.99 the sqlite is rounding it to 100000.00. And the same is happening when i try to save 999999.99, its rounding it to 1000000.00. What is happen
We are using Xamarin with SQLiteNet as ORM. In our data layer class we have the method below. filter = ri => ri.ItemVersioniId == itemVersionId; The method is getting the records matching the Id. If the lambda expression is hardcoded, instead of usin
My table is not being created because of a FOREIGN KEY syntax error but I cant seem to figure it out. I made sure I created the int first before I called the FK. Here's teh code for my class with the FK public class PlayerStatsDatabase { public stati
I am working in a project that features several C++ and a few C# components. I am currently working on a new C# component that needs to share data with a C++ component (there may be more components accessing this in the future). All components are ru
I have a column in SQLite of GUID type, I have tried a query like this, and it returns no error, but the row is not deleted DELETE FROM MyTable WHERE Id='4ffbd580-b17d-4731-b162-ede8d698e026'; In SQLite Browser the Id values look like binary values,
I have created database in SQLiteOpenHelper class. I've also done insertion in database in Button click event in other activity(InsertActivity.java). Now, when i display data on listview then two same entry generated. How to display distinct record i
I have an App in my Device, that contains database, if I update that app from the App Store, then database of App will be updated or it uses the same database of previous App.If you stored your data in NSDocumentDirectory or NSLibraryDirectory, your
I load data from internet to build the listview, and put a star icon for each row. If user checked the star, I would save the entire row data into sqllite databse. My question is that how can I know if one item has been added to favorites before to m
For development , sometimes we need for a faster programming , the SQLite database state of our programs . But i can only extract database if it's on emulator , not mobile . Then my exactly question is ¿Is there a way to see the android sqlite db or
I am using the query functions in order to build the SQL queries for my tables. Is there a way to see the actual query that is run? For instance log it somewhere? So far the best I could do was to have a look at the cursor's member mQuery using a bre
I am performing a simple delete of a ormlite object. The code is below. But no matter what, the object never get deleted. Dao<Subscription, Object> dao = helper.getSubscriptionDataDao(); dao = helper.getSubscriptionDataDao(); QueryBuilder<Subscri
I've found this from this link: http://www.sqlite.org/datatype3.html 1.2 Date and Time Datatype SQLite does not have a storage class set aside for storing dates and/or times. Instead, the built-in Date And Time Functions of SQLite are capable of stor
I am using FMDB to deal with my database which works fine. The app uses a background thread which is doing some work and needs to access the database. At the same time the main thread needs to run some queries on the same database. FMDB itself has a
I have some data. 224,000 rows of it, in a SQLite database. I want to extract time series information from it to feed a data visualisation tool. Essentially, each row in the db is an event that has (among other things not strictly relevant) a time-da
I'm working with Datamapper which allows you to specify either a path to a database file on your system or simply the string "memory" and then an "in-memory" database is used. However, I have no idea what this means. Is an "in-mem
I created a table in Sqlite by using the CREATE TABLE AS syntax to create a table based on a SELECT statement. Now this table has no primary key but I would like to add one. Executing ALTER TABLE table_name ADD PRIMARY KEY(col1, col2,...) gives a syn
I'm working in Microsoft Visual C# 2008 Express with Sqlite. I understand that an apostrope (') in my text has problems in a query. My problem is that I thought I could replace it with \'. It doesn't seem to be working... Here's a parred down example
I am playing around with getting some basic stuff to work in Python before i go into full speed dev mode. Here are the specifics: Python 2.5.4 PyQt4 4.4.3 SqlAlchemy 0.5.2 py2exe 0.6.9 setuptools 0.6c9 pysqlite 2.5.1 setup.py: from distutils.core imp
I've done a bit of reading related to the concurrency issues with sqlite, but I don't see how they'd apply to Django since it's inherently single threaded. I'm not using any multiprocess modules either. I have absolutely no experience with concurrent