ArbolOne wrote:
I have downloaded the latest version of SQLite as well as the make file
in the ticket #931 http://www.sqlite.org/cvstrac/tktview?tn=931
However, after typing 'make' I get a message that saying ' No rule to
make target 'src/sqlite.h.in', how do I solve this problem?
Read
ma., 27.04.2009 kl. 14.58 +0200, skrev Kent Dahl:
We've been giving the SQLite 3.6.10 amalgamation source code for Windows
a try against RTOS 5.14 and it compiled out of the box. However, we ran
into some linker and run-time errors. After a fair amount of
experimenting, we got it up and
Hello
2009/6/26 Alberto Simões hashas...@gmail.com:
I am trying to find words in a dictionary stored in sqlite, and trying
a near miss approach.
For that I tried an algorithm to create patterns corresponding to
Levenshtein distance of 1 (edit distance of 1).
That means, one adition, one
I have this:
select title,my_rating
from movies left join user on movies.id = user.id
where id = 'tt0426459'
The result:
ambiguous column name: id
I could use:
select movies.id ids,title,my_rating
from movies left join user on movies.id = user.id
where ids =
On 1 Jul 2009, at 5:24pm, Yuzem wrote:
Is there any way to specify that movies.id is equal to user.id so I
can use
just id in my query?
I think you have already come up with the two best solutions. You
could also create a VIEW
http://www.sqlite.org/lang_createview.html
and specify
You can do only
where movies.id = 'tt0426459'
or
where user.id = 'tt0426459'
What to choose depends on your needs. And you're wrong that these
variants are identical and movies.id is always equal to user.id
because you're making left join. They will be identical if you will
make inner join. But
Yuzem wrote:
Is there any way to specify that movies.id is equal to user.id so I can use
just id in my query?
Thanks in advance!
Not with a left join, but with an inner join you can use the USING
clause or a NATURAL join. See
http://en.wikipedia.org/wiki/Join_(SQL)#Equi-join for more
Hello,
In the course of copying a largish (20 GB) database file while
accessing it via sqlite3, the machine became very unresponsive. I
opened task manager and found that the system was using a huge amount
of virtual memory, causing it to thrash. Per-process memory usage
looked normal and did not
howdy!
Would there be a way to identify the offending constraint if
SQLITE_CONSTRAINT is returned?
sqlite3_errmsg is just telling me constraint failed...which is of
limited usefulness.
-James
___
sqlite-users mailing list
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
James Gregurich wrote:
howdy!
You hijacked someone else's thread by hitting reply, rather than
starting a new one. That is very poor netiquette.
Would there be a way to identify the offending constraint if
SQLITE_CONSTRAINT is returned?
Sorry for the newbie SQL question. I'm trying to use the INSERT INTO
statement with a hexadecimal literal. I want to accomplish something
like this:
INSERT INTO TruckDefaultsTable VALUES ( 'AirPressureTime', 0, 0xB4);
sqlite chokes on the 0xB4 expression with:
unrecognized token:
Hi Ben,
I hit this a few months ago. Hex literals have to contain an even
number of hex digits. For that discussion, see:
http://www.nabble.com/Hexadecimal-Inequalities-Failing--td20216982.html
Thank you,
How would I have hijacked a thread? I changed the subject and
removed the original text.
On Jul 1, 2009, at 12:32 PM, Roger Binns wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
James Gregurich wrote:
howdy!
You hijacked someone else's thread by hitting reply, rather than
On Wed, Jul 1, 2009 at 3:39 PM, James Gregurichbayouben...@mac.com wrote:
How would I have hijacked a thread? I changed the subject and
removed the original text.
...
that is exactly how a thread is hijacked... changing the subject is
not enough. Every message has a unique id that is used by
Erg, I can almost count. Sorry, the correct way to specify a hex literal
is in that thread too. If you use x'value' you can enter the bits.
Thank you,
Clay
On Wed, 1 Jul 2009, Clay
ah. I have no knowledge of how mailing list programs work. no poor
etiquette was intended.
On Jul 1, 2009, at 1:41 PM, P Kishor wrote:
On Wed, Jul 1, 2009 at 3:39 PM, James Gregurichbayouben...@mac.com
wrote:
How would I have hijacked a thread? I changed the subject and
removed the
Ben Atkinson bwa4...@yahoo.com wrote:
Sorry for the newbie SQL question. I'm trying to use the INSERT INTO
statement with a hexadecimal literal. I want to accomplish something
like this:
INSERT INTO TruckDefaultsTable VALUES ( 'AirPressureTime', 0,
0xB4);
Does SQL have a hex literal
Basically, I would like to be able to query one table based on criteria
entered into another table.
I have attached an excel file with a couple of hours of monitoring data, the
10 minute data has been interpolated to give minute answers (as MOEData Tab
in the excel sheet).
This Table of Data
JokBoy andrew.lind...@westnet.com.au wrote:
Basically, I would like to be able to query one table based on
criteria entered into another table.
I have attached an excel file with a couple of hours of monitoring
data, the 10 minute data has been interpolated to give minute answers
(as MOEData
On 1 Jul 2009, at 8:19pm, James Gregurich wrote:
Would there be a way to identify the offending constraint if
SQLITE_CONSTRAINT is returned?
sqlite3_errmsg is just telling me constraint failed...which is of
limited usefulness.
Instead of the constraint, you could define a trigger, and
Igor,
I have tried your query and I don't get any rows returned. Any ideas why it
wouldn't work?
Regards
Andrew
--
View this message in context:
http://www.nabble.com/Help-with-SQLite-Query-tp24297858p24298529.html
Sent from the SQLite mailing list archive at Nabble.com.
Language: VB6
In my project, I create a Table that holds specific information based on a
User's selection.
When the user runs a new selection, my procedure that creates this table is
run again to recreate the table but with new information.
However, the problem I have is that since the
On Wed, Jul 1, 2009 at 5:29 PM, Rick Ratchfordr...@amazingaccuracy.com wrote:
1. Determine if the table has already been created due to a prior run.
2. If so, to remove the information currently in that table and replace it
with new information.
I'm not sure how to determine whether the
DROP TABLE Foo;
-- It's okay to execute this command, even if Foo does not exist
already.
Hello David. Thanks for your reply.
The above Drop Table created an error when I tried to run it when no table
existed.
CREATE TABLE Foo ( ... );
Forgive my novice ignorance. Although I have
Okay, I found what needed to be added to DROP TABLE to make it not produce
the error.
DROP TABLE IF EXISTS Foo
That did the trick.
Still haven't figured out how to get the test result from...
SELECT count(*) FROM sqlite_master WHERE tbl_name = 'Foo';
If this returns 1 or 0 based on whether
thanks.
I tried that, but I still got back constraint failed rather than my
RAISE message. Since you say it should work, I probably did something
wrong. I'll look at it again.
On Jul 1, 2009, at 3:59 PM, Simon Slavin wrote:
On 1 Jul 2009, at 8:19pm, James Gregurich wrote:
Would there
I'm using sqlite to do some analysis on very large web application log
files - approaching 3 million lines per day. And what a wonderful tool
it is! It has saved me from writing lots of custom scripts.
I have a perl script that parses an rsynced copy of this huge log file,
munges, converts,
On 2 Jul 2009, at 1:22am, Rick Ratchford wrote:
Okay, I found what needed to be added to DROP TABLE to make it not
produce
the error.
DROP TABLE IF EXISTS Foo
That did the trick.
Still haven't figured out how to get the test result from...
SELECT count(*) FROM sqlite_master WHERE
Hello community!
I have three table like this:
Device(id,name,icon,type) -id as primary key
ZWavePhsicalDevice(id,funcode) -id as primary key
ZWaveGSDevice(Device.id, ZWavePhsicalDevice.id,order)
-Device.id and ZWavePhsicalDevice.id as mutil primary keys.
Now, I don't know how to build the
On 2 Jul 2009, at 2:00am, yaconsult wrote:
For testing purposes, I created indexes
for all the columns used in the selects below.
This doesn't do what you want. For instance, suppose I had a huge
amount of data in this table:
description | date | time
On 2 Jul 2009, at 1:57am, James Gregurich wrote:
I tried that, but I still got back constraint failed rather than my
RAISE message. Since you say it should work, I probably did something
wrong. I'll look at it again.
If you left the constraint definition in in your table definition then
On Wed, Jul 1, 2009 at 6:05 PM, Rick Ratchfordr...@amazingaccuracy.com wrote:
I'm using a VB wrapper, and so I run this by...
Cnn.Execute Select count(*) FROM sqlite_master WHERE tbl_name =
'DeltaGrid'
Thing is, I don't know where to check for the return value.
I'm afraid I can't help
JokBoy wrote:
I have tried your query and I don't get any rows returned. Any ideas
why it wouldn't work?
If you tried it against the database file you showed in your original
post, note that you have MOEData.Date in different format from
Criteria.StartTime_crit and EndTime_crit. Recall that
Kermit Mei wrote:
I have three table like this:
Device(id,name,icon,type) -id as primary key
ZWavePhsicalDevice(id,funcode) -id as primary key
ZWaveGSDevice(Device.id, ZWavePhsicalDevice.id,order)
-Device.id and ZWavePhsicalDevice.id as mutil primary keys.
Now, I don't know how to build
Although I'm going to use the easier DROP TABLE IF EXISTS... line as this
works wonderfully.
The only reason I asked about the other method you mentioned is that I
wanted to at least understand how it worked. The more one knows, the easier
it gets later on.
Anyway, I think I may know how the
On Wed, Jul 1, 2009 at 9:50 PM, Rick Ratchfordr...@amazingaccuracy.com wrote:
From what I understand, ANYTIME you do a SQL statement, such as SELECT...,
you are doing this to a TABLE and returning the result in a sort of
'recordset'.
So then, the table is this sqlite_master, the field is
On Wed, 2009-07-01 at 22:45 -0400, Igor Tandetnik wrote:
Kermit Mei wrote:
I have three table like this:
Device(id,name,icon,type) -id as primary key
ZWavePhsicalDevice(id,funcode) -id as primary key
ZWaveGSDevice(Device.id, ZWavePhsicalDevice.id,order)
-Device.id and
37 matches
Mail list logo