I have a database that I have already populated locally. I want to bundle it with my applications and access it at runtime (never want to re-write it anywhere, nor write to the database, simply read). What is the path of a file that I have added to the bundle? And, can i use that path with a SQLiteDatabase.openDatabase ? ...
My open-source Android application uses this in an SQL query: String.format("%f", someDoubleValue); Unfortunately, in some languages the coma is "," instead of "." and the SQL engine does not like it. What is the best way to convert a double to a SQL-friendly string on Android? ...
Hello all, I'm trying to reindex a table in a simple database that I created using SQLite.NET and VS2008. I need to reindex tables after every DELETE command and here is the code snippet I have written (it does not work): SQLiteCommand currentCommand; String tempString = "REINDEX tf_questions"; //String tempString = "REINDEX [main].tf_...
Trying to learn a bit about PDO and is going through this tutorial. It has the following snippet of code: <?php try { $db = new PDO('sqlite::memory'); echo "SQLite created in memory."; } catch(PDOException $e) { echo $e->getMessage(); } When I run this I get the following exception message: SQLSTATE[HY000] [14] unabl...
Hello! I'm developing a new site based on Ruby on Rails 3 beta. I knew this might be a bad idea considering it's just beta, but I still thought it might work. Now though I'm having HUGE problems with Rails consuming huge ammounts of memory. For my application today it consumes about 10 mb per request and it doesn't seem to release it ...
I will start by saying that I don't think what I want can be done, but that said, I am hoping I am wrong and someone knows more than me. So here is your chance... Prove you are smarter than me :) I want to do a search against a SQLite table looking for any records that "are similar" without having to write out the query in long hand. T...
I have an existing database where they created theiw own unicode collation sequence. I'm trying to use the following code and get a "no such collation sequence" exception. Can anybdy hlep with the the syntax to use "collate nocase" with this code? update Songs set SongPath = replace (SongPath, 'Owner.Funkytown', 'Jim'); ...
I'm developing an app in Visual C++ that uses an SQLite3 DB for storing data. Usually it sits in the tray most of the time. I also would like to enable putting my app in a DropBox folder to share it across several PCs. It worked really well up until DropBox has recently updated itself. And now it says that it "can't sync the file in us...
Hi i am new in iphone i am using sqlite3 database. and I am retrieve value from database into table view. when we insert new data into database this is show in the table view but this is not inserted database table. i am not able to find out where this value store. plz tell me ...
I'm trying to calculate TimeSpans between dates. I have no problem with this if the date is formatted using the native sqlite3 format 'YYYY-dd-mm' How would I do this if the date is formatted differently, such as 'dd-mm-YYYY' I've tried the following with no success. --Select days between two days; this works if the datetime string i...
Is there anyway to batch two different select queries to either SQLite or SQLCE and get the two result sets back in C#? If not, is there an embedded database that handles this? ...
I'm familiar with how type affinity works in SQLite: You can declare column types as anything you want, and all that matters is whether the type name contains "INT", "CHAR", "FLOA", etc. But is there a commonly-used convention on what type names to use? For example, if you have an integer column, is it better to distinguish between TIN...
I have the cursor with the query statement as follows: cursor.execute("select rowid from components where name = ?", (name,)) I want to check for the existence of the components: name and return to a python variable. How do I do that? ...
Hey, Im having a problem with my app that causes it to crash when no data is present in the table when using a table view. I have tested my code and it works fine as long as there is data present but i need it to work when there is no data present. -(void)initialiseTableData { NSMutableArray *array = [[NSMutableArray alloc]init]; sql...
Hi, My point is i have a class mapped with a table, in my case in a declarative way, and i want to "discover" table properties, columns, names, relations, from this class : engine = create_engine('sqlite:///' + databasePath, echo=True) # setting up root class for declarative declaration Base = declarative_base(bind=engine) class Shi...
Hi, I would do something like this: select * from cars_table where body not equal to null. select * from cars_table where values not equal to null And id = "3" I know the syntax for 'not equal' is <>, but I get an empty results. For the second part, I want to get a result set where it only returns the columns that have a value. So,...
Hello I'm starting over to use strong typed datasets in VS 2008 with sqlite and running into a problem. I have some tables that have foreign keys allready defined in the database. I can see those in the Server-Explorer. Now i create a new strong typed Dataset with the designer and add only one table from that realtion to the dataset....
Hey ! I am making an application which is a user interface to access 2 types of databases - SQLite and SQL Server. The thing is, SQLite doesnt need to be "installed" since its just a flatfile database, but on the other hand, SQL Server (Express/normal) need to be installed before use. My Question is simple: Is there a way by whic...
I have a small database with tables containing a small amount of data which I need to copy into memory. Currently I am using: insertcommand.CommandText = "SELECT sql FROM sqlite_master WHERE sql NOT NULL;"; To pull all the table schema from the file database, however I'm not really sure how to proceed with creating these tables in th...
Hi, I wonder if there is a canonical way to convert data from long to wide format in SQLite (is that operation usually in the domain of relational databases?). I tried to follow this example for MySQL but I guess SQLite does not have the same IF construct... Thanks! ...