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
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
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
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
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
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
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
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
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
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
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
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
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
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
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]
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
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
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
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
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
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
>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,
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
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
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...
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
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
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
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
29 matches
Mail list logo