I understand that SQLite is good to learn something about sql.
I downloaded:
sqlite3-3.1.5.bin.gz ---> for SQLite
tclsqlite-3.1.5.so.gz ---> for Tcl
Now, in order to try and build some simple web page containing tcl,
and see whether I can do some simple thing with it, where do I have to
put the
[EMAIL PROTECTED] wrote:
Witold Czarnecki wrote:
You may use operator "ISNULL" instead. For example "SELECT x FROM
table WHERE y ISNULL".
Best reagrds,
Witold
- Original Message - From: <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Sunday
Witold Czarnecki wrote:
You may use operator "ISNULL" instead. For example "SELECT x FROM
table WHERE y ISNULL".
Best reagrds,
Witold
- Original Message - From: <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Sunday, March 06, 2005 2:12 PM
Subject:
Hi All,
I don't think sqlite support isnull function, but I wonder is there
other function has same functionality but different name?
thanks,
Ming
[EMAIL PROTECTED] wrote:
D. Richard Hipp wrote:
On Mon, 2005-02-28 at 19:14 -0400, [EMAIL PROTECTED] wrote:
How about the sqlite3_mprintf and sqlite3_vmprintf functions? are
they for the legacy users only?
It is unclear how to add UTF-16 support to those functions.
But they are used
D. Richard Hipp wrote:
On Mon, 2005-02-28 at 19:14 -0400, [EMAIL PROTECTED] wrote:
How about the sqlite3_mprintf and sqlite3_vmprintf functions? are they
for the legacy users only?
It is unclear how to add UTF-16 support to those functions.
But they are used internally so
Hi All,
Anyone have idea when sqlite will support sqlite3_exec16. Since
sqlite3_exec return important error information for the execution error.
Supporting exec16 is urgent for unicode application.
Ming
that appear
identical will not match because of floating point precision
and Microsoft display routines that do not display fractional seconds.
--- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
Hi All,
I want to store MFC date (CTime or COleDateTime) value in sqlite, but
Anyway get get Unix Epoch Time in Windows MFC, or win32?
[EMAIL PROTECTED] wrote:
Ming:
I asked the same question about two weeks ago to this same list. I was
directed to the following location:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
I ended up saving my date/time in Unix
Hi All,
I want to store MFC date (CTime or COleDateTime) value in sqlite, but
don't know what is the best way to store it. I am running into trouble
when I store date as Text in sqlite, because I can't no longer apply
sqlite date time functions( datetime(), date()...) to it. Result in I
can't
I have installed the cygwin, since I may need to CVS source code in the
future as well. Please show us how to preprocessing the source-code
checked out from CVS.
Thanks,
Ming
D. Richard Hipp wrote:
On Sun, 2005-02-13 at 19:45 -0400, [EMAIL PROTECTED] wrote:
Please show us how to compile
Hello All,
I wonder does anyone know the new compiled sqlite from CVS can't run in
Windows, it always crashes since last week??
Thanks,
Ming
Hi !
I have a Delphi SQLite wrapper.
It can Open database, run sql-s, etc.
But I don't know, how to I set page size, because when I do open in
database, the pragma is not working, and when I try to exec sql before
open database, the wrapper is say: database not opened...
Anybody have an example
roblem
is.
--- [EMAIL PROTECTED] wrote:
Hello!
Can anyone help here. It looks like a bug in the 3.1.1beta?
i think from 3.1.1beta:
---
SELECT t1.ID, (SELECT COUNT(*) FROM t2 WHERE t2.ID=t1.ID) FROM t1
In other words, in a subselect backreferencing to a field in its
parent select.
Now sup
Hello,
My application requires records in a table to be arrange in order. I am
uisng ID (Integer Primary Key) filed to keep track order.
When I want to insert a record between some records, I am trying to do
following SQL:
--
update pb_transactiondetail set ID = ID + 1 where ID >10; (Error:
Hi !
An interesting enchantment may be (if anyone development that) an
"VACUUM INFILE" method.
That is (when many pages are unuseable (free) in db) a "pragma signed"
transaction.
If flag is -1, the db engine is use the last, and nearly to last pages.
When flag is 1, the engine is use first, and
Hi !
My question is that: I use hungarian (win1250, iso-8859-2) character
set, what containing special accented characters:
a' - á
e' - é
and etc.
I want to sort my sql by this collation order.
But I cannot do that, only with outer programme (I use Delphi wrapper
library).
1. Can I do that
Hi All,
I am using Sqlite 3.1.0 with a MFC SDI project. I want Sqlite database
to be my file format of SDI, which I can open, close and save through
(File) menu. Does anyone have experience with this and know how to do it?
Thank you in advance.
Ming
Thank you. That answers my question.
Awesome Sqlite!
Darren Duncan wrote:
At 9:49 PM -0400 1/28/05, [EMAIL PROTECTED] wrote:
Hi All,
I wonder does Sqlite have feature such as join two string fields
together.
e.g: Select FirstName + LastName From Username
Thank you,
Ming
The '+' is a numerical
Hi All,
I wonder does Sqlite have feature such as join two string fields together.
e.g: Select FirstName + LastName From Username
Thank you,
Ming
Hi All,
First, Thank you for excellent piece of software!
I am finding following problem would like to share:
---
SELECT a FROM [table] GROUP BY a;
Error Message in Sqlite 3.1.0 alpha: "SQL error: GROUP BY may only be
used on aggregate queries"
---
I test this sql in
I use eMbedded Visual C++ 4.0 with de 3.0.8 Wrapper created
by Rob Groves that you will find in
http://www.codeproject.com/database/CppSQLite.asp and with
de WinCE port http://sqlite-wince.sourceforge.net/ created by
Nuno Lucas.
You will find a manual steb-by-step of install this WinCE port in
my
ck your return codes.
>
>COMMIT ends the transaction. The END is redundant.
>
>
>--
>D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
>
>
>
>
- --===176C28DF===--
-BEGIN PGP SIGNATURE-
Version: PGP 8.0.3
iQA/AwUBQbBpE8pHmxag5XckEQJjogCZAcJxdn/xqZ2BGkIdrkjGLyDmrO4AoPT9
Yom25cqVcvtGZ3aUDvX2WP0H
=Qdrd
-END PGP SIGNATURE-
Hello,
and yes I do. I've tried to port, but without success.
Best regards
Am Thu, 16 Sep 2004 00:31:54 -0700 hat Randy J. Ray <[EMAIL PROTECTED]>
geschrieben:
Cory Nelson wrote:
I take it you were too lazy to look at the SQLite Wrappers section?
http://www.sqlite.org/cvstrac/
909 379 2
# privat: (+49 29 41) 959 702 7
# --
# email: [EMAIL PROTECTED]
#
###
ivat: (+49 29 41) 959 702 7
# --
# email: [EMAIL PROTECTED]
#
###
> The code is Cocoa-based, but could easily be adapted to other
> languages. I could build a GUI environment to alter a table and to
> generate the SQL statements as well, I don't see what the problem is.
> As I said earlier, the issue with the workaround is that it has to
> copy the entire table
> Bert Verhees wrote:
> >
> > The workaround for ALTER TABLE is not useable in SQL-code generating
> > environments.
>
> Sorry for being dense, but can you elaborate on the above? Why can't
> such code be generated?
Let me explain, I guess I did no express myself clear.
There is quit some
support...
-- KL
On Wed, 17 Mar 2004 6:48:55 +
"Nuno Lucas" <[EMAIL PROTECTED]> wrote:
> Oops...
> I realize now that the fix for compiling for windows when UNICODE is defined is in
> my TODO list.
> I was waiting for it to be fixed in the main code,
ds
alex-t
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Pierre-Alain Joye wrote:
On Sun, 15 Feb 2004 13:10:59 -0800
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
Im a bit confused as to where i get a sqlite.so for php.
When i build sqlite from source it does not place a sqlite.so anywhere
in my system.
Using 'pear install sqlite' i
.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
you have a mailing list archives somewhere I could search through ?
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
x creation on functions (aka the date
> >> functions)?
> >
> > Yes.
>
>
> ---------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
---------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Date sent: Thu, 01 Jan 2004 23:42:17 +0100
To: [EMAIL PROTECTED]
From: Hennie Peters <[EMAIL PROTECTED]>
Subject:Re: [sqlite] Find a row
> to get the number of rows:
> select count(*) from testtableint;
> or th
we are here, is there a way to retrieve the number of rows a table has
without getting all the rows?
thanks in advance
Bert Verhees
-----
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
t maybe this helps to find the answer
Bert Verhees
-----
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
d regards
Bert Verhees
>
> Thanks for any help in advance.
>
> Eugenel
>
>
-----
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-- Initial Header ---
>From : "Gerhard Häring" [EMAIL PROTECTED]
To : "sqlite-users" [EMAIL PROTECTED]
Cc :
Date : Fri, 21 Nov 2003 16:43:26 +0100
Subject : Re: [sqlite] database is locked
> [EMAIL PROTECTED] wrote:
>
of
people who concern about UNICODE (UTF-16) among users of
SQLite. (Also please refer to
Message-Id: <[EMAIL PROTECTED]> of this list)
For me I choose SQLite for its performance therefore I'm strongly
against implicit WideCharToMultiByte inclusion in SQLite. I rather
like to see MS-Windows-style int
o to avoid this behavior?
Any help would be very appreciated.
Thank you,
Jo
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-- Initial Header ---
>From : "Fouejieu louis" [EMAIL PROTECTED]
To : [EMAIL PROTECTED]
Cc :
Date : Mon, 10 Nov 2003 14:49:47 +
Subject : Re: [sqlite] COPY
> >Hi all,
> >
> >I would like to know if it is pos
Hi all,
Has anyone got SQLite working with ODBC?
I installed SQLite in Linux and I would like to access it from Windows98.
Jo
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
st practices' that have been honed over the [many] years
> and be done with it. I believe it was *YOU* who were banging this drum,
> rather than just leaving the issue alone.
>
> > OK, let's vote, there is no othe
101 - 144 of 144 matches
Mail list logo