file has many pages, each page will
have to be exported and turned into a separate table, with any necessary
linking done through your Sqlite SELECT queries.
Michael Hooker
On 10/04/2008 20:57:03, John Grant ([EMAIL PROTECTED]) wrote:
> Hello,
>
> I'm new to database programming. I
implications, especially on a busy shared server.
Michael Hooker
- Original Message -
From: "Scott Baker" <[EMAIL PROTECTED]>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Monday, February 18, 2008 4:33 PM
Subject: Re: [sqlite
This is the syntax of a select statement as shown in the manual:
SELECT [ALL | DISTINCT] result [FROM table-list]
[WHERE expr]
[GROUP BY expr-list]
[HAVING expr]
[compound-op select]*
[ORDER BY sort-expr-list]
[LIMIT integer [( OFFSET | , ) integer]]
The bit you want is LIMIT[integer]. Say
ot;on date unknown" (). Over the years
I've got really fed up with database and spreadsheet programs that refuse to
accept an incomplete date in a date column - I can see why they do it, but
in real life data is often incomplete so you have to find other ways.
Michael Hooker
On 14/01
e is going to be a compromise.
Michael Hooker
On 08/01/2008 16:32:08, Mag. Wilhelm Braun ([EMAIL PROTECTED])
wrote:
there are a number of front ends to sqlite - I use sometime tksqlite.
http://reddog.s35.xrea.com/wiki/TkSQLite.html
maybe not exactly what you want - but it might be a starting point
u are very young :)
If you don't mind being patient all the list messages appear neatly sorted
at the URL below in due course, and you'll see what has arrived as well as
what has been sent:
http://www.mail-archive.com/sqlite-users%40sqlite.org/
Michael Hooker
On 10/11/2007 18:25:38, Don Lavelle (
on threads I have ever seen.
Thank you for not pretending that in fact it's all very straightforward,
which would make the rest of us feel inadequate.
Michael Hooker
On 29/08/2007 19:52:11, [EMAIL PROTECTED] wrote:
=?ISO-8859-1?Q?Daniel_=D6nnerby?= <[EMAIL PROTECTED]> wrote:
>
>
What folder are you in at the command prompt when you type "SQLite3
mydatabase.db3"?
Does it actually contain SQLite3.exe? If not, you need to specify the full
path, or navigate to the folder first.
Michael Hooker
On 23/08/2007 23:05:09, Dennis Achá ([EMAIL PROTECTED]) wrote:
cently added - he wrote these at my request when I was stuck, and I'm very
grateful to him.
If you need assistance with Delphi programming there is no shortage of
helpful people on Forums such as Tek-Tips. Obviously, this isn't the place
to deal with those issues.
Michael Hooker
- Or
s places we only find
months after we thought we'd failed to create them!
Michael Hooker
- Original Message -
From: "Griggs, Donald" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, August 07, 2007 1:51 PM
Subject: RE: [sqlite] Help Creating databas
time
I tried it on a live database the reporting application just went into "not
responding" mode. So we have to do it ourselves.
Thanks again
Michael Hooker
http://www.AvPhotosOnline.org.uk
- Original Message -
From: "Gerry Snyder" <[EMAIL PROTECTED]>
To:
sometimes the
snapshot it is supposed to give does not include items I know were received
into the system hours ago - while at other times things appear instantly.
So, calling the Windows CopyFile function from Delphi as I proposed counts
as copying "at the OS level", does it?
Th
my database work through the BDE until now
and never had any need to worry about locking or contentions.
Thanks
Michael Hooker
- Original Message -
From: "Christian Smith" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, June 18, 2007 6:39
>>The question is: the anterior way is the only way???<<
>>I think anterior means "before"... I'm no wordsmith...<<
Yes it does: David means "what I said before", or "the foregoing". He's
simply asking if there is another way.
t one, you create a new
database in the current directory - probably C:\.
All credit to Kees.
Michael Hooker
- Original Message -
From: "Stef Mientki" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Thursday, March 08, 2007 11:09 PM
Subject: [sqlite]
a lot!
Michael Hooker
- Original Message -
From: <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Thursday, March 01, 2007 2:28 AM
Subject: Re: [sqlite] developers mailing list, ignored patches
Adam Megacz <[EMAIL PROTECTED]> wrote:
I also printed out and sig
I have sent Ralf a long reply directly.
No criticism was intended, and eventually I expect to be as impressed by
DiSQLite as I am by SQLiteSpy. It's just that I can't make it work yet and
don't have the time for the steep learning curve.
Michael Hooker
-Original Message-
From: Ralf
date/time it's recorded, whichever
session it was recorded in.
Michael Hooker
-Original Message-
From: Fred Williams [mailto:[EMAIL PROTECTED]
Sent: 30 December 2006 16:01
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: RE: [sqlite] Using sqlite.exe
Don't know why you are using the
>>because it only would be helpful the first time
one uses the sqlite commandline shell.<<
No, this is not true. Some of us have very short memories! :)
Michael Hooker
-Original Message-
From: Kees Nuyt [mailto:[EMAIL PROTECTED]
Sent: 30 December 2006 17:07
To: sqlite-user
line programs a bit of a clue what's going on.
I have forgotten a lot since my DOS days!
Thanks once again - I can get on with my work now!
Michael Hooker
-Original Message-
From: Kees Nuyt [mailto:[EMAIL PROTECTED]
Sent: 30 December 2006 12:38
To: sqlite-users@sqlite.org
Subject:
Yes I know. But the database was definitely made with SQLite3. That's why I
asked specifically about SQLite3 databases!
Michael Hooker
-Original Message-
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: 30 December 2006 12:22
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: RE
database which simply won't work with
sqlite3.exe, but do work with SQLiteSpy? I have heard on the grapevine that
this database will not open in the freeware version of DisqLite 3 but does
in the commercial product, so it would seem that there is something odd
about it.
Michael Hooker
sence at a certain time - otherwise I'd just
use SQLiteSpy and copy and paste the data it displays.
Thanks in advance.
Michael Hooker
Surrey, England
-Original Message-
From: Ken [mailto:[EMAIL PROTECTED]
Sent: 29 December 2006 23:04
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: Re:
23 matches
Mail list logo