formula). If the Access 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
ave memory
implications, especially on a busy shared server.
Michael Hooker
- Original Message -
From: "Scott Baker" <[EMAIL PROTECTED]>
To: "General Discussion of SQLite Database"
Sent: Monday, February 18, 2008 4:33 PM
Subject: Re: [sqlite] which is faster, P
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 LIMI
--) or "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.
Mich
anything else 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 you 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
dvice 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:
or beginners which he
recently 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
erious places we only find
months after we thought we'd failed to create them!
Michael Hooker
- Original Message -
From: "Griggs, Donald" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 07, 2007 1:51 PM
Subject: RE: [sqlite] Help Creating database
Hi Kishore,
arate .csv file - and last 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"
hion anyway, as 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"
te. I've let
Delphi and VisualDB handle all 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:
Sent: Monday, J
>>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 w
right 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:
Sent: Thursday, March 08, 2007 11:09 PM
Subject: [sqlite] Argh, this must be a very
on something that irritates me a lot!
Michael Hooker
- Original Message -
From: <[EMAIL PROTECTED]>
To:
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 signed
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-
le
SQLite query will extract data by the 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
>>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
mmand 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
Subj
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]
Subjec
lite3 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.
Mich
happen automatically in my absence 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; [
23 matches
Mail list logo