One of my projects uses Elmah, which references SQLite. Elmah is built against SQLite for .Net version 1.0.44.0 well I was experimenting with some 64 bit stuff (my dev box is 32 bit) so I needed the 64 bit version of SQLite for .Net. I grabbed the latest build of it (1.0.51.0 at the time) and used their installer to install it. For my 3...
I need to keep datetime in a C++ structure for an iPhone app. The time will be saved and restored into sqlite db. What is the best data type and corresponding API for this? My candidates are: time_t and struct tm from <ctime> and <time.h> NSTimeInterval from <NSDate.h> TimeValue from the QuickTime API My instinct is to go with the g...
Hello, I'm attempting to pull some data from a SQLite database so that I can populate a GridView in my GUI: here is the code that returns the DataTable: DataTable table = new DataTable(); SQLiteDataAdapter adapter = new SQLiteDataAdapter(this.command.CommandText, this.connection); adapter.Fill(table); return table; For some reason a...
Hello, I've got the following code which I think ought to be binding a DataTable to a DataGridView, but the DataGridView shows up empty. The DataTable definately has rows, so I assume that I am binding the DataSource incorrectly some how. Does anyone see what is wrong with this: DataBase db = new DataBase(re.OutputDir+"\\Matches.db")...
Given the statement: const char *sql = "INSERT INTO FooTable (barStr) VALUES (?)"; is the following use of sqlite3_bind_text (and related sqlite3_bind_* functions) sufficient to prevent SQL injection attacks? sqlite3 *db; sqlite3_stmt *dbps; int dbrc = sqlite3_open([dbFilePath UTF8String], &db); if (dbrc) { // handle error ...
Hi, I've released an app update which does an upgrade of the database ie. executes a script file in the bundle that adds a column to existing table , etc. I've tested this by deploying previous version builds on my device from xcode and then deploying the latest version. The upgrade worked fine. Yesterday my distribution build got...
Let's say I have an SQL table of tuples (id, lastname, firstname, occupation) where all values are strings (ok, obviously id is a key). I want to transform it to a table with tuples (id, lastid, firstid, occupid), where I only keep pointers to other tables that contain the actual values. I apologize if the example domain of names and oc...
I'm using Microsoft Visual C# 2008 Express Edition with SqlLite. I'm successfully able to open my database and with C# code, add entries to my tables. When it comes to retriving data, I'm having some issues and have been searching and searching the internet for basic tutorial information on how to do these basic things... Here's my co...
I'm used to using the command "mysql_insert_id()" in PHP to return the id of the last line inserted into my database. Is there an equivalent command in SQLite in C#? Thanks! -Adeena ...
I'm working in Microsoft Visual C# 2008 Express with Sqlite. I understand that an apostrope (') in my text has problems in a query. My problem is that I thought I could replace it with \'. It doesn't seem to be working... Here's a parred down example of my code: string myString = "I can't believe it!"; cmd.CommandText = "Insert into ...
I'm designing an iPhone app, which needs to store data into Sqlite database. One record of the table looks like - @interface Record:NSObject { NSInteger primaryKey; NSString *name; NSInteger priority; NSMutableArray *items; }; Please be noted one column in the record is an array and the size of the array is not fixed....
I'm configuring JPA to work with SQLite db, with hibernate as the provider. I map a single pojo to a table, no fk's,just plain simple for now. I'm using a SQLDialect I found on the internet.I get this stacktrace, when I try to initialize my application: java.sql.SQLException: SQLite supports only TRANSACTION_SERIALIZABLE at org.sql...
Hello - I have created a simple database using SQLite (actually PySQLite). It works fine when I'm querying or writing to the database from the local machine (ie program and database file on the windows machine drive). However when I copy the database file to my network drive (a time capsule), then Windows machines, although they can see...
I have a problem with php and sqlite. I always have that warning: Warning: sqlite_popen() [function.sqlite-open]: file is encrypted or is not a database. the name I pass to connect is a database sqlite3. I don't know how to fix that ? ...
Hi... I'm trying to run several instances of a program accessing a sqlite database in java (always the same file) and actually I don't know whether it's possible or not that several jobs access the same database.... ...
I'm considering using sqlite as a production database for a site that would receive perhaps 20 simultaneous users but with the potential for a peak that could be many multiples of that (since the site would be accessible on the open internet and there's always a possibility that someone will post a link somewhere that could drive many pe...
I'm trying to find the sqlite database file that rails creates. Sorry if this is a dumb question but which folder is this file stored in? I've looked in all of the folders in my Rails project and can't find it. My database.yml: development: adapter: sqlite3 database: db/development.sqlite3 pool: 5 timeout...
I'm learning Django by building a simple recipes app. I have a 1 table model using the 'choices' field option for recipe categories rather than using a 2nd 'categories' table and a foreign key relationship. So i created db table via syncdb and then loaded table with test data. When i go to admin and click on the 'Recipes' link in an atte...
I'm using SQLite from a C# program using SQLite.net ( http://sqlite.phxsoftware.com ). By default SQLite select order by clause sort is case sensitive, I want the result to sort case insensitive, I found "COLLATE NOCASE" but the documentation says it will only handle English characters in the ascii range, I want true linguistic internat...
Hi everyone, I have to develop a database for a unique environment. I don't have experience with database design and could use everybody's wisdom. My group is designing a database for piece of physics hardware and a data acquisition system. We need a system that will store all the hardware configuration parameters, and track the change...