I have a strange problem, I can do this:
UPDATE [Employees] SET
[EMAIL PROTECTED],
[EMAIL PROTECTED],
[EMAIL PROTECTED],
[EMAIL PROTECTED]
WHERE
[EMAIL PROTECTED]
But I can do this,
SELECT [LastName],[FirstName] FROM [Employees]
I have to remove the [] br
On Wed, 2005-03-02 at 16:53 -0800, R S wrote:
> I periodically delete older records from my table (which contains
> hundreds of thousands of entries). I want to reindex the table for
> more efficient access.
>
That is fully automatic in SQLite. REINDEX does not help.
REINDEX is only needed if yo
R S <[EMAIL PROTECTED]> writes:
> I periodically delete older records from my table (which contains
> hundreds of thousands of entries). I want to reindex the table for
> more efficient access.
An index is kept up-to-date as you insert and delete records, so there is
generally no need to re-index
I periodically delete older records from my table (which contains
hundreds of thousands of entries). I want to reindex the table for
more efficient access.
Thanks!
On Wed, 02 Mar 2005 18:20:39 -0600, Kurt Welgehausen <[EMAIL PROTECTED]> wrote:
> You can drop an index and later create it again.
>
You can drop an index and later create it again.
Why do you think you need to do that?
Regards
On Wed, 2005-03-02 at 22:04 +, Mr. Tezozomoc wrote:
> Does this mean that the in memory database can be accessed by more than one
> task without giving schema corruption?
> This is the problem I was having the 2.8.x... version...
>
No. You will still need to protect the accesses using mutex
Does this mean that the in memory database can be accessed by more than one
task without giving schema corruption?
This is the problem I was having the 2.8.x... version...
Tezo
Original Message Follows
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlit
Hi,
How do I programatically reindex a table in SQLite? Is it possible?
I did a search but didn't find much. I am using version 3.0.8
Thanks!
Hi all,
I’m trying to use sqlite3_get_table() to execute SQL commands on a database. I’ve
included a code snippet below.
The problem I’m having is that when I execute
the "SELECT MAX(time_stamp)
FROM table32;” command using sqlite3_get_table() I only get one column
and 1 row return
On Wed, 2005-03-02 at 19:35 +, Mr. Tezozomoc wrote:
> I have successfully port 2.8.15 to vxworks
> The in memory database is very problematic
>
Note that the in-memory database for version 3.x is
completely new and uses a different approach than the
in-memory database in version 2.8.x
I just recreated the table. Thanks for your input Jan.
Steve
Jan Ekström wrote:
Try this
13) How do I add or delete columns from an existing table in SQLite.
SQLite does yes not support the "ALTER TABLE" SQL command. If you
what to change the structure of a table, you have to recreate the
table.
I've gotten my first application up and running nicely with sqlite.
I wanted to say thanks to everyone for their hard work that made it
possible more quickly than I had imagined.
My project:
* An event management web site for a convention.
* Gentoo 2004
* Linux 2.4 kernel
* AMD Duron 600mhz w/ 2
Try the following
Jan
...
13) How do I add or delete columns from an existing table in SQLite.
SQLite does yes not support the "ALTER TABLE" SQL command. If you what to
change the structure of a table, you have to recreate the table. You can
save existing data to a temporary
Try this
13) How do I add or delete columns from an existing table in SQLite.
SQLite does yes not support the "ALTER TABLE" SQL command. If you what to
change the structure of a table, you have to recreate the table. You can
save existing data to a temporary table, drop the old table, create the
Hello again,
your answer in fact means that - although I specify my string is zero
terminated - the n-Member of the Mem-structure is indispensable when
inserting data to the DB?
Bernhard
- Original Message -
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To: "Bernhard DÃbler" <[EMAIL PROTE
I have successfully port 2.8.15 to vxworks
I have ported over to PPC604 and PENTIUM
The main catch here is the ... that there is no file locking in vxworks
This is the major problem.
You have to write your own wrapper to prevent multiple tasks accessing the
database...
I wrote my
Title: Message
I'm currently using
SQLite on Linux but I'm considering a port to VxWorks. Has anyone done
this successfully? Care to comment? I took a look thru the archives, there
wasn't a whole lot there. I'd be interested in knowing:
a) how
difficult/lengthy was the port
b)
pitfalls/
Steve Frierdich wrote:
Does anyone know how to add a column to an sqlite database through the
sqlite utility interface. I tried the SQL statement , ALTER TABLE table
Name ADD column variable, and it did not work. Anyone know any other way?
Thanks
Steve
http://www.sqlite.org/faq.html#q13
Does anyone know how to add a column to an sqlite database through the
sqlite utility interface. I tried the SQL statement , ALTER TABLE table
Name ADD column variable, and it did not work. Anyone know any other way?
Thanks
Steve
Shum [Ming Yik] wrote:
>Hi,
>
>I would like to ask ...:
>
>1.) Add
On Tue, 2005-03-01 at 12:59 -0500, G. Roderick Singleton wrote:
> On Tue, 2005-03-01 at 12:37 -0500, D. Richard Hipp wrote:
> > On Tue, 2005-03-01 at 11:36 -0500, G. Roderick Singleton wrote:
> > > I tried posting via gmane and was unsuccessful as this mailing list
> > > rejected the posting. I sub
The only way is to query one of the exported functions (sqlite3_version
or something like this). I agree, however, that it would be nice to have
a
version resource in the DLL. Also, If somebody would take the trouble to
do it, I would very much appreciate it if a proper MsVC project file ,
with app
Hi,
I would like to ask ...:
1.) Add dummy DTOS() ... and other functions into SQLite
So that perform same syntax with other SQLs...
ie.: SELECT * mytable where DTOS(TSTDATE)>='20050101' ...
Shum
www.mingyik.com
22 matches
Mail list logo