sqlite

SQLite and sub-sonic

Does Subsonic supports SQLite, if so can subsonic work with Win7 Phone ? ...

Why can't I parse an image from an XML file using this code from my iPhone application?

I'm having trouble importing image data which is encoded in an XML file. Following is the code of my class where I read the XML file and try to get the photo from the encoded data. edit 1 I haven't any errors but I always get an empty value on "artXML.photo".... Can anyone point out what might be going wrong? -(void)parser:(NSXMLPar...

User defined function for SQLite on iPhone.

Hi everyone! I'm working on the n'th application locating zip's. Everything works fine in PHP while I worked along the docu on OpenGeoDB. Now, I'm trying the implementation on the iPhone-SDK, but SQLite doesn't have the ACOS, SIN etc funcs. Can anybody point me to an example of how to expand the SQLite with userfunctions in order to use...

UITextField auto-suggest from a large database

Hi, I am trying to add suggestions for a UITextField. They show up as a UITableView below the text field that displays a few entries according to what the user is typing (like Google Suggest for example). The only method I tried so far is a select from an internal SQLite database. This works, but it is extremely slow as the database is...

SQLite update on select (or vice versa)

Is there a one-statement select-and-update (or update-and-select) method in SQLite? A trigger can invoke select, but that doesn't allow update to be used in an expression: CREATE TABLE id ( a integer ); CREATE TRIGGER idTrig AFTER UPDATE ON id BEGIN SELECT old.a FROM id; END; INSERT INTO id VALUES ( 100 ); INSERT INTO test VALUES ( (UP...

Problem with "Finalizing Cursor" error in custom CursorAdapter

I have a cursor adapter and the logcat is filled with above errors, as soon as I click on a view. I am already releasing the CursorAdapter's cursor in onDestroy(). Is there any way to get information about when the cursor was opened? ...

sqlite-fts3: custom tokenizer?

Does anyone here have experience with writing custom FTS3 (the full-text-search extension) tokenizers? I'm looking for a tokenizer that will ignore HTML tags. Thanks. ...

Is there anyway to generate a database diagram from a SQLite database?

For example, is there a way to import a SQLite db into Visio? Or some other tool that can generate a diagram? Can it be done using VS2010? ...

Changing package name but keeping database on Android

I've created an Android application which has a certain package name that I've been using personally for months now. I'm about to release it on the market, and I have to change the package name. This cannot be avoided. My issue is that the application has an SQLite database attached to it that I want to keep, but I know if I change the ...

How do I access something from a SQLite database on an iPhone?

I have a database that I recently converted from MySQL to SQLite. I have a PHP script that gets a string from a POST or GET Request and looks for that string and returns a value in that row. <?php require_once('../config.php'); $newNumber = $_REQUEST['new'] ; $tbl_name = 'roomNumbers'; $sql="SELECT * FROM $tbl_name WHERE new='$newNu...

Optional foreign key with django?

Hi, In my models I want to have an optional field to a foreign key. I tried this: field = models.ForeignKey(MyModel, null=True, blank=True, default=None) But i am getting this error: model.mymodel_id may not be NULL i am using sqlite edit: if it can help, here is the exception location: /usr/lib/python2.6/site-packages/django/d...

Can I get SQLite to string instead of unicode for TEXT in Python?

AFAIK SQLite returns unicode objects for TEXT in Python. Is it possible to get SQLite to return string objects instead? ...

Can't return row id 17 by getGeneratedKeys()

I'm using sqlite JDBC 0.56 and the table is created using fts3 MY table is created by stat.executeUpdate("CREATE virtual TABLE doc using fts3 (doc_name , doc_path);"); seems the problem is caused by this virtual table. I tried to insert a set of record into a database and return the generated key. But I find that when the key is bec...

Problem getting an integer from SQLite

Hi! I am working on an iPhone project where we need to fetch data from aa sqlite database. I have done this many times before, and everything works out fine. But now I am having problems fetching the value of an integer field (the primary key). The varchar fields I can fetch with: NSString *forfatter=[[NSString alloc] initWithUTF8Stri...

Packaging SQLite DB with my application.

I have created a SQLite database on my PC. I have imported it into my assets folder in the project directory. How do I access it from my Android application? ...

Rake db:migrate error "don't know how to build task"

I've got a table where I used integer on a field which needs decimal places, so I'm trying to create a migration which changes the field type from integer to float/real. My database is sqllite3 and I'm using rails3. I ran rails generate migration ChangeMeasureColumnOnIngredients to create the initial migration files, then updated th...

How to search for a substring in SQLite?

Whats the most efficient way to search for a sub string in SQLite? I'm looking at the LIKE operator. Do I have the right idea? Has this worked well for you? http://www.sqlite.org/lang_expr.html Thank You. ...

cursor position in a listview lost when move away from activity

I populate ListView with data from a Sqlite database using custom CursorAdapter. When user moves away from my activity and comes back later I loose the position in my cursor and the ListView is positioned to the first item again. When skipping startManagingCursor() it works as expected. How do I work around this? Here is a code snippe...

is it possible to migrate Data from iPhone to any Desktop SQL Data Base?

Hi I'm developing an app that stores data in the iPhone, but I need to know if it's possible to export the data (as an entities, tables, .txt or xls) to a desktop because I need the data to be readable on my Computer OR do I need to create a web site to do it??? by the way.. I'm still not sure what method is more effective for this kind ...

SQLite - inserting a string with newlines into database from csv file

All, I am trying to inject a long text entry into a SQLite database, in a TEXT field. This text has new lines in it (i.e. it spans multiple paragraphs). I can get the new lines to show up if I do the INSERT manually: INSERT INTO "LOGENTRY" VALUES(5,40,'PLACE','line1 line2 line4 ',1283990533315,'4A','TEXT','',NULL); but if I have ...