What is the terminal command, or where is a good resource to get them, to alter a table. And, do I need to re run the $rake db:migrate after I do this? I am running RoR on Snow Leopard. Last question, can I make an already created column non-null. UPDATE: figured out how to alter, just need to know if I need to rake db:migrate after a...
i want to save current date+time into database and also want to retrieve it. i know that in objective-C we cannot save date+time directly. i have double as a field into database and currently I'm saving date by converting it into double. here is the method for converting date into double- currentDate=[NSDate date]; startDate=(double)...
I can open a regular sqlite database on iPhone with sqlite3_open([filename UTF8String], &database); But how do I open a password encrypted database? ...
I was successfully accessing my database to get a list of cities on the App launch. I tried running a second query against it right afterward to get the list of States but all that happens is that my app blows up with no usable error in the console (simply says "Program received signal: EXEC_BAD_ACCESS" and nothing more). Here is the c...
The site, http://sqlite.phxsoftware.com/, talks about a mixed-mode assembly and a managed-only version of the provider. Are they both named System.Data.SQLite.dll? I installed the managed-only version in windows and it is working. Which, as I understand it, means that I must also have the native sqlite3.dll file somewhere on my machin...
I tried many things, i can't display multiline texts from database into uitextview, the \n characters appear as they are instead creating new lines. NSString *aDescription2 = [NSString stringWithCString:(char *)sqlite3_column_text(compiledStatement, 2) encoding:NSUTF8StringEncoding]; The problem must be here, because if i hardcode the...
I have an SQLite db with 19 records in it. Of those records 18 have a "threatLevel" value of 1, and one of them has a "threatLevel" of 2. The field is set to default to 1. I recently changed the 19th record to "threatLevel" 2 for testing purposes. I used SQLite Manager (a Firefox extension) to add the value directly to the sqlite file...
I am trying to build python2.6 with support for the sqlite3 module. I have successfully built and installed the sqlite-amalgamation to a non standard path: ./configure --prefix=/my/non/standard/install/path/sqlite/3.6.20/ make make install I would like the python2.6 build to use this path & build the sqlite3 module. I checked './config...
I've the following condition in one of my model which works for mysql. with_scope :find => { :conditions => "starts_at <= now() AND ends_at >= now()" } But I get error on the sqlite3 test database coz that now() is specific to mysql db only. What would be a db agnostic way for that now() function? ...
I'm currently working on a game for the iphone, where images are loaded from the internet and then stored in the local database so they do not have to be loaded again. This has always worked fine. Recently I created a new adhoc distribution for the testing group (the first time I created the distribution using SDK 3.1.2) and now everybod...
Hi, When we are using any gear enable site, and we go offline the gear automatically creating folder with /dbName#database ... assume 2 diff. website is there www.abc.com and www.xyz.com. when I go online in www.abc.com it should create folder like /abcxyz/dbName#database, And same for www.xyz.com it should also create folder like /...
The concern is guaranteeing compatibility with the Sqlite Header file compiled into the iPhone app. What if the header file used at compile time is from a newer version then the dynamic library installed on the iPhone? This could be due to the app running on an older or newer iPhone OS version then the app was built with. Is it safe to u...
I am running an END TRANSACTION on my database and occasionally I get error #1 that "cannot commit - no transaction is active" Is there a way to determine if a transaction is active before trying a commit? I have been tracking my "BEGIN TRANSACTIONS" by hand but I feel there is a better way. I am using the C API ...
Hi, We have a very special requirement to store blob data in SQLite database, where We have to store documents. We have static html page which is in user disk, so we want user to upload document without connecting to internet with help of google gear, javascript and SQLite. is it possible to do ... Any Help Appreciated ... ...
Hello: I need to do a generic C# program to let the data reading from an Oracle database table (T1) with, for example, field names a, b, c, d, and saving into an SQLite3 table (T2) with the same field names and types than T1, althought with additional fields that can have null values. I am using the different ado.net libraries provided...
Hey guys, I got this error: OperationalError at / unable to open database file Things I've tried so far are setting the absolute path of my dev.db file in the settings.py. I've tried adding www-data to my admin group and setting the group of my project folder to the admin, and setting the group to www-data, none of which solved the p...
I am using sqlite database to store data. I have three tables: Invoice, InvRow, Invdetails. Relationsip between the tables are: Invoice.Id = InvRow.InvId InvRow.Id = Invdetails.RowId I need to delete related entries from three tables using a single query. How can I do that? Any help? ...
I'm trying to get a record count of a table in sqlite3 on the iphone so I can do a little dynamic memory allocation. But, when I run the following code, I get a record count of zero. The DB is open (I have more code immediately following this that retrieves the rows from the table that I'm interested in). I just can't get a record cou...
Code Sample: NSString *str= [NSString stringWithUTF8String:(char *)sqlite3_column_text(selectStatement, 1)]; Test *t=[[Test alloc] init]; t.str=[str copy]; // why use "copy" here? [str release]; ...
Hi All, I created a webservice in RDB with .Net.I able to transfer data from iphone to mysql and it returns the data. But i need to transfer data from RDB to iphone whenever i need (i am strucked by the ip address of iphone which one is dynamic to connect the device from a RDB) Please tell me how i will do it otherwise tell is any othe...