Hi All, i've been trying to figure out wh. sqy my object allocation keeps rigth up every time i call this function, Instruments reports no leaks but I get a heck of a lot of object coming from sqlite3_exec --> sqlite3Prepare --> sqlite3Parser --> yy_reduce --> malloc & also a whole bunch from & from sqlite3Step --> sqlite3VdbeExec...
I am trying out iPhone Apps, coming from C#, I am finding very difficult to grasp the iPhone dev environment. So far, I am able to get my 'Makes' listed in a TableViewController. I now wish to get by 'Models' listed when a Makes is selected. Can someone help me with sample code. Can I use the same TableViewController to show the Models...
Basic table with empname and empdpt. In a Sql Server table, I can do Select empname + ' ' + empdpt as expr1 no problem. Can't do the same using Sqlite!! When I try to combine two columns [with data], I get back a 0. I've tried in sqliteman and sqliteadmin as well as Server Explorer in VS. ...
I have this line that works OK: c.execute('select cleanseq from cleanseqs WHERE newID="%s"'%name) But I want to use SQLite parameter substitution instead instead of string substitution (because I see here that this is safer). This is my (failed) try: t = (name,) c.execute('select cleanseq from cleanseqs WHERE newID="?"',t) But thi...
i'm using Netbeans 6.5 for RoR development. I believe my sqlite3 DB is out of synch with rails migrations. how can I view and manipulate the database (through netbeans or command line)? ...
Most sqlite examples I've found talk about creating a db file from the commandline first and then adding that to your app. For my project, I'd like to be able to create my database within the app when it starts up for the first time and then save it to a db file in the user's sandbox. Is there a way to do that? ...
Is it possible, and if so, how... To do parameterized queries with SQLite WITHOUT having to go through ADO.NET. I've been asked to do some testing with SQLite for a project that needs to have a zero-admin install... ie: no special permissions, things added to windows registry, etc. I would suspect that using an ADO.NET would require s...
I am trying update my version of sqlite3 on mac os x 10.5.7 I downloaded the source code that is recommended for unix and unix like programs. I followed the compile and install directions in the readme file and everything seems to work fine. However, when i check the version number of sqlite3 it remains at 3.4.0 (the old version). Wh...
i want to store audio files(any of these formats mp3,wav,and iphone supported) in database and play them in iphone...any idea how to do this? ...
How do I know if PHP is compiled with SQLite support? If it's not, and I don't have the privileges to change it, what alternatives do I have to read an SQLite database besides access to php-sqlite3 functions? ...
I am intending to use SQLite 3 with PHP 5. I found this: http://packages.debian.org/etch/web/php5-sqlite3 but I am having problems with installation: unzip & untar the package run "phpize" run "./configure --with-sqlite3=/path/to/your/sqlite3/install make && make install (optionally) copy DB/sqlite3.php to /path/to/php/lib/php/DB/sqlit...
Hi , I am trying some way to optimize following sql statement: exe_sql "DELETE FROM tblEvent_type WHERE eguid in (SELECT rowid FROM tblEvent_basic WHERE sguid=11);"; exe_sql "DELETE FROM tblEvent_group WHERE eguid in (SELECT rowid FROM tblEvent_basic WHERE sguid=11);"; It is said that sqlite3 did not perform well in subquery and not...
Using sqlite3, if my query is SELECT * FROM table WHERE title LIKE '%x%' It will match strings that contain x. I want to make x a bindable parameter, like: SELECT * FROM table WHERE title LIKE '%x?%' However, this does not work since the '' form a string literal. Is there some way of escaping the ? within the literal? I understand th...
Hi everyone i need to insert the contents of a file into a blob column in sqlite3 but the thing is that i just wanna know whether it is possible by command line statement regards shroff ...
Hi , I want to know what is the performance difference between sqlite3_exec() and sqlite3_get_table(). is there a performance difference...? ...
I am trying to write a simple query to an sqlite database in a python script. To test if my parameters were correct, I tried running the query from the ipython command line. It looked something like this: import sqlite3 db = 'G:\path\to\db\file.sqlite' conn = sqlite3.connect(db) results = conn.execute('SELECT * FROM studies').fetchall()...
I'm struggling to find a good tool to help me migrate a MySQL database to SQLite. I've seen a couple of different Perl scripts (including one discovered here), but they do not appear to work correctly for me. ...
Im getting an error "not an error" on iPhone SDK, I spent a whole day trying to resolve it. SQLite version 3.4.0 sqlite3_step(compiledStatement) The table I'm using in the query has only one row. It returns 100..? sqlite3_errmsg( database ) This line gives me the above error. I've created a database and tables in it with terminal ...
I'm writing an iPhone app which seems to run fine on the simulator, however when I try and run it on the device I get a libsqlite3.dylib, file is not of the required architecture error. I'm using os 3.0 on a 3GS. Any ideas on what could be causing this? Thanks! ...
I just bought a new MBP I've read online Sqlite3 already exists on OSX. I've downloaded mac ports (and installed it) as well as the bin file for sqlite3 from the official web site. In a guide I'm reading about rails, which tells me to update sqlite3, I run the following in terminal: sudo port upgrade sqlite3 I receive the following ...