Hi Dan,
It doesn't matter that it will never be written to. Since the variable is a
non-const static it will get mapped into the WSD portion of memory.
There are actually a few other global static variables that are getting
placed in the WSD section of memory.
Here is a list of non-const sta
On 29 May 2010, at 2:30am, Jim Terman wrote:
> I want the 'rowid' of the view. In other words I'd like to now what row
> John Smith is in the view. I can do it with a view that is ordered by
> using count(*), but I wondered if there was a better way.
I believe that a view is just a window into
I want the 'rowid' of the view. In other words I'd like to now what row
John Smith is in the view. I can do it with a view that is ordered by
using count(*), but I wondered if there was a better way.
Simon Slavin wrote:
> Or are you asking about the 'rowid' of the view ? I don't know whether
>
On 29 May 2010, at 1:44am, Jim Terman wrote:
> That's good to now about the automatic rowid. I can certainly create a
> new column in phonebook that shows the row number with id INTEGER
> PRIMARY KEY AUTOINCREMENT. However, I'd really would like to do the same
> thing in a view.
When you do y
That's good to now about the automatic rowid. I can certainly create a
new column in phonebook that shows the row number with id INTEGER
PRIMARY KEY AUTOINCREMENT. However, I'd really would like to do the same
thing in a view.
Simon Slavin wrote:
> On 29 May 2010, at 1:19am, Jim Terman wrote:
>
On 29 May 2010, at 1:19am, Jim Terman wrote:
> CREATE VIEW phonebook_order AS SELECT first_name, last_name,
> phone_number FROM phonebook ORDER BY last_name, first_name;
>
> Now on the table phonebook I can do a query:
>
> SELECT rowid FROM phonebook where last_name = "Smith" and first_name =
Say I have a table of phone numbers
CREATE TABLE phonebook (first_name TEXT, last_name TEXT, phone_number TEXT);
I want to sort this by name, so I create a view
CREATE VIEW phonebook_order AS SELECT first_name, last_name,
phone_number FROM phonebook ORDER BY last_name, first_name;
Now on the t
sqlite 3.3.6. I didn't realize it was so old. Thanks.
Igor Tandetnik wrote:
> Jim Terman wrote:
>
>> It looks like to me that CREATE TRIGGER IF NOT EXISTS is recognized by
>> sqlite, but I get the following from the command line:
>>
>> sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY, value TE
Jim Terman wrote:
> It looks like to me that CREATE TRIGGER IF NOT EXISTS is recognized by
> sqlite, but I get the following from the command line:
>
> sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY, value TEXT,
> timestamp DATE);sqlite> CREATE TRIGGER IF NOT EXISTS foo_log AFTER
> INSERT ON fo
It looks like to me that CREATE TRIGGER IF NOT EXISTS is recognized by
sqlite, but I get the following from the command line:
sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY, value TEXT, timestamp
DATE);sqlite> CREATE TRIGGER IF NOT EXISTS foo_log AFTER INSERT ON foo
BEGIN INSERT INTO foo (tim
Simon Slavin writes:
[...]
>
> Neither mainforms nor subforms are part of SQLite. Your problem is either
with ODBC or OpenOffice and
> you'll probably get better advice elsewhere.
[...]
But Mr. Werner is part of the team (http://www.sqlite.org/crew.html) and so a
working ODBC-Driver seems to
On 28 May 2010, at 6:04pm, Oliver Peters wrote:
> Despite using the very simple way to create the form (via assistant) I can't
> connect mainform and subform.
Neither mainforms nor subforms are part of SQLite. Your problem is either with
ODBC or OpenOffice and you'll probably get better advice
Hello,
configuration
-
OS- WinXP 32
sqlite- 3.6.23.1
odbc - 0.86 (http://www.ch-werner.de/sqliteodbc/)
frontend - OpenOffice.org (3.2. and 3.2.1 RC2 tested)
target
--
In "OpenOffice Base" I need a form where a mainform controls the appearance of
records in a su
I notice that the foreign key clause
(http://www.sqlite.org/syntaxdiagrams.html#foreign-key-clause) does not
include a conflict clause
(http://www.sqlite.org/syntaxdiagrams.html#conflict-clause). I always
specify "ON CONFLICT ROLLBACK" with my other constraints, but what will
happen when a foreign
On 28 May 2010, at 3:57pm, Michael Ash wrote:
> Per suggestions, I indexed year and media on the big table. So I now
> have separate indexes for the key variable (releasenumber) and for
> year and for media.Would it make more sense to have a single
> index for all three, thus:
>
> CREATE U
How many distinct media-types are there?
How many distinct facilities do you have?
How many rows are typically returned by your FacilityScore subquery?
SELECT facilitynumber,SUM(score_rev) AS score
FROM release_cl
WHERE media<3
AND year=2006
GROUP BY facilitynumber
Regards
Tim Romano
You also need to increase your cache size to match the mysql performance
pragma cache 10;
Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems
From: sqlite-users-boun...@sqlite.org on behalf of Michael Ash
Sent: Fri 5/28/2010 9:57 AM
To: sq
Thank you very much. Both replies pointed to indexes. So I changed
the indexes and markedly improved performance from 12 seconds to about
1.5 seconds for the faster variant (using nested SELECTS) and about
2.2 second for the slower variant.
Per suggestions, I indexed year and media on the big ta
Bingo, I live and learn
On 5/28/10, Igor Tandetnik wrote:
> Igor Tandetnik wrote:
>> Matt Young wrote:
>>> I second that documentation confusion. There is no truncate to
>>> integer, though I wish it would.
>>
>> Somewhat off-topic, but if you want truncation, this would do it: round(x
>> - 0.5
Igor Tandetnik wrote:
> Matt Young wrote:
>> I second that documentation confusion. There is no truncate to
>> integer, though I wish it would.
>
> Somewhat off-topic, but if you want truncation, this would do it: round(x -
> 0.5) .
Actually, cast(x as integer) works better. It follows the usu
On May 28, 2010, at 5:42 PM, Pavel Ivanov wrote:
>> It will retry the EXCLUSIVE lock each time a page that is not
>> in the cache is required by SQLite (a "cache-miss").
>
> If SQLite doesn't require to read any pages but only adds new pages to
> the file does it count as cache-miss?
Yes.
_
On May 28, 2010, at 1:11 AM, Kim, Albert wrote:
> Hi,
>
> We are compiling sqlite 3.6.23.1 with the SQLITE_OMIT_WSD compile
> time flag turned on. We are using the amalgamation. We found that
> this didn't completely eliminate the writable static data in our
> binary, and some investigat
Hi,
We are compiling sqlite 3.6.23.1 with the SQLITE_OMIT_WSD compile time flag
turned on. We are using the amalgamation. We found that this didn't
completely eliminate the writable static data in our binary, and some
investigation led me to this static variable:
SQLITE_PRIVATE VdbeOp *sqli
> It will retry the EXCLUSIVE lock each time a page that is not
> in the cache is required by SQLite (a "cache-miss").
If SQLite doesn't require to read any pages but only adds new pages to
the file does it count as cache-miss?
Pavel
On Fri, May 28, 2010 at 1:41 AM, Dan Kennedy wrote:
>
> On M
Matt Young schrieb:
> I second that documentation confusion. There is no truncate to
> integer, though I wish it would.
>
Try this,
SELECT CAST(4.5 AS INTEGER), CAST(ROUND(4.5, 0) AS INTEGER)
___
sqlite-users mailing list
sqlite-users@sqlite.org
ht
25 matches
Mail list logo