The SQLite.ttinclude (for VB) should have tbl.Schema=""; in the LoadTables procedure, otherwise the Struts.tt will not compile Running transformation: System.ArgumentNullException: Value cannot be null. Parameter name: objectToConvert at Microsoft.VisualStudio.TextTemplating.ToStringHelper.ToStringWithCulture(Object objectToConvert...
Hi all, I'm wondering whether there is a bossibility to export some selected data from my rails mysql db to a other sqlite db. The aim is to send that sqlite file directly to my iPhone application... That way I don't have to do a lot of xml integration in the iPhone app. That seems to be very slow... Markus ...
After reading the docs, it seems the the function sqlite3_column_count does all the same, but doesn't have the restrictions that sqlite3_data_count has. Why would I ever want to use sqlite3_data_count over sqlite3_column_count? thanks! ...
The goal: refresh database from XML data The process: Start transaction Delete all existing rows from the tables Per each main element of parsed XML insert row into main table and get PK Per each child of the main element insert record into 2nd table providing FK from the previous step Commit transaction Pretty standard stuff as far...
I have an unfinished application, but I want to address now the future update of it. Suppose my app was upgraded, so when starts, detects that the database schema is outdated. So for each table has to update according to version number to the new schema while preserving all data. I've read somewhere that on Android the SQLite database ...
Strangely my app works in the simulator. When run in debug on my iTouch, I get the error , "Unknown Error" when I try to run a "Update" sql command. I can read from the SQLite db fine though. The database is in the root and it's being found as the open() command works. I'm using MonoTouch but think it may be a more general error. The ...
I can display images in a tableview but can't transfer the application on to the iPhone. I am obviously not releasing some memory but can't figure out what. I have approx 30 pix that are each 250k in size. I have tried storing the images in SQLite as well as the filesystem and get the same problem for both; works in the simulator but ...
Is it possible to use Enterprise Library logging application block to log to a sqlite database? The standard Database TraceListener uses stored procs so I guess I'll need to create a Custom tracelistener or find one someone else has already done. Does anyone know of an implementation of this, or a similar sort of thing I could use as a ...
I have an sqlite table in my game that keeps track of scores. How do I make one of the columns track scores in ascending order instead of descending order? ...
How come in my code when i use @"select Score from tblMed order by Score desc limit 10" everything works fine, but when I change "desc" to "asc" the scores don't show up??? ...
Hi, there. I am trying to implement a feature into my app to copy the current database unto the sdcard. Are there any tutorials or code snippets to achieve this. I've already looked at this site, http://mgmblog.com/2009/02/06/export-an-android-sqlite-db-to-an-xml-file-on-the-sd-card/ ... but I wont be able to import the data with this m...
I have an sqlite table that shows scores from different game modes. In one of the columns, I don't want the score to show up unless the user reaches the final 5th level, but I also don't want it to be recorded as a 0 either. I want it to be as if the game was never played. No score recorded at all. Here's what I have.... if(appDeleg...
I'm using Mac OS X v10.4.11 with the standard Java (1.5.0_19) and sqlite3 (3.1.3) that came it. (Yeah, a little old... but see comment below.) I have a sqlite3 database with a table with a few hundred thousand rows, with "name" and "stored" text columns. Name is one of six (so far) short strings; stored is a 19-character standard date...
I'm working on a program that deals with invoices for services done. I'm wondering what is the best way to layout a table of invoices which can have one or more tasks for each invoice. So far the invoice consists of: Invoice Table | InvoiceNumber | Department | DateOfBilling | Now, I need to somehow store the jobs associated with that...
Hi, I would like to know if it is possible to have several DbOpenHelper in the same app Android but to use them to write and read in the same database? because I'm trying to create tables from 2 different OpenHelper (with different names) and only the first one seems to create. when I try to run the 2nd one, i get an error... ...
Does SQLite store the lastmodified date of a row, like a file system? If not, how can I do it? ...
I have a mobile application sync process. The transaction does a lot of modification on the database. Since this is done on mobile I need to issue a VACUUM to compact the database. I am wondering when should I issue a VACUUM in the transaction, as final statement or after the transaction? I am currently looking for SQLite, but if i...
In C# how can I empty an existing SQLite database? Is it possible via the Connection String? or by the SQLite manager? I don't want to issue a drop all tables statement. I have this code, the new here represents if does not exists create a new one. try { connStr = @"Data Source=" + databaseFilePath + ";New=True;Version=3;"; c...
How to handle a missing feature of SQLite: disable triggers? I don't have it stored the name of triggers for a specific table. For example how can I drop all triggers? What would you do? ...
I've never seen the syntax INSERT OR REPLACE INTO names (id, name) VALUES (1, "John") used in SQL before, and I was wondering why it's better than UPDATE names SET name = "John" WHERE id = 1. Is there any good reason to use one over the other. Is this syntax specific to SQLite? ...