I'm currently developing a Field-Service application that stores data in the local sqlite database on an android device. At some point, usually after completing the data collection rounds, the local sqlite db is to be synchronized to a remote sybase db on the server. Any suggestions as to how this could be achieved or engineered as a so...
I've been using SQLite databases for development for a while now and I thought it would be useful to just view the contents of the generated db file. Are there any good tools out there for viewing SQLite db files and/or tools for running queries against them? ...
I am creating a web application that is accessing a SQLite database in the server. I also have "clients" that updates this same database. As we know SQLite locks the entire database during INSERTs which are done by the clients and the web application is also trying to make some UPDATEs at the same time. So my problem now is about concurr...
I have a WPF Application using Fluent NHibernate 1.0 RTM and System.Data.SQLite 1.0.65 that works fine in .Net 3.5. When I try to upgrade it to .Net 4.0 everything compiles but I get a runtime error where the innermost exception is this: `The IDbCommand and IDbConnection implementation in the assembly System.Data.SQLite could not be fou...
Hi is there a way to get sine and cosine of a value in sqlite query in iphone sdk? when ever i tried to use sin() in my query sqlite reported that no such function exists. Any help would be much appreciated! Thanks Saurabh ...
I am using fabulous LinqPad and its Sqlite driver. 1) Is there a way to obtain Sqlite version information by executing say "select version"? 2) Which driver specific connection string should I use to enable foreign key support in Sqlite? ...
-(IBAction)EnterButtonPressed:(id)sender { const char *sql = "SELECT AccessCode FROM UserAccess"; double result = ([Password.text doubleValue]); if(sql == result ) { NSLog(@"Correct"); } else { NSLog(@"Wrong"); } } ...
With this code: var db = google.gears.factory.create('beta.database'); db.open('cominar'); db.execute('CREATE TABLE IF NOT EXISTS Ajax (AJAX_ID INTEGER PRIMARY KEY AUTOINCREMENT , MODULE TEXT, FUNCTION TEXT, CONTENT_JSON TEXT);'); db.execute('VACUUM;'); // nettoye la DB I'm trying to clean the database (VACUUM) at each initialisation ...
My google search skills have failed me, and I am not a database expert by any means! I have a very simple database schema that looks like this: properties_id in the CANDY table is a foreign key to id in the EXPENSIVE_PROPERTIES table. The properties_id is only set if the candy is expensive. If it is expensive, then the correspondin...
I am creating an exercise app that will record the weight used and the number of "reps" the user did in 4 "Sets" per day over a period of 7 days so the user may view their progress. I have built the database table named FIELDS with 2 columns ROW and FIELD_DATA and I can use the code below to load the data into the db. But the code has ...
Hi guys, this is an SQL question and don't know which type of JOIN, GROUP BY etc. to use, it is for a chat program where messages are related to rooms and each day in a room is linked to a transcript etc. Basically, when outputting my transcripts, I need to show which users have chatted on that transcript. At the moment I link them thro...
I would like to implement or use functionality that allows stepping through a Table in SQLite. If I have a Table Products that has 100k rows, I would like to retrive perhaps 10k rows at a time. Somthing similar to how a webpage would list data and have a < Previous .. Next > link to walk through the data. Are there select statements t...
I am trying to rename a field in my database through SQLite.net and am getting a syntax error. My SQL that I have tested is: UPDATE candy SET name="Godiva" WHERE name="Sees"; and that works fine. I am using an SQLiteCommand with a CommandText of: UPDATE candy SET @field_name=@new_name WHERE @field_name=@old_name; and my code snipp...
Today I use SQLite and send a database-file with the project. However I want the database to be created when the user first starts the software. Is there a way to copy the code needed to create a database based on the existing database? The problem is that when a user downloads a new version he might be tricked into copying over his ...
Hi, We are using AsyncTasks to access database tables and cursors. Unfortunately we are seeing occasional exceptions regarding the database being locked. E/SQLiteOpenHelper(15963): Couldn't open iviewnews.db for writing (will try read-only): E/SQLiteOpenHelper(15963): android.database.sqlite.SQLiteException: database is locked E/SQLit...
I always take precautions regarding SQL INJECTION ATTACKS when data is saved between someone's iPhone and a remote database on the cloud. But is it also necessary to do the same... when just saving data (using sqlite) from someone's cell phone, to a database that's just on their own phone? What's the worse they can do? Delete their ow...
UPDATE In the last update I could use SQLite for unit testing but not in an application run. That problem has now been resolved by modifying config to allow [loading from a remote assembly](http://msdn.microsoft.com/en-us/library/dd409252(VS.100.aspx) <runtime> <loadFromRemoteSources enabled="true"/> </runtime> in addition to ena...
Hello, I am learning Rails and have created a work-in-progress app that does one-word searches on a database of shortcut keys for various programs (http://keyboardcuts.heroku.com/shortcuts/home). The search method in the Shortcut model is the following: def self.search(search) search_condition = "%" + search + "%" find(:all, :cond...
What is the cause of following error: QSqlDatabasePrivate::database: unable to open database: unable to open database file Error opening database? Code is 100% correct, this message appeared when I have reinstalled Windows, Python and PyQt. EDIT: I have "read-only" flag in folder with .db file properties. It stays gray (half-checked) w...
-(IBAction)ButtonPressed:(id)sender { const char *sql = "SELECT AccessCode FROM UserAccess"; NSString *sqlns; sqlns = [NSString stringWithUTF8String:sql]; if([Password.text isEqual:sqlns]) { NSLog(@"Correct"); } else { NSLog(@"Wrong"); ...