On Mon, 24 Jan 2005, Dan Kennedy wrote:
Does SQLite have any specific ordering requirements for how triggers
are created? I have a case where an 'UPDATE BEFORE' trigger will
not work as expected if an 'UPDATE AFTER' trigger on the same table (but
not the same column) is created after it is.
On Mon, Jan 24, 2005 at 09:09:29PM -, Lee Wenchian Civ AFRL/IFTC wrote:
>
> When creating a table, according to the syntax, a column can be specified
> with DEFAULT column constraint and "The DEFAULT constraint specifies a
> default value to use when doing an INSERT ...If the value is
>
> Does SQLite have any specific ordering requirements for how triggers
> are created? I have a case where an 'UPDATE BEFORE' trigger will
> not work as expected if an 'UPDATE AFTER' trigger on the same table (but
> not the same column) is created after it is.
Shouldn't do. What are the
My tip and advice would be to stop sending the same message over and
over.
Bob
-Original Message-
From: Ramon [mailto:[EMAIL PROTECTED]
Sent: Monday, January 24, 2005 12:55 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] download db - security question
I was wondering if someone can
The date/time keywords that you're using are not implemented
in the stable releases of SQLite. They're in verion 3.1 (alpha),
so any day now.
Regards
sqlite> Insert into TemperatureData (tempt) values(86.0);
sqlite> select * from temperaturedata;
40.2|
86|CURRENT_TIMESTAMP
--- Begin Message ---
Brass Tilde wrote:
Create table TemperatureData ( Tempt real, TimeStamp default
CURRENT_TIMESTAMP);
Insert into TempertaureData values( 40.2,
Brass Tilde wrote:
Create table TemperatureData ( Tempt real, TimeStamp default
CURRENT_TIMESTAMP);
Insert into TempertaureData values( 40.2, NULL);
Try specifying the Tempt field and it's value only. SQLite may be
interpreting the NULL as a supplied value and thus not inserting the
> Create table TemperatureData ( Tempt real, TimeStamp default
CURRENT_TIMESTAMP);
> Insert into TempertaureData values( 40.2, NULL);
Try specifying the Tempt field and it's value only. SQLite may be
interpreting the NULL as a supplied value and thus not inserting the default
value.
Does SQLite have any specific ordering requirements for how triggers
are created? I have a case where an 'UPDATE BEFORE' trigger will
not work as expected if an 'UPDATE AFTER' trigger on the same table (but
not the same column) is created after it is.
cheers!
On Mon, 24 Jan 2005, Lee Wenchian Civ AFRL/IFTC wrote:
The code above creates a table storing a temperature value with the current
timestamp.
I would give TimeStamp a type, but I am not sure what type is appropriate
(text or blob).
The code as written does NOT insert the current time stamp to the
When creating a table, according to the syntax, a column can be specified
with DEFAULT column constraint and "The DEFAULT constraint specifies a
default value to use when doing an INSERT ...If the value is CURRENT_TIME,
CURRENT_DATE or CURRENT_TIMESTAMP, then the current UTC date and/or time is
Hi Shawn,
Downey, Shawn wrote:
Thank you all for the great mailing list.
What would be the best way to keep n Sqlite databases up-to-date across
n nodes on a LAN? The platform would be Windows and the implementation
language would be C++ (but I am open to other language suggestions if it
makes
Hi Anirba
your best place to ask questions on Tcl is the 'comp.lang.tcl' usenet
newsgroup (or Google groups), unless the question refers directly to the
Sqlite Tcl bindings.
Another great source of info is the Tcler's Wiki which has answers and
example code to this and hundreds of other
> Alex Chudnovsky said:
> > I am using ADO .NET wrapper
> > (http://sourceforge.net/projects/adodotnetsqlite/) and I am not sure
> > if I can just "drop in" new .DLL -- the wrapper was not updated for a
> > while now :(
FWIW, there is active discussion going on the forums. I remember discussion
Thanks for all the help, I will be implementing this in the next couple of
weeks in
my project.
Thanks again,
Ramon
> On Mon, 2005-01-24 at 11:46 -0500, Jason Morehouse wrote:
>
>> If using apache, this also works nice in your httpd.conf -- it allows
>> you to put databases anywhere in the www
Ramon wrote:
I was wondering if someone can just download off my webpage the sqlite database.
And if they can is there a way to block this type of download throw apache?
Any tips and advices are welcome.
If using apache, this also works nice in your httpd.conf -- it allows
you to put databases
Ned Batchelder wrote:
One more twist I just discovered:
If the primary key is a single column that auto-increments, there is
no information in the pragma index_list about the primary key at all:
That is because there isn't a seperate index on the table using that column.
That column is the key
Clay Dowling wrote:
Alex Chudnovsky said:
I am using ADO .NET wrapper
(http://sourceforge.net/projects/adodotnetsqlite/) and I am not sure
if I can just "drop in" new .DLL -- the wrapper was not updated for a
while now :(
I feel moderately bad about that, because I have recommended that
Alex Chudnovsky said:
> I am using ADO .NET wrapper
> (http://sourceforge.net/projects/adodotnetsqlite/) and I am not sure
> if I can just "drop in" new .DLL -- the wrapper was not updated for a
> while now :(
I feel moderately bad about that, because I have recommended that
particular wrapper
Daniele Nicolucci (Jollino) wrote:
Ok, I guess I'll have to live without having an auto-increment field
or find a way to fill it in the csv file with explicit values... my C
skills are almost null so I don't even attempt to do that.
Or I could write a simple script to generate INSERTs from csv
Hi,
I'm new as a SqLite user, despite a read a lot about it.
I downloaded SqLite 3.0.8 tarball sources and compiled it on MinGW following
the instructions below (I found this instructions googling ...).
It compiled and seems to work well with a Windows console test application I
made. But
Clay Dowling wrote:
Alex Chudnovsky said:
Today I had database corruption (running v3.0.7 on Windows using ADO
.NET's data providers + my
Alex,
You might try 3.0.8, which is the current stable release from the 3.0
branch. It's entirely possible that you encountered something that was
Alex Chudnovsky said:
> Today I had database corruption (running v3.0.7 on Windows using ADO
> .NET's data providers + my
Alex,
You might try 3.0.8, which is the current stable release from the 3.0
branch. It's entirely possible that you encountered something that was
addressed in 3.0.8.
Clay
Hi all,
Today I had database corruption (running v3.0.7 on Windows using ADO
.NET's data providers + my
anti-locking wrapper on top). All of a sudden queries stopped working
with error returned
being "file is encrypted or is not a database". That sure scared me to
death since
command line tools
At 06:54 24/01/2005, you wrote:
I was wondering if someone can just download off my webpage the sqlite
database.
And if they can is there a way to block this type of download throw apache?
Don't put the SQLite database in an apache web site directory..
This is easily done if you run your own web
I was wondering if someone can just download off my webpage the sqlite database.
And if they can is there a way to block this type of download throw apache?
Any tips and advices are welcome.
The best solution is to store database file out of domain root:
/www/domain.com - directory for
I was wondering if someone can just download off my webpage the sqlite database.
And if they can is there a way to block this type of download throw apache?
Any tips and advices are welcome.
Thanks,
Ramon
Hi all,
I have a tcl text widget with some values in it that has been fetched from a
sqlite backend.
I also have a button labelled Submit.
When I click the Submit button, I want to call a procedure which will fetch the
value that is stored in the text widget and store it in a variable. What do
28 matches
Mail list logo