Hi Ryan,
I get your point. :)
It seems the I was misunderstanding this help mailing list. I thought it's also
support for 'System.Data.SQLite'.
In the way 'System.Data.SQLite' is an ADO.NET provider for SQLite and also give
support for entity framework.
that because I was asking if it support
>
> how can I trunc time in EntityFramework?
>
> I tried it this way:
>
> model.Datas
>.GroupBy(d =>
> DbFunctions.TruncateTime(d.TimeStamp))
>.Select(d => d.Key.Value)
>.ToArray();
>
> But get this error:
>
Hi,
how can I trunc time in EntityFramework?
I tried it this way:
model.Datas
.GroupBy(d => DbFunctions.TruncateTime(d.TimeStamp))
.Select(d => d.Key.Value)
.ToArray();
But get this error:
time I want to access
it.
Best Regards
Steffen Mangold
>
> System.Data.SQLite version 1.0.98.0 (with SQLite 3.8.11.1) is now available
> on the System.Data.SQLite website:
>
Great news, thanks Joe!!
Regards Steffen
>
> is there any target date when the preRelease branch gets over to a actual
> release?
>
> Is a really hard show stopper for our development at the moment. We checked
> everything for compatibility before merge your current trunk to Visual
> Studio 2015 and we forget about the SQLite design
. :(
Regards
Steffen Mangold
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
. :(
Regards
Steffen Mangold
Steffen Mangold wrote:
>
> Until final release I want to download the preRelease [e670692d90]
> created for 18 days.
>
Joe Mistachkin wrote:
>
> Normally, the "preRelease" branches are just a staging area for changes
> needed during the release process
98.0.exe"
from
https://system.data.sqlite.org/index.html/doc/preRelease/www/downloads.wiki I
get an error "Not Found, Not logged in".
How can I download the preRelease?
Best Regards
Steffen Mangold
t my Windows Service (under LOCAL SERICE right) still see other data. :(
I don't know how to fix this.
Regards
Steffen Mangold
---
This has nothing to do with SQLite sadly, but still easy to fix. It's the
WIndows UAC which is doing this to you, as it should fo
account) and open my DB (c:\my.db3)
I see only data entry A.
If I open my DB tool with admin rights and open the same DB.
I only see data entry B.
Regards
Steffen Mangold
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
rows.
regards
Steffen Mangold
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi Clemens,
first thank you for your comments.
>
> It works for what you've asked. Perhaps you should not have kept your actual
> requirements a secret.
>
Sorry for being unclear! :(
Hope my English is understandable (I'm from Germany).
>
> So you want to group only consecutive events with
| 2012-07-24 22:23:05 | status1
0 | 2012-07-24 22:23:10 | 2012-07-24 22:23:16 | status2
1 | 2012-07-24 22:23:21 | 2012-07-24 22:23:26 | status1
2 | 2012-07-24 22:23:37 | 2012-07-24 22:23:47 | status3
You are right the ID column is not relevant. You can ignore them
tus = ou.Status
AND
TimeStamp < '2010-02-24 00:00:00') AS End
FROM Data ou
But don't work :(
Can you please help me?
Regards
Steffen Mangold
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Joe Mistachkin wrote:
>
> Yes. The code is currently on trunk. Please see:
>
> http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki
Thank you. :)
Regards
Steffen Mangold
___
sqlite-users mailing list
sqlite-users@sql
Hi,
is there a new ADO.NET setup version for Visual Studio 2012 planed?
regards steffen
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi sqlite user,
I try to update a table field with a selected value from same tabel. Is this
possible?
What I try yet is:
update TableA Set FieldA = (select FieldB from TableA where IDField =
updateData.IDField AND TimeStamp = date(updateData.TimeStamp, '-1 day'));
I want to update the FieldA
>
> Have you checked your table afterwords to ensure you don't have any nulls in
> IsReplaced?
>
> select count(IsReplaced) from mytable where IsReplaced is null;
>
> I tested and the alter table does fill with default values for me. At least
> from the sqlite shell.
>
> Does this work for you?
>
> I think your problem is with the ado provider. Perhaps it makes the
> assumption that every value in a BOOLEAN column must be a BOOLEAN. This is
> not true under SQLite: you can have any value in a BOOLEAN column, even TEXT.
>
Hi Simon,
Yes correct because if you alter a table with a new
>
> Hi guys,
>
> i have a little problem with BOOLEAN data column.
>
> I have an existing table filled with data and want to add a new column like
> "IsReplaced BOOLEAN NOT NULL DEFAULT 0"
> All worked fine but if I now try to read a data row I gat an exception from
> the sqlite ado provider
Hi guys,
i have a little problem with BOOLEAN data column.
I have an existing table filled with data and want to add a new column like
"IsReplaced BOOLEAN NOT NULL DEFAULT 0"
All worked fine but if I now try to read a data row I gat an exception from the
sqlite ado provider that he can not
Hi Simon,
thanks for your help. All worked now :)
I only lost some data at the end of the table, not so bad.
Thank you :)
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> You should be able to, yes. Just type in "END;" (without quotes, but with
> semicolon).
>
Ok thank you i will try :) (in a few hours because DB is so big. :)
___
sqlite-users mailing list
sqlite-users@sqlite.org
>
> If you have a BEGIN command in your script, then you should also have END or
> COMMIT at the end (the two are synonyms).
>
can i do this by shell command after ".read" if my SQL script has miss that?
Steffen
___
sqlite-users mailing list
WHAT THE !
I now delete the malform message and the rollback command from the *.sql file
and run ".read".
Sqlite shell runs complete and the shell ask me for new command "> " (DB file
seems to have the right size.
I'm happy now and enter command ".exit" and bam Db file has 0kb?!?!?
What
Ok maybe i found it in the sql file is written (file end):
[...]
INSERT INTO "InverterData" VALUES(2478,'2012-02-28
15:00:00',1435.73,429173.78,170.28,170.75,169.38,397.56,397.38,396.69,NULL,210976,31,NULL,NULL,1,304,NULL,NULL,NULL,694,NULL,NULL,NULL);
/ ERROR: (11) database disk image is
>
> Is it very long ? Can you read it with a dump utility or a text editor
> (don't try it with a word processor) and see the SQL commands in it ?
>
Yes 14 GB. 4 Table, roundabout 200.000.000 inserts.
I opened it with a textviewer for large files. Sql seams well formed and
readable till the
>
> Are you saying it creates a database file but doesn't put anything into it
> (zero filesize) or that it doesn't even create a blank file ?
>
With dump its write the complete DB File new but nearly at the end (new DD file
size compared to the malformed) Sqlite shell breaks and set the file
>
> Ok, with .dumb i now created a "db.sql" file successfully.
> but I don't get the read command!? How create a new DB file with that command?
> With "sqlite> .read db.sql" it does much reading but no file is created.
>
Ok I get it, must attach a DB first.
now sqlite writes the data to the DB,
>
> There's no magic tool for repairing damaged database files. But by using the
> .dump command (if necessary on each individual table and view) then creating
> a new database file and using the .read command you can often rescue some or
> all of the data in the original > > database.
>
Ok,
>
> First, get all the other databases done, so you're worried only about the one
> which doesn't work.
>
> Then do the .dump part for that database, putting the output into a file on
> disk, which should leave you with a huge file of SQL commands which should
> rebuild it.
>
> It's likely that
Hi guys,
i have a problem with the sqlite2.exe under windows.
Ok, I have here 20 corrupted DBs and want to repair they all.
I do this with CMD and the command ".dump | sqlite3 rebuild.db3 | sqlite3
rebuild.temp"
This works perfect for all DBs except one.
The DB where it is not working has a
>
> SQLite does not have a separate "date/time" datatype. It uses either strings
> (preferably in ISO8601 format) or numbers (seconds since 1970 or Julian day
> number).
>
> Your WHERE clause is comparing strings, not dates. If you using ISO8601
> dates in your database file, as you do in
>
> Plus...what's the "T" supposed to do? Perhaps I'm ignorant of the magic you
> expect.
>
The 'T' devide the date from the time. Looking here
http://www.sqlite.org/lang_datefunc.html
It is the default ISO-8601 datetime format.
>
> I'm confused as to why you would expect any match at all.
??? I don't get it ???
Why this is happen, is it really a bug?
Regards
Steffen Mangold
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi,
i would like to push an old question again to the users.
In original it has written to the old forum bei "peter77" on 10-17-2008.
But now I have the same problem.
Here the question:
"The Skip(n) method is not optimally transformed into SQL. Consider the
following LINQ expression:
(from e
Now i have the problem that the sqlite3.exe has a problem with "ä, ö, ü" in
Database filename. :(
It makes a new db called " D�sseldorf " for example and fails then
Thank you that works :)
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
st.db3"
The result is only:
sqlite> test.sql | "Saalburg 1.BA (2).db3"
...>
Steffen Mangold
myfile.sql example between the lines:
create table t(a int);
insert into t values(1);
select * from t;
You could
Hi all,
i have a question. I have a script with edit a database file (insert and alter
some tables).
Now I want to run this script agains an existing database file, with the
commandline shell.
How can I do this in a batch file (windows) I don't understand the ".read"
command.
Regard
Now I fixed it.
CREATE TRIGGER tableA _InsertUpdate
AFTER INSERT
ON tableA
begin
update tableB
set
[LowestTime] = CASE WHEN ( [LowestTime] IS NULL ) OR
([LowestTime]> TIME(NEW.TimeStamp)) THEN TIME(NEW.[TimeStamp]) ELSE
[LowestTime] END
end;
... THEN
02:00:00’,
‘Dump’ );
5. [LowestTime] should now be ‘01:00:00’ BUT it is ’02:00:00’???
Hopes is more clear now.
Steffen Mangold
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sql
>
> sqlite> select time( '2011-01-29 08:00:00' );
> 08:00:00
>
Oh sorry, i looked wrong. I insert this way:
INSERT INTO [filed1] VALUES '2011-01-01 08:00:00'
And because of the init of:
CREATE TABLE tabel1 (
[field1] time,
);
SQLite writes only the time to the database.
But this fails:
E() produces a string of the form '12:34:56' (hours:minutes:seconds).
> What's in NEW.TimeStamp? What's in field1?
>
NEW.TimeStamp is a complete datetime. But I only want to compare the time part
in my trigger.
--
Steffen Mangold
___
sqlite-users mailing list
s
t really strange results when I try to compare time values.
For example:
Given is a table with a field [field1] data type 'time'.
Now I make a compare in a trigger like this.
[field1] < TIME(NEW.TimeStamp)
But this is not working :(
Thanks for your h
No solution? :(
Joe can you help perhaps? You help me so much with my other problem with the
Entity Framework.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Pavel wrotes:
>
> I don't know C#, but quick look at Microsoft's documentation shows that you
> can get Ticks() from TimeSpan, save it into DB and then when you get Int64
> from DB you can create TimeSpan from it.
>
Seems not to work entity framework cannot convert "long" to the type
.Net out of
the DB.
--
Steffen Mangold
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi all,
how to use DateTimeOffset with Sqlite, if it is possible?
Regards
Steffen Mangold
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Akash Agrawal wrotes:
>
> I have table in which i have column of Date contain both *date and time*when
> compare the value in my c++ program it is not giving me correct result . can
> you help to solve my problem.
>
Hi,
I had a similar problem. How accurate is your time? I had such a problem
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
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 s
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
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
set 5 (Success in DB)
But for now I only get:
Dataset 1 (Success in DB)
Dataset 2 (Success in DB)
Dataset 3 (Failure not in DB)
Dataset 4 (never happens)
Dataset 5 (never happens)
Steffen Mangold
___
sqlite-users mailing list
sqlite-users@sqlite.org
ht
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
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
{
ta base are now 6 rows, that mean all after the failing insert are not
executed be the transaction.
So I think if I'm doing all right with checking out your fix, it is not working
at all. :(
Steffen Mangold wrote:
>Sorry, I make my test with wrong conditions it looks like It not works corre
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
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
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
hi joe,
wow thanks for your fast help. Tomorrow I will try your patch.
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.
Thank you!!
Steffen Mangold
Joe Mistachkin wrote:
>I believe that I've found and fi
Hi Simon,
first nice to hear from you. :)
> Fred helps solve Helen's problem one day, Helen may solve Fred's the
> following week.
Oh I'm not mean pro support. What you descript is what I'm searching for. Like
a forum.
> Can you show us a pointer to this information ?
Sure,
ll be also add to the database.
But this never happens. :( Can you help me?
Regards
Steffen Mangold
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
66 matches
Mail list logo