On 2016-11-30 16:39, Werner Kleiner wrote:
<< All you need to store in the database table is the number. How it is
formatted for viewing or printing is controlled by the user interface.
yes thats right, but it would be nice to have same behavior between
MySQL and sqlite
I think to use a char dat
"Andy Gibbs" wrote on 1.7.2010 21:12:57:
>Miha Vrhovnik wrote on 1/7/2010:
>> >Content analysis details: (10.3 points, 7.0 required)
>> >
>> > pts rule name description
>> > --
>> >
"Andy Gibbs" wrote on 1.7.2010 15:05:01:
>Content analysis details: (10.3 points, 7.0 required)
>
> pts rule name description
> -- --
> 2.4 DNS_FROM_OPENWHOIS RBL: Envelope sender listed in bl.open-whois.o
I think he's trying to do sth. like that
SELECT quote FROM quotes ORDER BY RAND() LIMIT 1
On 5/8/2008, "John Stanton" <[EMAIL PROTECTED]> wrote:
>Sorting in random order is a definite contradiction in terms. What are
>you actually trying to do?
>
>Barbara Weinberg wrote:
>> Hi
>> I was wonderi
Someone sent a sqlite3_unicode.c file to this mailing list in the last week of
December, 1st week of January which implemented upper/lower and some other
functions. File was released as public domain if I remember correctly and used
data from Unicode 5.1 standard.
As ICU brings a lot of bulk i
Hi Mike,
Thanks for updated version, but still no drag n drop support for opening
database files :(
Regards,
Miha
"Cariotoglou Mike" <[EMAIL PROTECTED]> wrote on 29.11.2007 9:09:59:
>New version with a lot of enhancements to the user interface, also
>updated to be compatible with
>the late
> strip sqlite3.exe
is not ok at least for DLL, because it strips everything even reallocation info.
strip --strip-unneeded sqlite3.dll
Regards,
Miha
"Joe Wilson" <[EMAIL PROTECTED]> wrote on 21.4.2007 5:48:00:
>--- [EMAIL PROTECTED] wrote:
>> I'm using cygwin under windows XP.
>> gcc version 3.
I'm gonna cut all the content and say just one thing.
If Sqlite supported table partitioning this would be piece of cake without any
complications.
http://www.postgresql.org/docs/8.2/static/ddl-partitioning.html
--
It's time to get rid of your current e-mail client ...
... and start using si.Mai
Why don't you use mingw + msys enviroment?
Google for more.
Regards,
Miha
"Yuvaraj Athur Raghuvir" <[EMAIL PROTECTED]> je ob 3.10.2006 3:19:21 napisal(a):
>Hello,
>
>I have sync'ed and created the exe using Cygwin on Windows. I also have the
>libtool available.
>
>Now, I donot see the dll that
"Tony Harris" <[EMAIL PROTECTED]> je ob 18.6.2006 8:03:03 napisal(a):
>Or is there a way within the api that I haven't found to test for existance of
>tables?
SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;
SELECT name FROM sqlite_master WHERE type='index' ORDER BY name;
Regards
>Something like:
>
>SELECT A.ID
>FROM A
>LEFT JOIN B
>ON A.ID = B.ID
>WHERE B.ID IS NULL
>
>Might be more efficient?
Nope. I rewrote such query to SELECT ID FROM A WHERE ID NOT IN (SELECT ID FROM
B);
SELECT COUNT(*) AS unread FROM mboxes WHERE
idMbox = %d AND idMsg IN (SELECT idMsg FROM
msgStat
>This problem has been coming up with more and more frequency.
>I need to either figure out a solution or at least write up
>some official documentation on it.
I think that table partitioning as I purposed about a month ago would be
a solution if data is of nature, that it can be partitioned b
>The database already knows exactly where to look for each
>table when all the tables are in the same file. All it
>has to do is "lseek()" to the appropriate spot. How does
>moving tables into separate files help this or make it any
>faster?
What I had in my mind is this:
CREATE TABLE measureme
Hi drh and others,
Regarding the issues they appear on ML with very large tables and knowing
that sqlite now enforces constraint checks on tables, is there any
chances of suporting table partitoning?
Regards,
Miha
On 3/21/2006, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>"Miha Vrhovnik" <[EMAIL PROTECTED]> wrote:
>> Hi drh and others,
>>
>> Regarding the issues they appear on ML with very large tables and knowing
>> that sqlite now enfor
using sqlite 3.2.8.
CREATE TABLE movies (id INTEGER PRIMARY KEY, catalogIDNumeric INTEGER);
INSERT INTO movies (catalogIDNumeric) VALUES(1);
INSERT INTO movies (catalogIDNumeric) VALUES(2);
INSERT INTO movies (catalogIDNumeric) VALUES(3);
INSERT INTO movies (catalogIDNumeric) VALUES(5);
INSERT INT
juan perez <[EMAIL PROTECTED]> je ob 3.12.2005 17:16:00 napisal(a):
>There is a "nocase" collation for that purpose.
>
>jp
Which works only on ASCII characters I need unicode version of Lower function.
Regards,
Miha
Does anybody know how to add custom function to sqlite3 in Delphi? Cariotoglou
Mike?
I'd like to add function 'Lower' so I can match case insenisitive text columns
in table.
Regards,
Miha
[EMAIL PROTECTED] je ob 30.9.2005 12:22:47 napisal(a):
>(Side note: I am experimenting with a new Mail User Agent that
>uses SQLite to store all its email messages. I appologize in advance
>if this message is misformatted or otherwise garbled.)
Am. Who stole that idea from me?
--
It's time to g
"Igor Tandetnik" <[EMAIL PROTECTED]> je ob 17.9.2005 16:20:03 napisal(a):
>Why did you expect the latter? DISTINCT in SELECT DISTINCT detects
>identical rows, not identical first columns. The three first rows with
>an id of 1 differ in the columns you chose not to show (specifically in
>the map.d0
Hi!
I think there is a bug in SELECT DISTINC. I'm using sqlite 3.2.5 dll
CREATE TABLE t1(id INTEGER PRIMARY KEY, d0 INTEGER, d1 TEXT);
CREATE TABLE map(idT1 INTEGER , d0 INTEGER);
INSERT INTO t1 VALUES(1, 1, 'dd');
INSERT INTO t1 VALUES(2, 1, 'dd');
INSERT INTO t1 VALUES(3, 1, 'dd');
"D. Richard Hipp" <[EMAIL PROTECTED]> je ob 5.9.2005 18:45:42 napisal(a):
>SQLite has *never* supported the ability of a handle to be used
>by more than one thread. By luck, such use would sometimes work on
>some operating systems. But it would fail on others. Such a
>situation is very dangerou
"Cariotoglou Mike" <[EMAIL PROTECTED]> je ob 5.9.2005 14:49:54 napisal(a):
>ok.
>I use sqlite3Explorer (which should not matter), I create a new
>database, then I run :
>
>create table test1(id integer);
>analyze
>
>this crashes immediately, with dll 3.2.5. it works fine from the
>command-line.
>
>ALL: can you verify that the DLL API crashes on ANALYZE ? (WINDOWS,
>obviously)
- Precompiled version of 3.2.5,
- run with Sqlite Explorer 1.6
- winXP Pro SP2
Run without problems.
Regards,
Miha
Hi,
sqlite dll is 3.2.1
I have the folowing query:
SELECT * FROM Mactor WHERE id < 9223372036854775807 ORDER BY id DESC LIMIT 1;
where 9223372036854775807 is Maximum value of signed Int64.
Table is defined as:
CREATE TABLE Mactor (
id INTEGER PRIMARY KEY,
name TEXT,
birthName TEXT,
birthday D
25 matches
Mail list logo