Hello, I wish to pull data from a large SQLite database into Excel. I'll want to do so quite interactively so don't want to export CSVs or anything like that. I have seen the sqliteodbc website on ch-werner.de but does that work with Excel 2007? What are the best options? Thanks. ...
What does the ? character in this SQL query mean? $res = $dbConn->fetchPairs('SELECT name FROM tree where parent = ?',$key); ...
SqLite is widely pitched as zero install, however I am having problems understanding how I can write data from an asp web form to an sqlite database without installing a dll. Am wondering if you could point me to some reference as to how to configure sqlite on an ASP server so I can connect to an sqlite database. In addition is there a...
Hello, What happens with the NSUserDefaults values and the SQLite database after updating the application in the appstore? Are they deleted or reseted or happens nothing with them? Alex ...
I need to match on a date using the LIKE operator. The date should be in current user's local format, not in the general format. So I use the strftime function like this: WHERE strftime('%d.%m.%Y %H:%M', createdDate, 'localtime') LIKE '%{searchTerm}%' Unfortunately this works only for fixed format '%d.%m.%Y %H:%M'. But I want to use ...
I am thinking of using SQLite as a backend DB for a C++ applicatiojn I am writing. I have read the relevant docs on both teh trolltech site and sqlite, but the information seems a little disjointed, there is no simple snippet that shows a complete CRUD example. I want to write a set of helper functions to allow me to execute CRUD action...
So, I'm working on a project that uses the acts_as_taggable_on_steroids gem. I've installed it as a gem, and it works great and all. Here's where I'm running into problems though - I want to generate a list of the top 25 used tags, and the number of times they've been used across all taggable items. Well, as it happens, acts_as_taggable...
Hey guys I have a xml file that has a lot of info that I would like it to be in sqlite tables. I am wondering if there's any tool, app to transform xml to sqlite. By the way I am on OS X and I need the info for an iPhone app, so I can also take scripts or some source code to make the trasmformation. Best Regards. Carlos Vargas ...
My Android app is using a database through an API packaged in an external JAR. Since the JAR is opening/updating/closing the SQLite database file, do I need to make sure it uses its own package name instead of my own? Im getting errors where it fails to open the database file and Im guessing its because the package name Im telling it to ...
I have a sqlite DB created by my CoreData model automatically, but my app will not give the user the ability to write data into it, instead I wanted to pre-populate it with all the data the program needs. My problem is that the sqlite DB created by CoreData has unknow tables and fields that where not present in my model. Is there anywa...
Hi, iam trying to locate the database files on my nexus device.. is there anyway of doing it without rooting the device? thanks ray. ...
Hello, I am working on an iPhone app that uses a sqlite database. The app downloads data off of the Internet in a background thread with the UI in the main thread. The background download thread can preform INSERT, UPDATE, and SELECT on the database. The UI layer can also interact with the database by doing UPDATEs and SELECTs. If I...
This is a dll sold by a company called ez tools software. Am wondering if you've used this component and what your experience was like in your dealing with them. The company website is somewhat unconventional but perhaps this is to be expected considering the underlying product is open source. Would really appreciate your opinion on t...
Is there a way for me to create a UITextView/UITextField* that on getting the latitude and longitude of the current location the texf field is autofilled automatically. I don't want to use Google Maps database, I already have my own that is customised that contains 1,265 entries. On getting a location that is not in the database, the...
i created the database like this db.execSQL("CREATE TABLE "+TABLE_NAME+" (" +_ID+" INTEGER PRIMARY KEY AUTOINCREMENT," + TITLE+" TEXT UNIQUE," + PUBLISHED+" DATETIME," + CONTENT+" TEXT," + RATERS+" TEXT," + VIEWCOUNT+" TEXT," + THUMBNAIL+" TEXT," + FAVCOUNT+" TEXT," + FAVSTAT+" INTEGER," + LI...
ok lets assume i have a table now it has only two rows in it and i dont want anyone to add any more rows to it? it can be accessed by c sharp but it should not be openable using SQLite admin or any other db manager , is that possible?? I dont want the user to add another row outside c sharp can this be done???? triggers??? ...
Here is the scenario. In your function you're executing statements using a cursor, but one of them fails and an exception is thrown. Your program exits out of the function before closing the cursor it was working with. Will the cursor float around taking up space? Do I have to close the cursor? Additionally, the Python documentation...
I want to make a blackberry app. which will store audio and video files into the sqlite database. Does blackberry have a special api for this? (special classes for byte[]) Can I store files into sqlite on blackberry? ...
I have two processes: Writes to two tables every second (ish) Reads from said tables periodically I know that with SQLite, any writes lock the whole database and so sometimes the second process can fail with a locked database. Is there anything you can suggest that would completely remove the need for these two processes to touch th...
I am using sqlite, while using Statement.executeBatch(), the jvm is crashing and giving following fatal error, There is no problem while using PreparedStatement.executeBatch(). I have created separate connection and Statement object from each update in database. The error is... # A fatal error has been detected by the Java Runtime Envi...