I am creating a class that handles various SQLite actions. My problem is: When I make a SQL string with multiple statements then it works when using standard PHP => $db->query() ... but it fails when making the same request from a method. It seems that the OO method skips everything after the first ";"-symbol in my SQL statement. Why is ...
Hi everybody. How can I query the filesystem (NTFS) with SQLite? ...
I'm creating a online community for a soccer betting game available in my country. I've a pretty good idea how the whole system should work but I'm having some trouble figuring out the ideal database design and I need some help with it. The usual work flow should be something like this: Everyone is welcome to register as a member; eac...
So i need to write a program that accesses and modifies an SQLite DB for a school program and am looking at the basics firstly. Now, I am looking at this to get me started: link text. The problem is that when i compile Test.java (The example code on the website) and then run the command: java -cp .:sqlitejdbc-v056.jar Test like it tel...
Hi, Im using sqllite in my palm-pre web os application, i have the table with the following structure. Spending(id,note,amount,date,recurringtype,type,isprocessed); the value for the recurring type will be like daily,weekly monthly etc.(1,2,3..etc) i need to replicate a record by checking the date and the recurring type. Can it be ac...
As I understand, SQLite doesn't have the math functions to properly implement the Haversine formula in straight SQL. I'm thinking this should be possible using an external function, with the implementation being in C. The goal is to have a SQLite database in an iPhone, and to be able to sort by the distance to the user's current locati...
How can I get metadata / constraints (primary key and "null allowed" in particular) for each column in a SQLite v2.8 table using PHP5 (like mysql_fetch_field for MySql)? sqlite_fetch_column_types (OO: $db->fetchColumnTypes) only gets column name and datatype: http://dk.php.net/manual/en/function.sqlite-fetch-column-types.php SQLITE_MAS...
I am using fmdb for managing my database. I could not find any example for deleting a row from a table in fmdb. I tried NSString *sqlStat=@"DELETE from tableName WHERE id=3"; FMResultSet *rs = [database executeQuery:sqlStat]; but its not working because when I checked the total number of entries in table, I am getting the sam...
I have a WPF app that lets the user select an image from a file dialog. The same app opens a SQLite database with Fluent NHibernate (auto mapping). I try to convert the image to byte array and save it, but for some reason it's not doing it and for some other reason I see my db file in the image folder. Any one knows how to fix this? ...
Hi , How to write the sql so that the result can be ordered first by column A than by column B. Something like below: SELECT * FROM tbl WHERE predictor ORDER by col_A and ORDER by col_B ...
Hi, I am trying to understand the ACID property of database transction: how they are achieved; which part is atomicity and which part is durability ,etc. Let's say I have a transction with two actions,A and B. Unfortunately, system powered off when performing action B. After a system reset, we know the database will preserve (through t...
Hey all, i deployed my App to my iPhone and get Unknown error calling sqlite3_step (8: attempt to write a readonly database) eu on Insert / Update Statements. On the Simulator it all works like it should. My sqlite Database is placed in the Resource Folder (Xcode). Thanks for help! ...
Good day, I receive data from a communication channel and display it. Parallel, I serialize it into a SQLite database (using normal SQL INSERT statements). After my application exit I do a .commit on the sqlite object. What happens if my application is terminated brutally in the middle? Will the latest (reasonably - not say 100 microsec...
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 /...
I have heard that prepared statements with SQLite should improve performance. I wrote some code to test that, and did not see any difference in performance with using them. So, I thought maybe my code was incorrect. Please let me know if you see any errors in how I'm doing this... [self testPrep:NO dbConn:dbConn]; [self testP...
I have considered SQLite, but from what I've read, it is very unstable at sizes bigger than 2 GB. I need a database that in theory can grow up to 10 GB. It would be best if it was stand-alone since it is easier to implement for non-techie users, instead of having the extra step of installing something like MySQL which most likely will r...
Hi, I am exporting a date value from sqlite and placing it into an email. The date appears like this 279498721.322872 I am using Objective C in an Iphone App. Does anyone know how to make this export out as a regular date whether it is all number like 2009-02-10 or anything legible? ...
Hello Every1, i maintain a sqlite db in my iPhone app so, i was wondering how u could persist a single version and updated one. its said that if want to make updates to the db u should copy it to the documents folder on my iPhone simulator the documents folder changes like everytime i open the app if its copied and changes was made ....
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...
Apple doesn't provide promo codes for in app purchase products. My content will be in an sqlite database in the app. I'll use a column flag to indicate purchase status. Once the user purchases, I unlock the row by changing the flag. Would it be easy enough to provide another interface so the user can enter in a code and unlock the it...