On Thu Oct 09, 2014 at 05:38:57PM -0500, Nico Williams wrote:
I use triggers, particularly INSTEAD OF INSERT triggers on VIEWs.
The values of the columns of the rows to be inserted are the
stored procedure's arguments.
I would like to able to do this too, but INSTEAD OF INSERT on a view
does
This error occurs in 3.8.6:
$ echo 'foo' /tmp/foo.sql
$ sqlite3 /tmp/foo.db /tmp/foo.sql
Error: incomplete SQL: foo
$ echo $?
0
0 is the return code from sqlite3 and this should instead return 1 since
an error occured.
shell.c:3644
if( nSql ){
if(
Hi,
Really appreciate any help, spent a day and a half trying to figure this out
without success. I can't get 'System.Data.SQLite Database File' to show up as
an option I the 'choose data source' window.
My environment: VS2010 SP1, WIN 8.1 PRO
1. Installed
Hi,
I'm collecting file names (full paths) in sqlite table. Each day I
need to remove non existing files from this table (thousands records).
For now I'm selecting all records and then checking if file exists
using C++ routine and if not then deleting it. I'm wondering if SQLite
has such function
Richard implied in this bug that you can use locking_mode=exclusive when you
have a single process using that database, but that process has multiple
threads connections:
https://bugzilla.mozilla.org/show_bug.cgi?id=993556
However, I've tried this and can't get it to work - the second open
On 10/10/2014 2:20 PM, Krzysztof wrote:
I'm collecting file names (full paths) in sqlite table. Each day I
need to remove non existing files from this table (thousands records).
I'm wondering if SQLite
has such function (could not find it in core functions).
SQLite doesn't have such a function
On Fri, Oct 10, 2014 at 11:55 AM, Ben Lam ben@ocr.ca wrote:
Hi,
Really appreciate any help, spent a day and a half trying to figure this
out without success. I can't get 'System.Data.SQLite Database File' to show
up as an option I the 'choose data source' window.
My environment: VS2010
Greetings!
select 7,915 - 5,021;
displays this result:
7|910|21
I was really looking to have 2,894 returned, but instead I received the
above. Then, I added quotes,
sqlite select 7,915 - 5,021;
2
sqlite select '7,915' - '5,021';
2
I was able to figure out that comma's are more important
select 7,915 - 5,021
is:
select 7, 915 - 5, 021
giving
7 91021
just like
select 'a', 915 - 5, 'b'
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
john soprych wrote:
Is there a good way to create functions in sqlite where you can insure that
your function callback will be called in order?
No.
Your best bet is writing the query in such a way that the function is
applied to an already ordered sequence:
SELECT myfunc(x) FROM (SELECT x
On 10 Oct 2014, at 9:27pm, to...@acm.org wrote:
sqlite select 7,915 - 5,021;
2
But, would someone explain the result of 2? Sorry for this child-like
question, but I can't find the how the result of 2 came to be displayed.
7 - 5 = 2
Simon.
___
You do not say what operating system, but for example, on Windows, the
following function works:
SQLITE_PRIVATE void _GetFileAttributes(sqlite3_context *context, int argc,
sqlite3_value **argv)
{
sqlite3_result_int(context,
GetFileAttributesW(sqlite3_value_text16(argv[0])));
}
which is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/10/2014 01:18 PM, jose isaias cabrera wrote:
I was able to figure out that comma's are more important than just
a 1000 number delemeter, so I received the right answer by taking
the commas out:
To help avoid this in the future, be aware that
On 6/10/2014 18:35, Clemens Ladisch wrote:
John wrote:
On 5/10/2014 19:59, Clemens Ladisch wrote:
The documentation http://www.sqlite.org/lang_datefunc.html says:
| These functions only work for dates between -01-01 00:00:00 and
| -12-31 23:59:59. For dates outside that range, the
On Thu, 9 Oct 2014 11:16:25 -0400
Stephen Chrzanowski pontia...@gmail.com wrote:
On Wed, Oct 8, 2014 at 8:38 PM, James K. Lowden
jklow...@schemamania.org wrote:
The problem I see with your suggestion is that I can't think of
another situation, with or without NULL, with or without
15 matches
Mail list logo