On Mon, Sep 12, 2011 at 12:50 AM, Freddy López freddy.vat...@gmail.comwrote:
Hello.
I have been having problems with page www.sqlite.org/contrib and I need
file
extension-functions.c (50.96 KB) contributed by Liam Healy... There exist
some alternative place where can I download it?
On 12 Sep 2011, at 5:08am, Akash Agrawal wrote:
I'd like to be able to tell whether a SQLite database file has been updated
in any way. How would I go about implementing that?
I find about some file change counter but how i will get the value of file
change counter through C program
this is very helpful for me
thank you
--
Regards
Akash Agrawal
On Mon, Sep 12, 2011 at 12:39 PM, Simon Slavin slav...@bigfraud.org wrote:
On 12 Sep 2011, at 5:08am, Akash Agrawal wrote:
I'd like to be able to tell whether a SQLite database file has been
updated
in any way. How would I
I am migrating data from a database which has a table that describes items by
kinds. Instances of those kinds are stored in one column of this table,
listing each instance's id, with all ids separated by a slash /.
Of course, this is a very poor design. The target system has a proper table for
Oops, forgot to update to the bug-ccfa69fc32 branch, inserted new step #8
below to correct this.
Steffen Mangold wrote:
It would really help me if you send me your step by step instructions.
I had some experience with SVN, but it will help for building.
1. Download the Fossil binary for
Simon Slavin-3 wrote:
I agree with Jay. What's happening is this:
New row assembled.
Attempt to INSERT new row (first attempt)
INSERT fails UNIQUE contraint.
Notes that it was an INSERT OR REPLACE, therefore ...
DELETE original row.
Attempt to INSERT new row (second
Nice job! :) It works now like expected. I have tested it with
use of this patch http://system.data.sqlite.org/index.html/info/42af4d17a5 .
I also wrote a comment to the ticket [ccfa69fc32]. Thank you, great job.
Steffen
Joe Mistachkin wrote:
I believe that I've found and fixed an issue in the
Sorry, I make my test with wrong conditions it looks like It not works correct
at all.
Please give me a sec to do some more tests and ignore my last message *shame*.
I come back here after testing.
Steffen Mangold wrote:
Nice job! :) It works now like expected. I have tested it with use of this
Ok im not clear if im doning it right. I follow your instructions and get a
compliable version.
But how to get your branch? What I'm doing now is to download the zip under
Other links: Zip archive under
http://system.data.sqlite.org/index.html/info/42af4d17a5 and copy it over the
version from
Ok I'm tested it now in a simple test environment.
Conditions:
1 table with two columns TimeStamp (PK) and SensorID (simple value).
First I add a row with TimeStamp 2011-01-01 01:05:00 (Success)
Then I doing a Transaction with 10 TimeStamps from 2011-01-01 01:00:00 to
2011-01-01 01:10:00.
Since SQL is designed to return rows I believe the answer is no since you're
data is not stored in rows.
You need to do what's referred to as normalizing your data.
If you normalize the answer becomes a natural query.
create table kind (kind_id int primary key, name text);
insert into kind
Mr. Puneet Kishor punk.k...@gmail.com wrote:
The table geo can also have rows with min_age = max_age. I want a result
set with geo.id, min_age, max_age, age_bottom, age_top,
name, color like so:
- every row should be for one and only one geo record. I have 39K rows in
geo table, so the
Simon Slavin slav...@bigfraud.org wrote:
http://www.sqlite.org/c3ref/total_changes.html
int sqlite3_total_changes(sqlite3*);
My understanding (which might be wrong) is that this count includes all
changes made by all connections to that database: not
only changes made using your
Hi there,
I just have a question. If I am using JDBC driver to connect to sqlite using
in-memory mode,
is there any limit about the data size?
Thanks.
Clark
___
sqlite-users mailing list
sqlite-users@sqlite.org
Steffen Mangold steffen.mang...@balticsd.de wrote:
Ok I'm tested it now in a simple test environment.
Conditions:
1 table with two columns TimeStamp (PK) and SensorID (simple value).
First I add a row with TimeStamp 2011-01-01 01:05:00 (Success)
Then I doing a Transaction with 10
On 12 sept. 2011, at 13:26, Black, Michael (IS) wrote:
Since SQL is designed to return rows I believe the answer is no since you're
data is not stored in rows.
I suspected such a limitation. Thanks for the confirmation.
(though I question the justification: SQL is designed to return rows is
On Mon, Sep 12, 2011 at 8:02 AM, Igor Tandetnik itandet...@mvps.org wrote:
Simon Slavin slav...@bigfraud.org wrote:
http://www.sqlite.org/c3ref/total_changes.html
int sqlite3_total_changes(sqlite3*);
My understanding (which might be wrong) is that this count includes all
changes made
No i think i can exclude this as the problem.
Because my code goes like this:
using (dataDBEntities context = new dataDBEntities())
//create context
{
using (TransactionScope transaction = new TransactionScope()) //begin
transaction
{
Steffen Mangold steffen.mang...@balticsd.de wrote:
No i think i can exclude this as the problem.
Because my code goes like this:
try
{
context.SaveChanges(); // save changes with transaction !exception raised here
Inside this call, a loop runs, with one INSERT
Steffen Mangold wrote:
No i think i can exclude this as the problem.
Because my code goes like this:
The test case I added for this issue is remarkably similar to your code,
except it
uses a different schema (the Northwind sample database) and does not
re-throw the
exception in the catch
Thank you Kevin.
:-)
On Mon, Sep 12, 2011 at 02:19, Kevin Benson kevin.m.ben...@gmail.comwrote:
On Mon, Sep 12, 2011 at 12:50 AM, Freddy López freddy.vat...@gmail.com
wrote:
Hello.
I have been having problems with page www.sqlite.org/contrib and I need
file
extension-functions.c
On Mon, Sep 12, 2011 at 12:28 PM, Jean-Denis MUYS jdm...@kleegroup.com wrote:
My question is: is there a pure SQL way to split the instances string, and
generate the instance lines from the instance list string? contrived example:
This kind of questions appear from time to time (including my
Hm... but the exception i get is an SQLite constraint exception. This means that
The error occurs at the moment where SQLite provider try to write data to the
DB.
So I cannot have influence to this loop that you mean.
Igor Tandetnik wrote:
Inside this call, a loop runs, with one INSERT
Steffen Mangold steffen.mang...@balticsd.de wrote:
Hm... but the exception i get is an SQLite constraint exception. This means
that
The error occurs at the moment where SQLite provider try to write data to the
DB.
Which is inside SaveChanges call.
So I cannot have influence to this loop
On 12 Sep 2011, at 1:35pm, Richard Hipp wrote:
On Mon, Sep 12, 2011 at 8:02 AM, Igor Tandetnik itandet...@mvps.org wrote:
Simon Slavin slav...@bigfraud.org wrote:
http://www.sqlite.org/c3ref/total_changes.html
int sqlite3_total_changes(sqlite3*);
My understanding (which might be
Joe Mistachkin wrote:
The test case I added for this issue is remarkably similar to your code,
except it uses a different schema (the Northwind sample database) and does not
re-throw the exception in the catch block (it simply writes it to the console
instead).
The one
modification I would
Igor Tandetnik wrotes:
I'm not sure I understand this statement. What kind of influence do you want
to exert?
To work like expected.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Steffen Mangold wrote:
I try this now but with no success.
Are you sure the application is loading the new DLLs and not some stale DLLs
leftover
from before?
Did it work at your test case?
Yes, my test case works properly (the first time). The second time, all the
rows have
already been
Joe Mistachkin wrote:
Are you sure the application is loading the new DLLs and not some stale DLLs
leftover from before?
Yes, i look with Visual Studio in the Loading Modules window. Path and
version are correct (1.7.5) before I had installed only some 1.6 runtimes.
Hopes I do all right
Steffen Mangold wrote:
So you add all the 15 rows inside one transactionscope and with one
context.SaveChanges() call?
Yes.
Perhaps it makes a difference if the contains violation is inside the
15 rows you try to add (row 10 is incompatible with row 2 for example)
The important thing
Steffen Mangold wrote:
The important thing is that there is only one SaveChanges call (which
attempts to commit pending changes to the underlying database).
Yes, i do so.
My test case does attempt to add rows that conflict with data already present
in the sample database.
Ok, just
My point is that this normalization works on ALL databases. Ergo my reference
to SQL and not SQLite.
MySql for example has split support but it's still overkill to implement
something like what you want.
http://kedar.nitty-witty.com/blog/mysql-stored-procedure-split-delimited-string-into-rows
Last error i would see is i have made an error with the assembly creation.
Is it possible for you joe, to send me your assemblies direct per email?
So I can exclude this error.
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Sep 12, 2011, at 6:51 AM, Igor Tandetnik wrote:
Mr. Puneet Kishor punk.k...@gmail.com wrote:
The table geo can also have rows with min_age = max_age. I want a result
set with geo.id, min_age, max_age, age_bottom, age_top,
name, color like so:
- every row should be for one and only one
On 9/12/2011 12:02 PM, Mr. Puneet Kishor wrote:
On Sep 12, 2011, at 6:51 AM, Igor Tandetnik wrote:
Something like this:
select geo.id, min_age, max_age, age_bottom, age_top, name, color
from geo left join intervals i on i.id = (
select id from intervals
where age_bottom=
On Mon, Sep 12, 2011 at 12:29:56PM +0800, ?? scratched on the wall:
Hi there,
I just have a question. If I am using JDBC driver to connect to sqlite using
in-memory mode,
is there any limit about the data size?
PRAGMA max_page_count should work on in-memory databases.
On Mon, Sep 12, 2011 at 6:47 PM, Jay A. Kreibich j...@kreibi.ch wrote:
On Mon, Sep 12, 2011 at 12:29:56PM +0800, ?? scratched on the wall:
is there any limit about the data size?
PRAGMA max_page_count should work on in-memory databases.
Isn't there also the limitation that the
On Mon, Sep 12, 2011 at 06:56:50PM +0200, Stephan Beal scratched on the wall:
On Mon, Sep 12, 2011 at 6:47 PM, Jay A. Kreibich j...@kreibi.ch wrote:
On Mon, Sep 12, 2011 at 12:29:56PM +0800, ?? scratched on the wall:
is there any limit about the data size?
PRAGMA max_page_count
On Sun, Sep 11, 2011 at 11:55:23 -0300, Antonio Maniero wrote:
I doubt it that it would be ease to storing 8859 without string functions
problems. The proper collation would be simple, of course, but probably I
would need to re-implement all string functions too. Am I wrong?
I can use utf8
39 matches
Mail list logo