I have an uninstall issue with an app which is using sqlite: during installation a blank sqlite db is created in [CommonAppData]\MyApp\mydb.sqlite, e.g. C:\Documents and Settings\All Users\Application Data\MyApp\mydb.sqlite. When I uninstall my app it can't delete the sqlite db, despite it removing the applications that are connectng to...
I have a separate class that includes the database, a cursor, and all the accessor methods for database information. I import the cursor into all the classes that update or use the database. However, I get a runtime error whenever I try to start an intent that uses the database. Any ideas on what might be happening? ...
I'm trying to do what seems like it should be a simple SQL operation, but I'm just not finding the right syntax to do it quickly. I'm using SQLite. The basic problem is that I have a table whose primary key is (objUid, time). It contains the columns objUid, time, and frame. For the purposes of this question, frame is an opaque value....
Hi, I would like to execute some kind of subquery with my fetchedresultscontroller. I've got a set of items which have a flag like "viewed" or "not viewed". Is it possible to switch between these items... Sure I could do a complete refetch but this takes some time. Is there a better way for doing this? Many thanks! ...
I want to include an updated SQLite database with a new version of an app. My app copies the database file into the Documents directory on startup. What is the best way to do this kind of versioning (besides using Core Data)? I'm assuming that either a special 'version' table in the SQLite file or a small text file with the version numb...
So I'm trying to rough out a design in Ruby, and so I ran ruby script/generate scaffold item name:string description:text model:string manufacturers_name:string category:string weight:decimal upc:string ebay_cat_id:string blacklist:bool in_discovery:bool archived:bool The only problem is that none of the bool fields are on the model....
Say I have a table with an ID field, and I have a local array (in any language, php or objective c or basic or whatever) of eligible IDs. I want to delete any record in which the ID field does not match any of the eligible IDs in my array. Is there any way to do this in a single SQL query? Can you pass an array into SQL and basically sa...
I've checked the NotesDbAdapter example, and I noticed that is for a single table only. (notes) 1) I am wondering how would this be done for multiple tables? For example I have 3 tables for now. How would I handle all the upgrade, fetch, delete from these three tables? 2) I see defined properties for the table columns public static ...
I have a component that i want to store to an SQLite database. public class Comp : Entity { public virtual DateTime TimeStamp { get; set; } public virtual String Name { get; set; } } public class CompMap : ClassMap<Comp> { public CompMap() { Id(x => x.Id); Map(x => x.TimeStamp); Map(x => x.Name);...
I open a sqlite database and use rawquery to get data. But the log.e show the information: android.database.sqlite.SQLiteException: no such table: types: But, I really have this table. And i also try to use the other sql ,But also get the error message such as android.database.sqlite.SQLiteException: no such table: malls: I am ...
hey , I want to cache google maps, and put them into the memory, using sqlite DB,so that I don't have to always use the internet connection! is that possible? and if it is possible I would like to know how? thanks ...
Hello, for a traffic accounting system I need to store large amounts of datasets about internet packets sent through our gateway router (containing timestamp, user id, destination or source ip, number of bytes, etc.). This data has to be stored for some time, at least a few days. Easy retrieval should be possible as well. What is a go...
Currently I have a pysqlite db that I am using to store a list of road conditions. The source this list is generated from however is buggy and sometimes generates duplicates. Some of these duplicates will have the start and end points swapped but everything else the same. The method i currently have looks like this: def getDupes(self)...
Ok, so I have an excel spreadsheet that contains data that I would like to copy directly into an SQLite db using Menial Base, a db editor. I have tried a number of different methods such as trying to convert from .csv and .txt extensions, and nothing is working the way I need it to, so I am now resorting to Automator. From what I underst...
My sqlite3 database contains a "collate" column-constraint. I've placed it in the schema for the table, to prevent accidentally neglecting to use the necessary collation. However this means when running sqlite3 from the command line, and not from my Python code, the collation referenced in the schema is not present, and I'm unable to use...
I have a high scores table in my game. When the game is over, the score is shown on the screen and it gets inserted into the high scores table. I want to know how to compare the new score to the highest score in the table so I can let the user know if they achieved a high score. Below I included the code I use to update and insert the ...
I have NSTableView with two columns, and i wanna fill them entries from SQLite database. this method is make query for table -(void)getPersons { NSString *file = [[NSBundle mainBundle] pathForResource:@"persons" ofType:@"db"]; sqlite3 *database = NULL; if (sqlite3_open([file UTF8String], &database)==SQLITE_OK) { ...
Right now, I'm running into issues trying to implement a FilterQueryProvider in my custom SimpleCursorAdapter, since I'm unsure of what to do in the FilterQueryProvider's runQuery function. In other words, since the query that comprises my ListView basically gets the rowID, name, and a third column from my databases's table, I want to b...
I am prototyping an idea on the iPhone but I am at the SQLite vs CoreData crossroads. The main reason is that I can't seem to figure out how to do grouping with core data. Essentially I want to show the most recent item posted grouped by username. It is really easy to do in a SQL statement but I have not been able to make it work in co...
I need to display a single list, ordered by date which contains different types of data, images, video and whatnot. I guess you could have one separate table for each type and the use something like FULL OUTER JOIN (simulated as sqlite doesn't support it) and sort on date. But this would be complicated because I still need to have uniqu...