Re: [sqlite] Error code 21 ( SQLITE_MISUSE ) when binding variables

> > * Loop through values, calling sqlite3_bind_text on each of then: > rc = sqlite3_bind_text( my_db_stuff->stmt, my_db_stuff- > >current_position > + 1, local_buff, len, SQLITE_STATIC ); > > On the 1st call to the above, I get the return code 21, which I assume > is 'SQLITE_MISUSE' from searchi

Re: [sqlite] Is sqlite3_next_stmt valid command in SQLite 3.5.9?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Wenton Thomas wrote: > Could anyone help me? Use search: http://www.sqlite.org/cvstrac/search?s=sqlite3_next_stmt&c=1 In any event using the most recent SQLite is easy. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARE

Re: [sqlite] Question about Referential IntegrityRE: Foreign key support

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yves Goergen wrote: > You can already use referential integrity with SQLite - just in a very > complicated way, using numerous handcrafted triggers. How it works is > documented somewhere in the Wiki, IIRC. It is true that triggers can be used to achi

[sqlite] Error code 21 ( SQLITE_MISUSE ) when binding variables

Hi all. I'm having difficulty binding variables to a statement. Here are the steps I'm taking: * Create a statement in a loop ( parsing CSV headers ), in the form: insert into table( xxx, xxx, xxx ) values ( ?, ?, ? ); The above is working and I can dump valid-looking SQL at this point. The sta

Re: [sqlite] Single quote, newlines and UPDATES

"Derrell Lipman" wrote... > > >> >> and I did an SQL command dump of the string that I am passing to the D >> SQLite wrapper and it is escaped. I am reclining on the idea that it is >> the >> D wrapper. I have to go to post this on the D wrapper newsgroup. >> > > My understanding is that you can

[sqlite] Is sqlite3_next_stmt valid command in SQLite 3.5.9?

Could anyone help me? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_bind_*

On Wed, 2009-02-11 at 17:58 -0500, Igor Tandetnik wrote: > Daniel Kasak > wrote: > > Next comes the binding bit. I was a bit surprised to find a separate > > function per data type. Is this going to be a problem? Assuming I've > > created the table with the correct data type for each column, if I

[sqlite] Find out what sql statement is locking the database

Hi All, I have the database for one of our application and one for awhile the database is lock(SQL error: database is locked) and I couldn't find out why the datbase is locked. I used Sqlite 3.5.9. So is there anyway to find why the database is locked. Thanks, JP: ___

Re: [sqlite] Single quote, newlines and UPDATES

> > > and I did an SQL command dump of the string that I am passing to the D > SQLite wrapper and it is escaped. I am reclining on the idea that it is > the > D wrapper. I have to go to post this on the D wrapper newsgroup. > My understanding is that you can call C library functions from D. You

Re: [sqlite] need partial index

> let's say i have a table MY_TABLE(INT_ID int not null, STRING_ID > varchar(255), DATA blob, primary key(INT_ID)). table has millions of > rows. i need to map from STRING_ID to INT_ID, but only for some rows. at > the time of insertion i know whether the new row needs to be in that map > or no

Re: [sqlite] sqlite3_bind_*

Daniel Kasak wrote: > Next comes the binding bit. I was a bit surprised to find a separate > function per data type. Is this going to be a problem? Assuming I've > created the table with the correct data type for each column, if I > just use, for example, sqlite3_bind_text on all data, will the >

[sqlite] need partial index

hi, let's say i have a table MY_TABLE(INT_ID int not null, STRING_ID varchar(255), DATA blob, primary key(INT_ID)). table has millions of rows. i need to map from STRING_ID to INT_ID, but only for some rows. at the time of insertion i know whether the new row needs to be in that map or not. in

[sqlite] sqlite3_bind_*

Hi all. I'm writing a generic csv importing thing in C ( partly as a project to teach me C ). So far I've got parsing of the CSV header row ( ie field headers ) and construction of the 'insert into' statement working, with field names and '?' placeholders for bind variables. Next comes the bindin

Re: [sqlite] Single quote, newlines and UPDATES

"David Bicking" wrote... > On Wed, 2009-02-11 at 16:12 -0500, jose isaias cabrera wrote: >> "P Kishor" wrote... >> >> >> > On Wed, Feb 11, 2009 at 2:00 PM, jose isaias cabrera >> > wrote: >> >> >> >> >> >> "P Kishor" wrote... >> >> >> >> >> >>> On Wed, Feb 11, 2009 at 1:48 PM, jose isaias cabrera

Re: [sqlite] Single quote, newlines and UPDATES

On Wed, 2009-02-11 at 16:12 -0500, jose isaias cabrera wrote: > "P Kishor" wrote... > > > > On Wed, Feb 11, 2009 at 2:00 PM, jose isaias cabrera > > wrote: > >> > >> > >> "P Kishor" wrote... > >> > >> > >>> On Wed, Feb 11, 2009 at 1:48 PM, jose isaias cabrera > >>> wrote: > > Greeting

Re: [sqlite] Problems using AUTOINCREMENT row IDs in indexes

> I've banged on about this problem and thanks to your assistance it > seems > to be resolved now. Perhaps you could update the documentation at > http://www.sqlite.org/autoinc.html and > http://www.sqlite.org/lang_createindex.html - I had certainly read > these many times so a note about rowid's

Re: [sqlite] Single quote, newlines and UPDATES

"P Kishor" wrote... ...clip... >> after this, I will prepare s and UPDATE Xtra3. Here is the question: the >> original UPDATE should have worked, correct? Meaning that the >> filename'3.txt should have been prepared as filename''3.txt, correct? >> > > > yup. That is what I did... Ok, I will fig

Re: [sqlite] Single quote, newlines and UPDATES

On Wed, Feb 11, 2009 at 3:12 PM, jose isaias cabrera wrote: > > "P Kishor" wrote... > > >> On Wed, Feb 11, 2009 at 2:00 PM, jose isaias cabrera >> wrote: >>> >>> >>> "P Kishor" wrote... >>> >>> On Wed, Feb 11, 2009 at 1:48 PM, jose isaias cabrera wrote: > > Greetings and saluta

Re: [sqlite] Question about Referential IntegrityRE: Foreign key support

On 09.02.2009 19:32 CE(S)T, palmer ristevski wrote: > Just wondering when/if Richard > will make SQLite having referential Integrity a priority. > Is it on the TODO list? Is it #1 or #100 on this TODO list. > Because almost all other common databases have this. > > Once it has this feature I thin

Re: [sqlite] sqlite3 cmd line: arrow keys not working

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David Easley wrote: > If anyone can advise how to fix this I'd be most grateful. Install libreadline5-dev before running configure. The readline library is what provides the command line editing and recall. Roger -BEGIN PGP SIGNATURE- Versio

Re: [sqlite] auto closing database files

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Horton wrote: > Is there a way of auto-closing all currently open database files Just exit your process. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkmTP4sACgkQmOOfHg372QTU1gCgyK8ZeNa66dr4dcqiF7KQMLWv +uE

Re: [sqlite] Single quote, newlines and UPDATES

"P Kishor" wrote... > On Wed, Feb 11, 2009 at 2:00 PM, jose isaias cabrera > wrote: >> >> >> "P Kishor" wrote... >> >> >>> On Wed, Feb 11, 2009 at 1:48 PM, jose isaias cabrera >>> wrote: Greetings and salutations... I am having a problem with an specific UPDATE. One of the

[sqlite] sqlite3 cmd line: arrow keys not working

I recently upgraded from a standard Ubuntu packaged version of sqlite3 (3.5.something) to a self compiled build of the latest source (3.6.10). I built from the recommended aggregation. In the previous version, when working in the command shell I could use the arrow keys to recall and edit previous

Re: [sqlite] Single quote, newlines and UPDATES

On Wed, Feb 11, 2009 at 2:00 PM, jose isaias cabrera wrote: > > > "P Kishor" wrote... > > >> On Wed, Feb 11, 2009 at 1:48 PM, jose isaias cabrera >> wrote: >>> >>> Greetings and salutations... >>> >>> I am having a problem with an specific UPDATE. One of the functions of >>> my >>> program is to

Re: [sqlite] Single quote, newlines and UPDATES

"P Kishor" wrote... > On Wed, Feb 11, 2009 at 1:48 PM, jose isaias cabrera > wrote: >> >> Greetings and salutations... >> >> I am having a problem with an specific UPDATE. One of the functions of >> my >> program is to capture all of the files in a directory so that one can >> search >> on

Re: [sqlite] Single quote, newlines and UPDATES

On Wed, Feb 11, 2009 at 1:48 PM, jose isaias cabrera wrote: > > Greetings and salutations... > > I am having a problem with an specific UPDATE. One of the functions of my > program is to capture all of the files in a directory so that one can search > on a file name and find out where that file i

[sqlite] Single quote, newlines and UPDATES

Greetings and salutations... I am having a problem with an specific UPDATE. One of the functions of my program is to capture all of the files in a directory so that one can search on a file name and find out where that file is quickly. This is working perfectly, until there is a file that ha

Re: [sqlite] Query Optimization Help

inZania wrote: > The situation is this: there is a table, "cards", which I am > searching. Each card has a card_id, name, text, etc. There is also a > table "card_tags" which has only the rows "card_id" and "tag", > because a single card may have several tags. The query I'm trying to > execute i

[sqlite] Query Optimization Help

Hello, I have a query that is slowing down my application significantly; in some cases, it takes 20+ seconds (this is in a SQLite database in an iPhone app, which is why it is so slow - the iPhone doesn't have as much system resources). If anybody could help me optimize this query, I'd appreciat

[sqlite] about B+Tree depth

Hi all, I want to know the depth of B+Tree in Sqlite, is there some way to compute it? suppose I konw the page size, table size, and entry nums. The B Tree depth determine the page number Sqlite has to get in a B Tree search, is right? Thanks! _

Re: [sqlite] REquire help!! - in debugging

deepak dhananjaya writes: > > HI All, > I have this piece of code: > > sqlite3 *db; > const char KDbName[] = "c:\\test\\Db1.db"; > int rc = sqlite3_open (KDbName, &db); > if (rc) > { > sqlite3_close (db); > return; > } > > its crashing whi

Re: [sqlite] Unab to close data base due to unfinalized statements

try finalize at the end instead of reset. --- On Wed, 2/11/09, krishnakumar...@luckymail.com wrote: > From: krishnakumar...@luckymail.com > Subject: [sqlite] Unab to close data base due to unfinalized statements > To: sqlite-users@sqlite.org > Date: Wednesday, February 11, 2009, 2:28 AM > Hi

Re: [sqlite] out of memory with sqlite3 shell

have you checked your evironment variables, such as LD_PRELOAD?? also you can try running strace to trace system calls. --- On Wed, 2/11/09, Roberto Lumbreras wrote: > From: Roberto Lumbreras > Subject: Re: [sqlite] out of memory with sqlite3 shell > To: "General Discussion of SQLite Databas

Re: [sqlite] out of memory with sqlite3 shell

I'm using the default allocator, and it is a uclinux system without dynamic libraries, everything must be staticaly linked, so ltrace can't help (anyway, I think there is no ltrace available for this machine). I'll try to use gdbserver to debug it, but I really don't understand why sqlite3 is doi

[sqlite] auto closing database files

Hello, Is there a way of auto-closing all currently open database files i.e. any files opened with either sqlite_open(), sqlite_open16(), sqlite_open_v2() or ATTACH ? thanks and regards, John _ Check out the new and improved se

Re: [sqlite] Unab to close data base due to unfinalized statements

2009/2/11 : > Hi , > i am using sqlite with vc++, i tried to insert a row into data base with > prepared statement using bind operations, i reset the statement after using > it but when i try to close DB it is giving error "Unable to close data base > due to unfinalized statements" Are you cal

Re: [sqlite] problem about sqlite3_sql

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 roamer wrote: > the sqllite3.so did not contian sqlite3_sql or I have done something wrong? Your application is probably picking up a system SQLite that predates that symbol being available. You'll need to use tools like ldd and lookup things like LD

[sqlite] Unab to close data base due to unfinalized statements

Hi , i am using sqlite with vc++, i tried to insert a row into data base with prepared statement using bind operations, i reset the statement after using it but when i try to close DB it is giving error "Unable to close data base due to unfinalized statements" i userd query like _T("INSERT INT