Good day,
SQLite version 3.3.17
Enter ".help" for instructions
sqlite> create table tbl1(t1 varchar(10));
sqlite> insert into tbl1 values('софт'); - lowChar
sqlite> insert into tbl1 values('СОФТ'); - upChar
sqlite> select * from tbl1;
софт
СОФТ
sqlite> select * from tbl1 where t1 like '%оф%'; -
It would be helpful if the maximum size was configurable per database
via a PRAGMA statement. That way you would be able to ensure a
non-critical database doesn't grow too large leaving no space for one
that is more important.
On 5/7/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Joe Wilson
Joe Wilson <[EMAIL PROTECTED]> wrote:
> --- [EMAIL PROTECTED] wrote:
> > Joe Wilson <[EMAIL PROTECTED]> wrote:
> > > I wrote too soon:
> > >
> > > http://www.sqlite.org/cvstrac/chngview?cn=3941
> > >
> > > + /*
> > > + ** Maximum number of pages in one database file.
> > > + */
> > > + #ifndef
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > I wrote too soon:
> >
> > http://www.sqlite.org/cvstrac/chngview?cn=3941
> >
> > + /*
> > + ** Maximum number of pages in one database file.
> > + */
> > + #ifndef SQLITE_MAX_PAGE_COUNT
> > + # define SQLITE_MAX_PAGE_COUNT
Joe Wilson <[EMAIL PROTECTED]> wrote:
> I wrote too soon:
>
> http://www.sqlite.org/cvstrac/chngview?cn=3941
>
> + /*
> + ** Maximum number of pages in one database file.
> + */
> + #ifndef SQLITE_MAX_PAGE_COUNT
> + # define SQLITE_MAX_PAGE_COUNT 1073741823
> + #endif
>
This #define doesn't
I wrote too soon:
http://www.sqlite.org/cvstrac/chngview?cn=3941
+ /*
+ ** Maximum number of pages in one database file.
+ */
+ #ifndef SQLITE_MAX_PAGE_COUNT
+ # define SQLITE_MAX_PAGE_COUNT 1073741823
+ #endif
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> --- Ron Stevens <[EMAIL PROTECTED]>
--- Ron Stevens <[EMAIL PROTECTED]> wrote:
> Is it possible to tell SQLite to limit the size that a database may
> grow to? It would be useful for storage constrained applications.
This is a tricky problem.
What would you have the database do if an insert failed upon reaching
the limit?
What
Is it possible to tell SQLite to limit the size that a database may
grow to? It would be useful for storage constrained applications.
-
To unsubscribe, send email to [EMAIL PROTECTED]
Notes on how I got sqlite running on hpux 11.0
To install sqlite on hpux:
* download sqlite-3.3.17.tar.gz from web site.
(I unzipped the file on linux using gunzip I think. Then copied
the tar file to /opt on the unix box. I guess gunzip works on hpux also.)
* cd to /opt and untar the file.
Aha, got it. Thanks!
On 5/7/07, Trey Mack <[EMAIL PROTECTED]> wrote:
> The 3.3.17 ZIP file seems to only contain 2 source files, instead of the
> full SQLite source. Is this on purpose?
It is the full source. See
http://www.sqlite.org/cvstrac/wiki?p=TheAmalgamation
and a big ol' thread at
The 3.3.17 ZIP file seems to only contain 2 source files, instead of the
full SQLite source. Is this on purpose?
It is the full source. See
http://www.sqlite.org/cvstrac/wiki?p=TheAmalgamation
and a big ol' thread at
The 3.3.17 ZIP file seems to only contain 2 source files, instead of the
full SQLite source. Is this on purpose?
http://www.sqlite.org/sqlite-source-3_3_17.zip
Thanks,
Dave
Yes, it is fine.
Thanks very much.
2007/5/7, Mohd Radzi Ibrahim <[EMAIL PROTECTED]>:
How about this?
update tablename set newcolname=(case rowid when 1 then 1 else 2 end);
best regards,
Radzi
- Original Message -
From: "Tomash Brechko" <[EMAIL PROTECTED]>
To:
I am definitely interested. I got the demo to work on my machine. So if you
could send the demo workbook, I would be much obliged.
Steve
bartsmissaert wrote:
>
> I have been using SQLite in Excel for the last half year now (in a
> commercial application) and I think I will be able to help.
>
DRH SAID:
[EMAIL PROTECTED] wrote:The details of the UPDATE or
DELETE are left as an exercise for the reader.
Excellent, it reminds me of High School integral proofs.
Q.E.D.
I have been using SQLite in Excel for the last half year now (in a
commercial application) and I think I will be able to help.
Currently I am using the wrapper written by Olaf Schmidt and this works very
well:
www.datenhaus.de/Downloads/dhSQLite-Demo.zip
If you are interested then I can send you
The .a file is for static linking.
The .sl file is for dynamic linking (shared library)
The .lib file is hidden because you were supposed to do a "make install" after
make which would install the .libs into whatever "prefix" you gave to
configure...
Static linking makes it easier for
Hi, I am developing a VBA app in excel 2003 and I would like to know how to
setup sqlite so that I can use it. I am a newbie when it comes to databases.
Currently I have installed the sqlite ODBC driver
(www.ch-werner.de/sqliteodbc/) and have created a database using
sqlitebrowser
C.Peachment,
You're right, I'm not the smartest or best programmer. I know that. But I
often get the job done in spite of my handicaps.
To keep from overloading the circuit I'll try to limit the number of
questions to one at a time.
I'm trying to install sqlite on HPUX. There's no HPUX install
Thank you both for your responses; Very informative. It is much
appreciated.
Regards,
- Jon
-Original Message-
From: C.Peachment [mailto:[EMAIL PROTECTED]
Sent: Monday, May 07, 2007 12:07 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] reseting primary key
On Mon, 7 May 2007
On Mon, 7 May 2007 11:28:57 -0400, Jonathan Kahn wrote:
>Hey all,
> I have tried different things such as reindex and vacuum on my primary key
>auto inc field but I cannot reset it so that things start from one. I
>deleted everything from my table but it still keeps the amount that was
>there
"Jonathan Kahn" <[EMAIL PROTECTED]> wrote:
>
> I have tried different things such as reindex and vacuum on my primary key
> auto inc field but I cannot reset it so that things start from one. I
> deleted everything from my table but it still keeps the amount that was
> there beforehand on the
On Mon, May 07, 2007 at 19:20:49 +0400, Tomash Brechko wrote:
> But with SQLite 3.x there is only one user data pointer per user
> defined aggregate function, so no parallel aggregate execution is
> possible.
Ah, I was too fast again :/. GROUP BY is really two-pass, but my
understanding why it
Hey all,
I have tried different things such as reindex and vacuum on my primary key
auto inc field but I cannot reset it so that things start from one. I
deleted everything from my table but it still keeps the amount that was
there beforehand on the auto inc so anything new is appened to that
On Mon, May 07, 2007 at 18:10:29 +0400, Tomash Brechko wrote:
> The solution with two table scans might be
>
> SELECT * FROM RESULT_TABLE a
> WHERE P = (SELECT MIN(P) FROM RESULT_TABLE b WHERE b.G = a.G);
>
> You may also try to play with indexes G, P.
>
> It seems to be impossible to do
Thanks, I've tried that - and it works great -
except that "TEST" is the result of a very complex subquery on
100,000X1000 rows
"JOIN"ing TEST to TEST runs the entire subquery twice - effectively
doubling
the execution time (I have very limited cache space).
Any suggestions that "scans" TEST
On Mon, May 07, 2007 at 15:38:22 +0300, Adler, Eliedaat wrote:
> I need to define a query that returns only the "first' row in each group
> - i.e. the row with the lowest display priority:
>
> - most preferably a query that doesn't require selecting RESULT_TABLE
> more than once.
The solution
How about something like this:
create table test
(
Grp text,
Val text,
Pri integer
)
insert into test values ('A', 'X', 1)
insert into test values ('A', 'X', 2)
insert into test values ('B', 'Y', 4)
insert into test values ('B', 'Z', 2)
insert into test values ('B', 'X', 8)
insert into test
On Mon, 7 May 2007, A.J.Millan wrote:
I couldn't find that sentence (CAST) in the SQLite doc, neither in the
Owens's book. Is it a SQL standard?, or a built-in SQL function? or a
SQLite built-in aggregate funcion?
CAST is part of the SQL-92 (and -99) standards.
Rich
--
Richard B.
Hi guys,
I have a complex query result set RESULT_TABLE that returns:
GVP
___
AX1
AX2
BY4
BZ2
BX8
CY6
CZ8
CX9
CY11
G
Hello, A.J.
Regarding:
I couldn't find that sentence (CAST) in the SQLite doc, neither in
the Owens's book. Is it a SQL standard?, or a built-in SQL function? or
a SQLite built-in aggregate function?
You'll want to see the *syntax* section of the website, under the very
useful page on
Hi all,
I have this view:
CREATE VIEW MY_VIEW AS
SELECT tip AS MYVIEW_TIP, abil AS MYVIEW_ABIL
FROM table1
UNION
SELECT tip,'S'
FROM table2
I have defined columns with declared type 'CHAR' in the original tables
If I use sqlite3_column_decltype to get my declared type I get CHAR for
Igor:
Thanks a lot. That korks!!
Thanks also publicly to Filip who mail me the same response directly, but
still I have a question:
I couldn't find that sentence (CAST) in the SQLite doc, neither in the
Owens's book. Is it a SQL standard?, or a built-in SQL function? or a
SQLite built-in
Of course there are may questions in your's post, but believe me, I
understand You because some months ago, and steel now, I feel exactly as
You. IMHO that is the matter pending in the SQLite proyect, although I
suppose that it is not a Hipp fault (who has done much more that enough for
all us),
34 matches
Mail list logo