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.
Should
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 CURRENT_
>
> 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 trigge
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 ju
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, NUL
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 d
> 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.
Ins
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 l
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
in
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 th
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 the job easier). The maximum
Hi Anirban
Your code is slightly confused on this, so I'll give you a clean example.
#
#You don't really need a frame for this little example, but I'll keep it in
#the spirit of your code.
frame .f
text .f.t
button .f.b1 -text "Submit" -command
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 topics.
Darren Duncan wrote:
At 11:13 PM -0800 1/22/05, Jeff wrote:
I'm making something that requires XML. (ooh, secretness)
It would also be nice to use SQLite with it, but I am confused about
how much things I need to put into the database and how much that
needs to stay on the file system.
You probably
> 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
w
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 r
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 root, without worrying about
> protecting specific directories.
>
>
> Order allow,deny
> Deny from all
> S
Hi,I'm new as a SqLite user, despite I 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 2000 console test application I made. But dur
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 a
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 for
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
par
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 in
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 file
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 dur
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
addre
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 http://www.
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 I
33 matches
Mail list logo