I have two questions. First of all, what tools does anyone use to convert
data from Access to SQLite? Second, I used DBTools to do a data conversion
(Access to SQLite), and the size of the database went from 5 tables and
around 6MB to 1 table and around 10MB (I only needed one of the 5 tables).
A
Hi George,
I didn't know that you could ORDER BY within a view, SQL Server and DB2
don't allow this. However in my case this isn't a solution as we have grids
where the user can decide which field to order by.
I do notice that this works.
SELECT *
FROM tabTest_1, tabTest_2
WHERE Fi
Bonjour,
I'm testing the Driver - quite successfully I must say - on Win2000.
What I'm failing to do is to create a record with an autoIncremental Primary
Key from OpenOffice (Datasource view or Writer form).
The frustrating thing is that from MS Access (2000), it is working properly,
just with
Does anyone know how to inspect and manipulate
data in an in memory DB ?
regards, Jonas
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Glad the solution works, but I'm not sure why it defeats the point of
having views in the first place. You can certainly have more
interesting selects in a view than * with the order by. How do you feel
this negates the purpose of views?
-George
Fitzharris, Jason wrote:
Hi George,
I didn't
Hello,
A trigger on update and delete on sqlite_master calling a registered c
function seems to be a good way to update a tree-view showing the db
catalog, but sqlite doesn't like it.
Is there a technical reason to avoid trigger on system table.
Any work around ?
Thanks
Noël
-
Our system is customisable, in that the users can add extra fields and
tables, or create their own views, or customise the existing views to suit
themselves.
Hardcoding SELECT's within the software would seriously degrade the
flexibility of the product. By having the product do a SELECT * on a vie
Fitzharris, Jason wrote:
Hi,
I am getting an error when trying to do an order by on a view which has a
join. To replicate, create the following two tables and the view.
CREATE TABLE tabTest_1 (
Field_1_1 CHAR(10),
Field_1_2 CHAR(10),
Field_1_3 CHAR(10),
Field_1_4 CHAR(10)
)
CREATE TABLE t
Is there a way to know which functions in the API were available in which versions?
If there's no other way, could you perhaps make a complete tarball of the CVS
repository available to me, Richard?
Thanks,
-- Gerhard
-
To uns
Thanks, I tried the square brackets with the table name qualifier and it
worked fine.
By the way, great product. I'm so used to the bloatware of Microsoft, IBM
and Oracle that I just can't figure out how you could develop a very
functional database with one small dll.
Regards,
Jason.
-Origin
Liz Steel wrote:
I'm doing a select on a table as follows, and I want to get the last
item in the list. How can I do this without having to step through all
of the previous items? This may or may not return 100 rows since I
cannot be sure of the size of the data.
select * from tablename where t
Nope - that just gets the one closest to the date I specified. Perhaps you
meant to use "asc" instead of "desc", but that gets the oldest one in the
list.
What I'm trying to do is get the timestamp of 100th (or less if there are
less than 100 previous items) previous item in the list.
Thanks,
I'm doing a select on a table as follows, and I want to get the last item in
the list. How can I do this without having to step through all of the
previous items? This may or may not return 100 rows since I cannot be sure
of the size of the data.
select * from tablename where timestamp < '2003/
I've solved it!
select * from (select * from hooverobject where timestamp < '2003/12/04
12:00:00:000' order by timestamp desc limit 100) order by timestamp asc
limit 1
Liz.
_
It's fast, it's easy and it's free. Get MSN Messenger t
SQLite illuminati,
Some questions:
1. If the integer primary key (say, tbl_pers.pers_id) is the b-tree value
for
the row, is it necessary to compose update triggers to handle a DELETE FROM
tbl_pers WHERE pers_id=5; for all of the tables holding pers_id as a foreign
key?
2. I want to update t
Version 2.8.7 of SQLite is now available on the website.
This release includes several new experimental APIs and
some changes and improvements to the experimental date/time
functions. If you have been keeping up with the changes
in CVS, there is nothing new here. I just felt it was
time to packa
Eric Pankoke wrote:
I have two questions. First of all, what tools does anyone use to convert
data from Access to SQLite? Second, I used DBTools to do a data conversion
(Access to SQLite), and the size of the database went from 5 tables and
around 6MB to 1 table and around 10MB (I only needed one
Liz Steel wrote:
Also, how do I access the archive of messages sent to this list now
that it's moved from Yahoo?
Thanks to WWW::Yahoo::Groups, a magnificent Perl module, I archived the
old messages:
http://www-lnc.usc.edu/~brannon/sqlite-mail-archive/ungzipped/new/
You can get a tarfile of
In access, I use the following statement to select a random row: "SELECT TOP 1 * FROM
Questions WHERE Not QuestionID IN (0) ORDER BY RND(QuestionID)". How might I
accomplish this same thing in SQLite?
--
Eric Pankoke
Programmer
Christian Family Software
http://www.christianfamilysoftware.com/
The schema is defined as follows (according to DBTools):
Book varchar(10)
Chapterinteger
Verse integer
VerseText memo
--
Eric Pankoke
Programmer
Christian Family Software
http://www.christianfamilysoftware.com/
> Eric Pankoke wrote:
> > I have two questions. First of all, what too
[EMAIL PROTECTED] wrote:
In access, I use the following statement to select a random row: "SELECT TOP 1 * FROM Questions WHERE Not QuestionID IN (0) ORDER BY RND(QuestionID)". How might I accomplish this same thing in SQLite?
select * from questions ... order by random() limit 1;
Frank
-
21 matches
Mail list logo
