Short answer. Duplicate data in a database is bad. Take school
departments. For each teacher, do you put "History", "Chemistry",
"Biology" for their department? What happens if someone enters "Bioolgy"
instead? So for your point #1, "as soon as duplicate data is possible".
Maybe not for surnam
> I got foreign key constraint failures
I don't know why one would work and one would fail, but usually, this
occurs when you insert a record which has foreign keys to another table,
but that table hasn't been imported yet. The workaround is usually to
ensure all the 'lookup' tables are done fir
Typos \ suggested amendments to quirks.html
Section 2
"When ever comparing SQLite to other SQL database engines"
When ever should be one word. "Whenever comparing SQLite to other SQL
database engines"
"An application interact with the database engine"
should be, "An application *interacts* with t
> Yours is clearly incorrect
lol. "Your software gives a different result to the one I expect,
therefore its wrong."
You are aware that your first example (3.255) probably isn't being stored
internally as a single.
Just because computers work outside your understanding doesn't make them
'incorr
Edit: HOWEVER, just ran an integrity check, and that did fail.
"wrong # of entries in index sqlite_autoindex_t1_1"
On Thu, May 9, 2019 at 3:52 PM Chris Locke wrote:
> Are you using a new database when you create your table, or using an
> existing database?
> Are you wr
Are you using a new database when you create your table, or using an
existing database?
Are you writing your database locally?
What operating system / sqlite version are you using?
The above test works for me...
> Execution finished without errors.
> Result: 1 rows returned in 62ms
> At line 4:
> create table t(s varchar(5));
Also note that SQLite doesn't 'understand' varchar (it uses text) and it
doesn't limit the entry to 5 characters.
This doesn't help your issue directly, but does highlight that you've not
read the SQLite documentation, and aren't creating tables properly.
On Fri,
Arthur - are you running SQLite in parallel runs?
If you access the database file using the sqlite3 command-line tool, and
try to execute the same SQL commands, do you get the same error ?
SQLite makes a temporary 'journal' file while it's working. I think that,
on your platform, by default it wi
> When the database is full
What do you mean by a full database? Do you mean when the operating system
has run out of disk space?
A SQLite database can hold millions of rows, so technically, a database
cannot be 'full'.
It would be easier explaining the full issue and what you consider the
probl
On the page https://www.sqlite.org/see/doc/trunk/www/index.wiki in the 'key
links' section, there is a link to 'Files in the lastest release of SEE'.
This should be 'latest' and not 'lastest'.
Thanks,
Chris
___
sqlite-users mailing list
sqlite-users@mai
Does SQLite keep a count of the number of current open connections to the
database?
On the DB4S mailing list, there is an enquiry (
https://github.com/sqlitebrowser/sqlitebrowser/issues/1798) about
encryption failing due to the database being open. Was wondering whether a
PRAGMA or function return
Thanks Richard for the reply. Appreciated.
On Tue, Mar 12, 2019 at 2:49 AM Richard Hipp wrote:
> On 3/11/19, Chris Locke wrote:
> > Does SQLite keep a count of the number of current open connections to the
> > database?
>
> No.
>
> SQLite can find out if some other
Does SQLite keep a count of the number of current open connections to the
database?
On the DB4S mailing list, there is an enquiry (
https://github.com/sqlitebrowser/sqlitebrowser/issues/1798) about
encryption failing due to the database being open. Was wondering whether a
PRAGMA or function return
I fear the OP is referring to DB Browser for SQLite. This recently
released v3.11.1.
@desarrollo - I would suggest contacting the DB Browser for SQLite
developers at this address:
https://github.com/sqlitebrowser/sqlitebrowser/issues
Thanks,
Chris
On Wed, Mar 6, 2019 at 3:47 PM Hick Gunter wr
> Multiple processes write to foo.db.
What method of journaling do you use? WAL?
> Multiple processes read foo.db (no writes at all).
Do they open a connection, read, then close the connection, or do you open
a connection, read, read, read, read, until the process is terminated, THEN
close the
The link you quote mentions SQLite 3.24 though... ?
Thanks,
Chris
On Wed, Feb 27, 2019 at 12:44 PM niki wrote:
> This link demonstrates the problem:
>
> https://sqlite.org/search?s=c&q=3.24
>
> Best regards,
>
> Niki
>
> ___
> sqlite-users mailin
This issue was found via DB Browser for SQLite, but relates to SQLite, not
DB Browser for SQLite, so please bear with me
If a table is part of a view, then SQLite complains that "Error: error in
view view1: no such table: main.table11"
The link to the full issue is here:
https://github.com/sq
If you renamed file1.db to file1.bak, opened file1.bak, vacuum into
file1.db, close file1.bak, you have a backup pre-vacuum (just in case...)
and 'streamlines' the process some-what.
Obviously, you'd have to rename the file back again if the vacuum failed
(out of disk space, etc)
Just a thought,,,
Ryan Smith has already covered this scenario.
"And to add to the slew of "Few-tables-many-rows rather than
Many-tables-few-rows" solutions offered, one thing to note: After a single
table contains a few million rows, INSERTing will become slightly slower,
but the difference will still be measured
I don't know - that's why I asked. Thanks for the clarification.
On Mon, Jan 28, 2019 at 10:10 PM Warren Young wrote:
> On Jan 28, 2019, at 2:44 PM, Chris Locke wrote:
> >
> >> The table name should not be meaningful to your application; nothing in
> >>
> The table name should not be meaningful to your application; nothing in
> your application should conjure up a table name.
I can't get my head around this advice. Is this just for this occasion, or
for every application? What if I'm writing a customer address book? Am I
allowed a table called
Why do you need to create a new table each time? Its easier to create a
relational database. This means create one main table that might (for
example) have a 'tableID' field, which points to just one other table.
This means you only need two tables. Not 20,000+
Just an idea. Depends on what you
Just curious as to why you wouldn't choose option #2 - as that's what I use
with my VB .NET applications, which work quite well. Just distribute the
.exe, then the two SQLite DLLs (well, three technically, as there are two
versions of the interop.dll)
Thanks,
Chris
On Mon, Jan 21, 2019 at 4:19 P
> Just because something doesn't have to be calculated, means that it has
to be stored as text.
Sorry - forgot a 'doesn't'.
Just because something doesn't have to be calculated, doesn't mean that it
has to be stored as text.
On Thu, Dec 20, 2018 at 3:42 PM Ch
:
> On Wed, 19 Dec 2018 10:55:11 +
> Chris Locke wrote:
>
> > Fields with '_no' are read as 'number' and so should be a number.
> > OK, that doesn't always work for 'telephone_no' (they usually start
> > with a 0
>
> Lots of nu
the
same.
Just to take this back on topic, SQLite is fabulous for this type of
usage. A query takes milliseconds and a database can hold a whole manner
of settings, configurations, etc. File size is small and efficient too.
Thanks,
Chris
On Thu, Dec 20, 2018 at 9:05 AM Roger Schlueter wrote:
> On
What application are you using to build your application? You mentioned
Visual Studio, so .NET? If so, are you using the SQLite library from
system.data.sqlite.org? Are you using c# or vb?
My settings table is a lot simpler. id, setting and value. 3 columns.
Possibly 4, adding a 'code' column
; CREATE TABLE salaries (
> > emp_no INT NOT NULL,
> > salary INT NOT NULL,
> > from_date DATENOT NULL,
> > to_date DATENOT NULL,
> > PRIMARY KEY (emp_no, from_date)
> > ) withou
The scheme (for me) is like nails on a chalkboard. 'dept_no' but defined
as a 'CHAR', then 'emp_no' as an INT.
Fields with '_no' are read as 'number' and so should be a number. OK, that
doesn't always work for 'telephone_no' (they usually start with a 0 ...
well, they do in the UK where I am...)
> it is almost guaranteed to corrupt the database file if more than one
connection tries to access it at the same time.
I understand the risks and reasons, but have had numerous databases on our
Windows network accessed by 20+ users throughout the day without issue.
Thanks,
Chris
On Sun, Nov 1
> that will display a row number when outputting results?
Is this for your schema, or a 'general-could-be-anything' schema? If your
own, any reason why you don't use the rowid or _rowid_ columns? They
provide a unique reference for each row in a table.
Thanks,
Chris
On Wed, Oct 31, 2018 at
> On the other hand, I am open to suggestions on how to express
> those values in a way that modern twitter-ites can better understand
Probably via selfie, with a duckface, together with your evening meal in
the background.
On Mon, Oct 22, 2018 at 4:30 PM Richard Hipp wrote:
> On 10/22/18, Chr
. It
was purely a 'gotcha' that has caught me out before - a journal file
lingers and locks the system.
On Mon, Oct 15, 2018 at 4:03 AM Rowan Worth wrote:
> On Sat, 13 Oct 2018 at 00:21, Chris Locke
> wrote:
>
> > > Database is locked
> >
> > Close
> Database is locked
Close your application. Is there a xxx-journal file in the same directory
as the database? (where xxx is the name of the database)
Try deleting this file.
Thanks,
Chris
On Fri, Oct 12, 2018 at 4:54 PM Thomas Kurz wrote:
>
>> Could the problem arise due to filesystem cor
When SQLite creates an empty .db file, which directory is it in? With all
your tweaking, etc, is the new database always in the same directory?
Thanks,
Chris
On Wed, Sep 5, 2018 at 3:23 PM Robert Helmick
wrote:
> I'm receiving an error when I try to read from a pre-populated SQLite
> database:
he docs, ` pragma *case_sensitive_like` should rteturn
> the value; a pragma without a value.
> there's also a pragma pragma_list which (if compiled in) will return all
> available pragmas
>
> On Thu, Aug 16, 2018 at 6:16 AM Chris Locke
> wrote:
>
> > While the pragm
While the pragma *case_sensitive_like *can be set, there doesn't seem to be
a way to read it.
Is there a reason for it being write only?
A hacky workaround is to use the SQL, "select 'x' like 'X' ", but is there
a better way?
___
sqlite-users mailing lis
> I am using a query to check a date field between a range of dates
Can you provide example values of the date in your database?
Are you storing the EXACT date (eg, '2018-02-01 12:21'), or just the date?
> When running this with the ODBC driver it fails to return all the
appropriate record in th
> I am just starting to learn SQLite
Just a nod to check out (if you haven't already) the tutorials on w3schools.
https://www.w3schools.com/sql/default.asp
Not only do they clearly explain various SQL commands, but you can try them
out 'live' on their website using sample databases - nothing to i
When using directories with spaces, its better (or necessary) to include
the whole directory in double quotes. Therefore, try entering this:
sqlite3 "e:\VB Resources\SQLite\chinook.db"
No problems with being a novice - everyone was a novice once.
Thanks,
Chris
On Mon, Aug 13, 2018 at 1:15 PM Ro
> to include the whole directory
Sorry, I meant the whole filename.
On Mon, Aug 13, 2018 at 1:28 PM Chris Locke
wrote:
> When using directories with spaces, its better (or necessary) to include
> the whole directory in double quotes. Therefore, try entering this:
> sqlite3 &quo
I've been following this thread with interest, but this just doesn't make
sense...
> Logically speaking SQLite shouldn't notice the difference in row order,
but things do slow down,
> even with analyse.
Are you accessing each row via its ID? Even so, that should still be
indexed.
I thought you
If you want anything except "cat" then you can use the less than and
greater than comparison - <> .
select * from table where field <> 'cat'
This equates to "select all records where the value in the field column is
less than and is greater than 'cat'. SQL allows you to search for less
than and g
I use system.data.sqlite.dll (taken from here:
https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki)
with no problems in both VS 2017 Professional and VS 2017 Community.
Thanks,
Chris
On Mon, Jul 9, 2018 at 2:47 AM Roger Schlueter wrote:
> I am considering using the .net vers
I'm a VB.Net developer (so don't hate me...) but use SQLite quite
extensively at work - works really well (well, obviously...)
If you know SQL Server, then SQLite isn't that miuch different, and the
class wrappers I use are identical, apart from the connection strings,
which I could pass on. The w
first place.
>
> Paul
> www.sandersonforensics.com
> skype: r3scue193
> twitter: @sandersonforens
> Tel +44 (0)1326 572786
> http://sandersonforensics.com/forum/content.php?195-SQLite-
> Forensic-Toolkit
> -Forensic Toolkit for SQLite
> email from a work address for a fu
> some people seem to think that an int primary key can be auto
incrementing, it can't
But it works in the same way sort of. Its auto incrementing, with the
caveat that if the last row is deleted, the previous number will be used
again. Depending on the database schema, this may or may not
0, across approx 20 databases, ranging from small 3 table schemas, to a
couple of ERP systems using 120+ tables.
Thanks,
Chris
On Fri, Mar 16, 2018 at 4:09 PM, R Smith wrote:
> Across 8 production systems and about 120 SQLite DBs for us - Not a single
> AUTOINCREMENT - so 0 .
>
> I have to c
"Thats the beauty of it. It doesn't *do* anything." ;)
On Thu, Mar 1, 2018 at 6:55 AM, Gary Briggs wrote:
> Thanks to the help the other day with the strange concatentation result.
>
> I was referring to a BF interpreter I was working on, in pure SQLite SQL.
> Well, here it is, working.
>
>
DB Browser for SQLite is a third party product which just uses SQLite. Any
support issues should be directed to their gitHub support page.
https://github.com/sqlitebrowser/sqlitebrowser/issues
To confirm whether its an issue in DB Browser for SQLite or SQLite itself,
you can 'reproduce' the issue
I would suspect this is "DB Browser for SQLite" application. It has an
'execute SQL' tab, so the raw code can be directly entered, or the table
modified through a gui. It's pretty straightforward to use, and had a wiki
on its support pages.
This isn't the place to guide you though, but it has a ver
What operating system are you using, and what software are you using to do
the import? What specificially are you trying to import?
If you perform a sequence of 'insert' statements, then that can be time
consuming - its better to incorporate them into one 'transaction' - sqlite
bundles the operati
The 'scary bit' here is the device not functioning.
> A device attached to the system is not functioning.
Is the database/journal on the same/local PC or on a network?
Chris
On Mon, Dec 4, 2017 at 4:27 PM, Simon Slavin wrote:
>
>
> On 4 Dec 2017, at 9:31am, Tilak Vijayeta wrote:
>
> > PID:02
> if your systems are set up in a sane way, the MAC address alone would
prevent collisions, no?
> And on the same system, are collisions even possible?
Google says "In the case of standard version 1 and 2 UUIDsusing unique MAC
addresses from network cards, collisions can occur only when an
impleme
> Why do I want store ID numbers
> whose values may change? Why not.
Because that's not what the row id column is for. Not strictly. That's why
it's called 'id' - it's an identification field. You can't (shouldn't) be
using it for other means. A database requirement later might need that
column to
> For now, I am going to start
> with a windows forms application in vb.net or forms in OpenOffice.
I'd install SharpDevelop (
http://www.icsharpcode.net/opensource/sd/Default.aspx). Download v4.4 if
you plan on using VB.Net, as the newer v5 doesn't support VB - only C#.
SharpDevelop is a 15 MB d
lems (mainly slowness) that SQLite would
>> have in this situation?
>>
>
> and
>
> Chris Locke wrote:
> My work environment is mainly Windows servers/users. SQLite 'works' but is
> obviously unsupported (file locking, etc).
> Could BedrockDb help in this ar
My work environment is mainly Windows servers/users. SQLite 'works' but is
obviously unsupported (file locking, etc).
Could BedrockDb help in this area? Sounds like it works 'locally' but
'networkably' (is that a word?!) Couldn't find any Windows-friendly builds
or guides.
Even assuming it could
I'd suggest running the Microsoft Process Monitor
https://docs.microsoft.com/en-us/sysinternals/downloads/procmon
When your application crashes, this will show the files it tried to access
before the crash. It might point to a dependancy missing.
Have you 'installed' SQLite on your Win 10 machine
> I prefer using the PortableApps SQLite browser for other things as you
can have tabbed SQL queries but it doesn't have the DATETIME data type
Date and Time *Datatype*. *SQLite* does not have a storage *class* set
aside for storing dates and/or times. Instead, the built-in Date And Time
Functions
This is actually answered on the system.data.sqlite download page.
https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
Scroll down to the section, "Using Native Library Pre-Loading".
For some reason (?) on Chrome the text is about 30pt, so you shouldn't be
able to miss it.
Essen
I'd recommend the system.data.sqite.dll wrapper
http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki
This is a .Net component which works very well with SQLite databases.There
are a plethora of downloads, which can seem daunting. Depending on your
.Net flavour you're working with (I
insert into filters (absid, filter_name, enabled, filter_order) values
(null, 'Untitled filter', 0, ((select max(filter_order) from filters)+1)
On Mon, Jun 19, 2017 at 11:46 AM, Tim Streater wrote:
> I want to insert a new row in my table, and while doing so setting a
> column to one more than t
Excellent, thanks - I'll pass that on.
Very much appreciated.
Thanks,
Chris
On Thu, May 4, 2017 at 4:52 PM, Richard Hipp wrote:
> On 5/4/17, Chris Locke wrote:
> > If sqlite is given a slightly misconfigured SQL statement (eg, incorrect
> > JOIN statements), it could
If sqlite is given a slightly misconfigured SQL statement (eg, incorrect
JOIN statements), it could potentially try and retrieve millions of rows.
(Question taken from here:
https://github.com/sqlitebrowser/sqlitebrowser/issues/1005)
Is there any way of hooking into this before the actual records
Obviously the information given is a bit sparse. I'm assuming from a .dll
you're using Windows?
What steps have you taken, and what is giving this error?
On Thu, May 4, 2017 at 11:54 AM, prabha karan
wrote:
> Dear All,
> I got this exception except my system ... Pls help me
>
Another 'sharing solution' which is just getting off the ground is dbhub.io,
(https://dbhub.io)
This is a 'github for sqlite databases' allowing you to share databases,
have version control, etc.
Thanks,
Chris
On Fri, Apr 7, 2017 at 6:22 PM, Warren Young wrote:
> On Apr 7, 2017, at 11:04 AM,
Have you tried exporting to Excel? They're are even components (relatively
cheap) to convert to PDF so both bases are covered.
Exporting to excel allows columns to be used so figures line up nicely.
Open source applications open excel files.
Thanks,
Chris
On 24 Mar 2017 8:03 p.m., "James K. Low
An interesting discussion of it on StackOverflow...
http://stackoverflow.com/questions/689963/does-anyone-use-right-outer-joins
To give one example where a RIGHT JOIN may be useful.
Suppose that there are three tables for People, Pets, and Pet Accessories.
People may optionally have pets and thes
Sqlite is public domain, so feel free to add the necessary code, and once
approved, it'll get added to the main code.
Thanks,
Chris
On 20 Mar 2017 8:09 p.m., "PICCORO McKAY Lenz"
wrote:
> i got this
>
> Query Error: RIGHT and FULL OUTER JOINs are not currently supported
> Unable to execute sta
Just add a 'comments' table. Seems a lot of extra work and 'extra tools'
needed to read the comments, which could potentially be missed.
Add a 'comments' table with a 'comment' field which you can even add dates,
usernames, etc, to.
Thanks,
Chris
On Wed, Mar 15, 2017 at 11:12 AM, Clemens Ladisch
From a newbie's point of view, how is this better (if doing it in 'hard
coded' format like below) than writing this code:
command.CommandText = string.format("INSERT INTO trend_data (tag_key,
value, value_timestamp) VALUES ({0}, {1}, {2})",2,234.56,now);
I can sort of understand it if its in a su
NT- I write a lot of vb.net programs that use sqlite databases, so will be
happy to run though a beginners guide.
It would be painless to convert from vb.net to c#
Thanks,
Chris
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http:
Or user error.
"Thanks. Also found out where I was going wrong. While creating the .lib
file, weshould be using the following command: lib /def:sqlite3.def
/machine:X64 /out:sqlite3.lib I was skipping the /machine:X64 option
before."
On Mon, Mar 6, 2017 at 10:48 AM, Anick Saha wrote:
> Hi,
>
>
Feb 6, 2017 at 1:55 AM, Hick Gunter wrote:
> > But only if you can guarantee that your statement inserts exactly one
> record and that nothing is executed on your connection between the insert
> and the call.
> >
> > -Ursprüngliche Nachricht-
> > Von: sqlit
Last_insert_rowid()
https://www.sqlite.org/c3ref/last_insert_rowid.html
On Fri, Feb 3, 2017 at 1:51 PM, Clyde Eisenbeis wrote:
> For OLE DB SQL, I have retrieved the primary key:
>
> -
> using (System.Data.OleDb.OleDbConnection oledbConnect = new
> System.Data.OleD
Ken,
That went to the mailing list ... to which you are also a recipient of
;)
Thanks,
Chris
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
PHP will easily display a value with trailing zeros - you don't add '00'
programmatically.
eg: $number = number_format(1234, 2, '.', '');
On Thu, Dec 1, 2016 at 8:08 AM, Werner Kleiner
wrote:
> As I can see storing prices is a topic with different ways and
> different solutions.
>
> The advic
I recently had this problem. Values stored as real values. Had to check
records in the database to see if any value had changed, and needed
updating. Even though all values in my code were singles, I had bad
rounding problems where (as an example) 0.1+2.2 did not equal 2.3 in the
database. Aargh.
S
Ulrich- a fantastically detailed post.
On Mon, Nov 14, 2016 at 3:23 PM, Ulrich Telle wrote:
> Richard,
>
> > Well what I've done is to create an encrypted database with
> > SQLite2009 and then use that in my C# project. I just add the password to
> > the connection string in my app and then it w
Encryption in system.data.sqlite is legacy encryption, only used within
itself, and not with other applications.
On Fri, Nov 11, 2016 at 6:24 PM, Richard Andersen wrote:
>
>
> I'm using the ADO.NET version (System.Data.SQlite).
>
> I've created an RSA encrypted database using SQLite2009 and that
But be careful, as you can't change all records from 3 to 4 and then 4 to
5, as the 4 to 5 will contain the records you've just moved from 3 to 4
Canofworms.jpg. ;)
Thanks,
Chris
On 15 Oct 2016 5:46 p.m., "Richard Damon" wrote:
> On 10/15/16 12:15 PM, Simon Slavin wrote:
>
>> On 14 Oct
Are you accessing the database across a network, or is local on the server?
Are you using a transaction, or are these individual inserts?
I'm using system.data.sqlite.dll for a file backup program and that happily
rattles through 800,000 inserts (continuously) without issues.
Its worth noting that
What OS are you using? There is a freeware utility here for Windows:
http://sqlite2009pro.azurewebsites.net/
Thanks,
Chris
On Sat, Sep 10, 2016 at 10:24 PM, Scott Doctor
wrote:
> I have a database with a few tables and about 140MB of data in it that
> exists as a MySQL database. Using MySQL w
>First of all, I'll check all the pragmas and stuff, plus the version of
> SQliteBrowser (former DB Browser for SQlite indeed) I'm using, etc.
Just to confirm (as it seems to be overlooked) that SQLite Browser
(actually now called DB Browser for SQLite, rather than formerly...) is a
3rd party tool
Makes perfect sense. Thanks.
Chris
On Tue, Sep 6, 2016 at 12:26 PM, Richard Hipp wrote:
> On 9/6/16, Chris Locke wrote:
> > When reducing the size of the browser (on Chrome desktop at least) the
> '***
> > DRAFT ***' tag disappears. Rather than disappears, mayb
When reducing the size of the browser (on Chrome desktop at least) the '***
DRAFT ***' tag disappears. Rather than disappears, maybe this should be
reduced in size and always be visible?
Edit: Noticed its right at the bottom of the page, regardless of size, but
not at the top. Is this by design?
every field required. A
necessary evil, and 'the right thing', but still a pain...
Thanks,
Chris
On Fri, Jul 22, 2016 at 11:33 AM, R Smith wrote:
>
>
> On 2016/07/21 11:20 PM, Chris Locke wrote:
>
>> I've a table I'm calling recursively.
>>
>> ...
t; joins.
>
> Since your programming environment does seem to care about column names,
> you will have to set them explicitly.
>
> -Ursprüngliche Nachricht-
> Von: sqlite-users-boun...@mailinglists.sqlite.org [mailto:
> sqlite-users-boun...@mailinglists.sqlite.org] Im Auftra
Bit of a noob question, but whenever I post to the group, I get the below
email - 'you're not part of the group'. How does one join the group? I've
subscribed, so get all the emails... just wondering if there was a second
step, or if all group messages get moderated.
Thanks,
Chris
On Wed, Jul
I've a table I'm calling recursively.
CREATE TABLE "staff" ( `id` TEXT, `logonName` TEXT, `firstname` TEXT,
`surname` TEXT, `departmentId` TEXT, `managerId` TEXT,
`holidayDaysEntitlement` INTEGER, `holidayDaysTaken` REAL, PRIMARY
KEY(`id`) )
managerId points to the same table, so my join is simpl
*everyone rushes to download the files to have a nose*
On Wed, Jul 13, 2016 at 12:02 PM, Richard Hipp wrote:
> Off-list reply
>
> On 7/13/16, Miroslav Rajcic wrote:
> >
> > Note that I had to delete other tables to protect customer info.
>
> You did not seem to enable "PRAGMA secure_delete" bef
Whats the benefit of getting a sorted query and then sorting that query
again?
On Tue, Jul 12, 2016 at 12:45 AM, Stephen Chrzanowski
wrote:
> Simons + My answer;
>
> select * from (SELECT date_time_stamp FROM general ORDER BY date_time_stamp
> DESC LIMIT 2) a order by date_time_stamp;
>
> On Mon
Version.targets(3506,5):
> warning MSB3178: Assembly 'SQLite\System.Data.SQLite.dll' is incorrectly
> specified as a file.
>
> It not affect the final release program, but I don't know how it comes from
> and how to eliminate it.
>
> Thank you!
>
>
>
>
Blimey - arguments over a feather, However, I want to argue about your "They
look nothing alike" and I would say to a non-feather expert, they are very
similar. Same orientation (upwards, pointing to the right), white middle,
a nick on the right. They do look alike ... very alike.
Chris
On Tu
You might need something like Microsofts Process Monitor.
https://technet.microsoft.com/en-us/sysinternals/processmonitor.aspx?f=255&MSPPError=-2147217396
I was getting similar 'red herrings' when deploying my .exe and
system.data.sqlite.dll - it was moaning that it couldn't load the DLL.
Indeed i
Thanks James. Points taken on board. :-)
Chris
On Fri, Jun 17, 2016 at 5:24 PM, James K. Lowden
wrote:
> On Fri, 17 Jun 2016 07:37:16 +0100
> Chris Locke wrote:
>
> > I fail to see what any of this has to do with sqlite. I thought this
> > was a mailing list for sq
g [mailto:sqlite-users-
> > boun...@mailinglists.sqlite.org] On Behalf Of John McKown
> > Sent: Friday, June 17, 2016 9:35 AM
> > To: SQLite mailing list
> > Subject: Re: [sqlite] Correct, best, or generally accepted database
> structure
> > for groups of things
>
I fail to see what any of this has to do with sqlite. I thought this was a
mailing list for sqlite? Seeing queries (no pun intended) on sql
statements is very subjective, especially with the limited data provided by
the original poster.
Everyone will give helpful advice, but it won't stop there,
Great analogy. PS: What colour seat covers should I be using if I have a
Ford?
On Mon, Jun 13, 2016 at 2:11 PM, jumper wrote:
> Thank you for the advice/information. I just solved the issue about a
> minute ago. How can I stop getting new replies?
>
>
> On 6/13/2016 8:08 AM, R Smith wrote:
>
>>
1 - 100 of 104 matches
Mail list logo