[sqlite] defining SQLITE_OMIT_VACUUM Reg

Hi all, I am new user of sqlite. when I tried to compile the code with minimum features, i faced the problem when i defined SQLITE_OMIT_VACCUM. IMHO, in parse.y the following lines are missing. %ifndef SQLITE_OMIT_VACUUM %endif // SQLITE_OMIT_VACUUM *** F:/share/sqlite1/parse.yThu Sep 21 1

Re: [sqlite] German umlauts (äöüß)are not displayed in sqlite - solution

Hi Martin, list, sorry, I forgot to mention that "my" sqlite3 is running on a Debian (sarge) pc. BTW, using xterm, I was able to perform select statements where Umlauts are shown (before, I used the kde-application "konsole"). The only thing that remains "to be solved" for me is umlauts&sqlitebr

Re: [sqlite] Summit a bug : data encoded from UTF8 is incorrect

On 9/21/06, 卢炎君 <[EMAIL PROTECTED]> wrote: Hi all I use a tool name as sqlitebrowser which from sourceforge to browsed my db , BTW all data be decoded as utf-8 (lanugage is chinese), the result of retrive is correct display, so I am sure that all data has no any problem when be inserted int

Re: [sqlite] how sqlite works?

Ok Thanks John I will try to buy! Thanks everybody for your help! On 9/21/06, John Stanton <[EMAIL PROTECTED]> wrote: I suggest that you get Donald Knuth's books (Fundamental Algorithms, Sorting and Seaching and Semi-Numerical Algorithms). They have everything you need to know, and plenty mor

[sqlite] Wish to store a C structure in sqlite column

Dear Friends, I am in the process of forming a Generic API,(sql oriented and BerkelyDB and sister databases). In the process of integration ,i like to store a Structure in Sqlite. as far as my knowledge SQLITE allows me to declare the column types suppoted by the programming languare or say

Re: [sqlite] Wish to store a C structure in sqlite column

Narendran a écrit : Dear Friends, I am in the process of forming a Generic API,(sql oriented and BerkelyDB and sister databases). In the process of integration ,i like to store a Structure in Sqlite. as far as my knowledge SQLITE allows me to declare the column types suppoted by the progr

[sqlite] Cannot Find Syntax Error

I'm not seeing what must be obvious, so fresh eyes would be very helpful. When I try -- from the command line: sqlite3 foo.db < load_hedges.sql the following error is reported: SQL error: 1 values for 2 columns I get the same error even when I ex

[sqlite] Re: Cannot Find Syntax Error

Rich Shepard <[EMAIL PROTECTED]> wrote: I'm not seeing what must be obvious, so fresh eyes would be very helpful. When I try -- from the command line: sqlite3 foo.db < load_hedges.sql the following error is reported: SQL error: 1 values for 2 colum

Re: [sqlite] Re: Cannot Find Syntax Error

On Thu, 21 Sep 2006, Igor Tandetnik wrote: You list two column names, but only provide one value. Make it insert into hedge (hedge_name) values ('around'); That's what I did originally, but got the same error. insert into hedge (hedge_id, hedge_name) values (null, 'around'); I did not

Re: [sqlite] Re: Cannot Find Syntax Error

On Thu, 21 Sep 2006, Igor Tandetnik wrote: insert into hedge (hedge_name) values ('around'); Igor, Here's more information. The above works from the command line, that is 'sqlite3 foo.db < load_hedges.sql.' However, it does not work using .import within the sqlite shell. Using the existi

[sqlite] Re: Re: Cannot Find Syntax Error

Rich Shepard <[EMAIL PROTECTED]> wrote: On Thu, 21 Sep 2006, Igor Tandetnik wrote: You list two column names, but only provide one value. Make it insert into hedge (hedge_name) values ('around'); That's what I did originally, but got the same error. insert into hedge (hedge_id, hedge_nam

Re: [sqlite] Re: Re: Cannot Find Syntax Error -- SOLVED!

On Thu, 21 Sep 2006, Igor Tandetnik wrote: Check that this existing table does indeed have the columns you think it has. Try running this from the shell: Igor, I found the problem ... at least, from within the sqlite3 shell. I was using the incorrect tool. :-( Since the file contained va

Re: [sqlite] Re: Cannot Find Syntax Error

Rich Shepard wrote: On Thu, 21 Sep 2006, Igor Tandetnik wrote: insert into hedge (hedge_name) values ('around'); Igor, Here's more information. The above works from the command line, that is 'sqlite3 foo.db < load_hedges.sql.' However, it does not work using .import within the sqlite she

[sqlite] cwd error?

problem: SQL error: no such table: input_queue but when i check it using the commandline app, its clearly there. i just created another table called 'test' with 1 col of integers and inserted '34'and it .dumps OK (using the command line app) but says :SQL error: no such table: test ha

Re: [sqlite] cwd error?

On 9/21/06, AJ <[EMAIL PROTECTED]> wrote: any ideas? You haven't really opened the database you think you have? What happens when you do: SELECT * FROM sqlite_master; - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] cwd error?

Oh, it created one in the cwd, not the place where i thought the DB should be... is there a way to turn that 'feature' off, so that i can prevent that from happening, i'd prefer just an error. Will Leshner wrote: On 9/21/06, AJ <[EMAIL PROTECTED]> wrote: any ideas? You haven't really

Re: Re: [sqlite] cwd error?

On 9/21/06, AJ <[EMAIL PROTECTED]> wrote: Oh, it created one in the cwd, not the place where i thought the DB should be... is there a way to turn that 'feature' off, so that i can prevent that from happening, i'd prefer just an error. You could test for the file's existence before trying to op

[sqlite] Bind

Hi, I am just wondering what will happen, if I bind a column with null intially, but later in my path if I bind some integer value, which value will be considered while excuting step function. Note its on the same prepared statement and before doing a reset of the statement. . Chet

Re: [sqlite] Cannot Find Syntax Error

the primary key should not be nil and it should be integer as well. if you want them all be unique then change you creation script create table hedge (hedge_id integer primary key autoincrement , hedge_name text) And change you insert statements as follow insert into hedge ( hedge_name) val

Re: [sqlite] Bind

chetana bhargav wrote: I am just wondering what will happen, if I bind a column with null intially, but later in my path if I bind some integer value, which value will be considered while excuting step function. Note its on the same prepared statement and before doing a reset of the statemen

Re: [sqlite] Bind

Hi Dennis, Sorry that I put my question wrongly, actually my question was, if before a step function is called, can I change the value that is bounded as many times as possible, and will the Step function only consider the value that was bounded last. . Chetana... Dennis Cote <[EM

Re: [sqlite] Re: Re: Cannot Find Syntax Error -- SOLVED!

>From the command line, you can use sqlite3 foo.db ".read load_hedges.sql" -Clark - Original Message From: Rich Shepard <[EMAIL PROTECTED]> To: SQLite Sent: Thursday, September 21, 2006 9:25:02 AM Subject: Re: [sqlite] Re: Re: Cannot Find Syntax Error -- SOLVED! On Thu, 21 Sep 2006,

Re: [sqlite] Re: Re: Cannot Find Syntax Error -- SOLVED!

On Thu, 21 Sep 2006, Clark Christensen wrote: From the command line, you can use sqlite3 foo.db ".read load_hedges.sql" Clark, Thank you. Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitting Applied Ecosystem Services, Inc.(TM)|Accelerator

Re: [sqlite] Bind

chetana bhargav wrote: Sorry that I put my question wrongly, actually my question was, if before a step function is called, can I change the value that is bounded as many times as possible, and will the Step function only consider the value that was bounded last. Chetana, Yes, that

[sqlite] Disabling locking?

I want to use SQLite with only one user executing queries sequentially , so I don't need locking. Is there a simple way to completely disabling locking? Specific instructions if possible please, thanks...

Re: [sqlite] Wish to store a C structure in sqlite column

Noel Frankinet wrote: > > Narendran a écrit : >> Dear Friends, >> >> >> I am in the process of forming a Generic API,(sql oriented and >> BerkelyDB >> and sister databases). In the process of integration ,i like to store a >> Structure in Sqlite. >> >> as far as my knowledge SQLITE allows m

Re: [sqlite] Disabling locking?

I want to use SQLite with only one user executing queries sequentially , so I don't need locking. Is there a simple way to completely disabling locking? Specific instructions if possible please, thanks... There are two kinds of locks. First one is a file lock, as in functions returning SQLIT

Re: [sqlite] Wish to store a C structure in sqlite column

Dear Friends, I am in the process of forming a Generic API,(sql oriented and BerkelyDB and sister databases). In the process of integration ,i like to store a Structure in Sqlite. as far as my knowledge SQLITE allows me to declare the column types suppoted by the programming languare or say

Re: [sqlite] Wish to store a C structure in sqlite column

Narendran a écrit : Noel Frankinet wrote: Narendran a écrit : Dear Friends, I am in the process of forming a Generic API,(sql oriented and BerkelyDB and sister databases). In the process of integration ,i like to store a Structure in Sqlite. as far as my knowledge SQLITE allows