h are just right for me: I can limit the size of a mailbox to a
certain number of mails. For the sqlite list, it's 10k mails. More than that
and the oldest get moved to the Trash automatically.
It's all I need.
--
Cheers -- Tim
___
sq
te-users
You do that yourself using the above website.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
t; and are hence confused when they see my claim that
> "SQLite is serverless".
>
> How can I fix this? What alternative word can I use in place of
> "serverless" to mean "without a server"?
Fundamentally SQLite is a lib
ana. Every value has a type. A column may contain
>> multiple values (as in one per row)
> I assume that is just for SQLite, or am I wrong again?
In general that's correct. Lengths of VARCHARs are ignored, too, as you
probably saw.
--
Cheers -- Tim
On 10 Jan 2020, at 18:55, Keith Medcalf wrote:
> On Friday, 10 January, 2020 11:44, Tim Streater wrote:
>
>>On 10 Jan 2020, at 18:03, Richard Hipp wrote:
>
>>> On 1/10/20, Dominique Devienne wrote:
>>>> There's no way at all, to know the length
he sqlite3_column_bytes() interface. But I cannot, off-hand, think
> of a way to do that from SQL.
But if I store UTF-8 in a TEXT column, surely I'm allowed to include NULLs in
that? They are after all valid UTF-8 characters.
--
Cheers -- Tim
_
the word TO is everywhere in text), so
> manually looking through CREATE TABLE / TRIGGER / etc. came up with nothing.
>
> Anyone have an idea where the word TO is used in SQL in SQLite?
ALTER TABLE?
See: https://www.sqlite.org/lang_altertable.html
--
Cheers -- Tim
__
On 03 Jan 2020, at 22:08, sky5walk wrote:
> Querying the config state is helpful for a dll wrapped database, ...
What's one of them?
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.
On 21 Dec 2019, at 21:42, Michael Walker (barrucadu)
wrote:
> I'm not sure the attachment to my first email got through ...
Correct. The list strips them.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.
if you've used "PRAGMA full_column_names". And that
> PRAGMA is now deprecated so you shouldn't use it.
Why are these pragmas deprecated? And what does "deprecated" mean, in this
context, anyway? There's lots of HT
v2 ;
> sqlite> DROP TRIGGER IF EXISTS x ;
> sqlite> ALTER TABLE v2 RENAME TO t3;
> sqlite>
>
> Not a problem for this version.
macOS 10.14.6:
Third-Mini% sqlite3
-- Loading resources from /Users/tim/.sqliterc
SQLite version 3.28.0 2019-04-16 19:49:53
Enter ".h
re on the SQLite website that is documented, if it is, so
I can point someone at it. The Xojo documentation doesn't mwention this so
either that is a potential problem for all us Xojo users or they've worked
around it somehow in their SQLite wrapper.
Thanks for a pointer.
--
running the ".import" command.
>
> Should I first convert the file into UTF-8 before importing it into SQLite?
Far as I know, SQLite stores your text as UTF-8 and you have to do the
conversion yourself. I think there's a UTF-16 option too.
I'd start here:
don't care if it's not "modern".
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
hour (not, for example, the second). If someone asked me the date and time, I'd
hardly respond "It's 2019 and its 27 seconds past." Wouldn't be that useful,
now would it. So the most important item if first, then the others in
decreasing order of importance.
--
Chee
On Wed, 18 Sep 2019 17:59:46 +, David Raymond wrote:
> It is comma then table-constraint. Check the direction of the arrow
> on that loop.
Ah! Sorry for the noise, I missed the direction.
- Tim
___
sqlite-users mailing list
sqlite
oo, bar, PRIMARY_KEY foo) and require
instead something like (foo, bar PRIMARY_KEY foo,).
The fix is to change the "," loop to instead be
"," .
- Tim McCormack
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
itesmiths; the braces align and I'm not wasting time looking for the
matching one.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
tware version
finding a too-new version number can quit with a message asking the user to
upgrade.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 12 Aug 2019, at 14:30, J Decker wrote:
> On Mon, Aug 12, 2019 at 5:42 AM Simon Slavin wrote:
>
>> On 12 Aug 2019, at 1:27pm, Tim Streater wrote:
>>
>> > I don't expect to do that with SQL. My "seconds since the epoch" is
>> based on conver
expect to do that with SQL. My "seconds since the epoch" is based on
converting any particular time to GMT and storing that. That number is then
converted to a date/time with TZ info for display.
--
Cheers -- Tim
___
sq
issue and should be handled as such by whatever
language is presenting to the user. That also allows the program to either
allow the user to presentation format to suit themselves, or for the program to
follow the way system prefs are set.
--
Cheers -- Tim
__
with a different actual value. Which is then
rounded. No point in complaining about that.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 13 May 2019, at 09:19, Christof Arnosti
wrote:
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Do that yourself at the link above.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.
ing the link in each email you get from the list.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ver expect the == operator to give a
> meaningful answer for floating-point numbers. Only use <, <=, >, and >=.
My floating-point "don't do that" lesson occured in 1965 when trying to compute
square roots by Newton's method. This was on an Elliott 803B.
--
year is the one week whose Thursday falls in that year (and the Monday
> can be in the previous year). This can lead to years sometimes with 53 weeks
> instead of 52.
It can also be a personal matter. For me, the week starts on Monday. For my
wife, it starts on Sunday.
--
Cheers -
and or invalid arguments error.
>
> This command was added to the command-line tool recently.
3.19.3 has it - that's almost two years ago.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mail
d found .sqliterc on an
> internet search and that allowed the persistent settings I wanted.
>
> However, would it not be more natural to keep those settings persistent
> inside the db file?
These settings are nothing to do with the database file. They're settings for
the sqlite
On 23 Mar 2019, at 16:06, Peng Yu wrote:
> I see a variety of extensions for sqlite3 database files, such as .db,
> .db3, .sqlite3 and .sq3. Is there a most commonly used/accepted
> convention for the extension? Thanks.
I use none at all. No extension is actually needed.
--
Cheers
On 20 Mar 2019, at 00:35, Simon Davies wrote:
> On Tue, 19 Mar 2019 at 15:07, Tim Streater wrote:
>>
>> My use case is a mixture of these. My need is to copy a row from a table in
>> one db (db1) to a table with identical schema in another db (db2). The
>> complica
ect * from mem.messages
which works nicely but has too many steps. I've not found a way to reduce the
step count.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 11 Mar 2019, at 20:21, Simon Slavin wrote:
> On 11 Mar 2019, at 7:30pm, Tim Streater wrote:
>
>> What is the maximum size in bytes that a result set may be? And what happens
>> if that size were to be exceeded?
>
> [The following is simplified for clarity. I disc
What is the maximum size in bytes that a result set may be? And what happens if
that size were to be exceeded?
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman
On 23 Feb 2019, at 19:30, Simon Slavin wrote:
> On 23 Feb 2019, at 6:41pm, Tim Streater wrote:
>
>> The PHP interface to SQLite doesn't appear to give me access to the extended
>> codes, unfortunately.
>
> I used to do SQLite from PHP myself. Hold on ...
>
On 23 Feb 2019, at 18:10, Simon Slavin wrote:
> On 23 Feb 2019, at 5:55pm, Tim Streater wrote:
>
>> I have a hosted web site using the SQLite functions from PHP. The page where
>> PHP is used was failing, and on investigation this is because an SQLite
>> function calle
will be working with my hosting provider but, is there a way to get more
specific information about this?
SQLite version: 3.7.7.1
PHP version: 5.3.28
Thanks.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
I have a hosted web site using the SQLite functions from PHP. The page where
PHP is used was failing, and on investigation this
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi
On 13 Feb 2019, at 15:23, David Raymond wrote:
> On a humor tangent, am I the only person who has ever named a savepoint
> "theHounds" for the sole purpose of being able to run the statement:
>
> release theHounds;
welease Bwian;
ield will probably default
to TEXT.
See: https://www.sqlite.org/datatype3.html
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 02 Feb 2019, at 22:19, Gerlando Falauto wrote:
> What I'm now trying to do is filter on source1 and by range of timestamp.
> Results should be naturally ordered by source1, source2,ts.
Not unless you use an ORDER BY.
--
Chee
but then
used a constant period for the rest (up to the set limit). Is this not the case?
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 06 Jan 2019, at 13:11, Daniel Kraft wrote:
> Since it seems that the mailing list swallowed my attached example code,
> I've put it on Github as well:
Attachments are explicitly disallowed on this list.
--
Cheers -- Tim
___
s
a 52 bit
> integer number and appropriate exponent. This way there should be no rounding
> errors and one would always have a guaranteed precision of ~15 significant
> digits.
Possibly:
<https://en.wikipedia.org/wiki/Decimal_floating_point>
nts of currency does not apply to the real world.
> As do insurance companies and many in the manufacturing world (inventory).
> There is a lot to like about BCD.
And do any processors/computers have hardware for that these days?
--
Cheers -- Tim
__
On 22 Oct 2018, at 20:08, thomgrayr...@printeasy.net wrote:
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Go to that web site, which is shown in every mail you have received from this
list.
--
Cheers -- Tim
___
sql
ere
> is a way to open a database for readonly in php (since just one C program is
> used for writing)?
Try:
http://www.php.net/manual/en/sqlite3.open.php
and look at the flags available.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-user
On 19 Oct 2018, at 17:33, Simon Slavin wrote:
> On 19 Oct 2018, at 3:43pm, Tim Streater wrote:
>
>> is it OK to generate the myid and goodtext parts using the usual string
>> methods from my host language, leaving only badtext as a bound variable, so
>> that my prepa
se is touched and might generate an SQLITE_BUSY response?
Thanks.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
bookmarks and scan their contents.
>
> Fossil forums are especially nice in this regard, since there is currently no
> subforum feature, so you don’t have to go digging through them to find out
> what’s new. The forum’s front page lists n
on a stronger
> foundation to allow its continued growth and increasing value to the business.
But they don't IME. Someone hacks something together as a proof of concept, and
management thinks that it's job done. The hack, which requires some manpower to
use, and which is no
quot;Evaluating -
how can there be no DataGrid") asking this question, with some possible answers.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 01 Oct 2018, at 21:02, Fabrice Fontaine wrote:
> Please find attached a patch fixing this issue. As this is my first
> contibution to sqlite, please excuse me if I made any mistakes.
Don't send attachment (not allowed), include it inline.
--
Chee
orted issue occurred.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 28 Aug 2018, at 15:36, Keith Medcalf wrote:
> On Tuesday, 28 August, 2018 07:50, Tim Streater wrote:
>>How does it know not to do that if I want to send some binary data to a Text
>>column?
>
> Simply because you do not request that those things be done.
>
> So,
t it's legal
for it to be a mixture of encodings. So I want to treat it as binary and be
able to just use the existing TEXT column. Anything I need to look out for?
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mai
and that what you meant to write was:
update foo set bar = 0x1234;
See:
<https://www.sqlite.org/lang_expr.html>
and scroll down to the part about Literal Values (Constants).
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
nected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table x (q text);
sqlite> insert into x values ('∑ß∂π');
sqlite> select * from x;
q
--
∑ß∂π
Seems to work.
--
Cheers -- Tim
_
On 01 Aug 2018, at 21:06, Warren Young wrote:
> On Aug 1, 2018, at 1:52 PM, Tim Streater wrote:
>>
>> I don't use the pragma since, officially, they are unsupported.
>
> “Unsupported” how? It’s documented and part of the SQLite file header, which
> is quite stable
t bit: SQLite already supports doing this with its user_version
> feature:
>
> https://sqlite.org/pragma.html#pragma_user_version
Yeah, I already also do all of this, although I don't use the pragma since,
officially, they are unsupported. But I'd rather have the IF NOT EXI
x27;d like to second this and for just the same reasons. Something like:
alter table add column if not exists my_new_col ...;
I would find very helpful.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
k
> (security and stability) with its wishy-washy ways.
No one is forcing you, or anyone else, to use SQLite.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
auto increment, use
NULL as the value fo your id column:
INSERT INTO test2 VALUES (NULL, 'Fletch', 245);
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ed, if that is their attack
vector. Personally I'd be loath to see this list moved to a web page, for
instance.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
s there a known workaround for it ?
See:
<https://www.sqlite.org/faq.html>
and look at question 14 and its answer.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 06 Jun 2018, at 17:06, Sabrina Abdul Jalil wrote:
> I am on MAC OS Sierra VER 10.12.06. How to download SQLite?
It's already installed on your computer.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.
On 17 May 2018, at 23:13, Keith Medcalf wrote:
> select col1, col2 from mytable order by cast(body_size as float);
Thank you. That's much better (although abs(body_size) worked too).
--
Cheers -- Tim
___
sqlite-users mailing list
sqli
er the doc doesn't specify whether round accepts a non-numeric argument.
Perhaps:
select col1, col2 from mytable order by abs(body_size)
would be better, but I wonder which is fastest (although speed may not matter
too much, the typical select shouldn'
w whether memory is interleaved or not.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
hey want it pronounced that way is a matter of indifference to me.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
/datatype3.html>
Personally I store all date/times as seconds since the epoch; it simplifies
life a lot.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
this
> flagged
> );
SQLite has no DATETIME or BOOLEAN datatype, see:
<http://www.sqlite.org/datatype3.html>
Given this, I don't know what your attempts to compare date/times will do.
Personally I store all date/times as seconds since the epoch; it simplifies
li
y file data.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 22 Jan 2018, at 21:21, Nnaemeka R Egudu wrote:
> Please unsubscribe me from this mailing list.
> Thanks.
Do it yourself using this URL:
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
Cheers -- Tim
___
sql
t *their*
interface either. I assume their interfaces are not rewriting SELECT statements
to include AS for every column selected, so should they be warning their users
about it?
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailingl
#x27;s triage system would best be characterized as an example
> of "the tail wagging the dog".
Well quite. My advice to anyone whose ISP or gmail is doing unwanted spam
filtering is to switch elsewhere.
And there's no need for 'likes' and related nonsense on a tec
nd-alone application (.exe or .app) then you buy a
licence. There is a Lite licence to build for one platform which is not a high
cost.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.o
ate in the form that the local
user expects.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ormat (for display
purposes), convert to the format the user wants.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
gt;>
>> On 27 Aug 2017, at 2:34am, Papa wrote:
>>
>>> Why do I get this error message?
>> Try having the program using file calls to open a simple text file in the
>> same directory. Does that succeed ?
Do w
D) as mx FROM Table")->fetchArray();
$Highest_ID = $results['mx'];
var_dump($Highest_ID);
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 21 Jul 2017, at 11:14, Rowan Worth wrote:
> On 21 July 2017 at 17:50, Tim Streater wrote:
>
>>$sql = "UPDATE Movies SET name = '$newname' where id=$newid";
>>
>> Personally I don't like forcing PHP to scan strings so I tend to use
On 21 Jul 2017 at 10:04, Edmondo Borasio wrote:
> Hi Tim.
>
> It *almost* works..
>
>$DbItemNameTest = "new name";
>$hIdTest = "1";
>
>$db->exec ('UPDATE Anagrafica SET name = \'' . $DbItemNameTest .
> '\'
onally I don't like forcing PHP to scan strings so I tend to use
concatentation, rewriting the last of these as:
$sql = 'UPDATE Movies SET name = \'' . $newname . '\' where id=' . $newid;
but that's just a personal style preference.
--
Cheers -- Tim
es SET name = \'' . $DbItemName . '\' WHERE ID=' .
$hId);
or perhaps:
$db->exec ("UPDATE Movies SET name = '$DbItemName' WHERE ID=$hId");
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
volved; I can do no
more than believe what the sender tells me. The IDE I am using does at lest
allow, in its base64-decode, that I request lossy conversion in the case of bad
input.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglist
: base64
then I interpret that to mean that the attendant data, after decoding from
base64, is it to be expected to be utf-8. The sender, however, could be lying,
and this needs to be considered. Just because a header, or file metadata, or
indeed a BOM, says some data or other is legal utf-8
ue is 1, unless you have
> defined the column in the table with a default of 1)
>
> --
> ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
Thanks, Keith and Chris. I had actually tried a "select max(…", but without, it
would seem, enough brackets.
--
Cheers --
no such column: filter_order”. I had a look at the syntax
diagram for insert which would seem to permit the above.
I can do this in code anyway so it’s not a show stopper, but what have I done
incorrectly? My IDE appears to use sqlite 3.14.1.
Thanks.
--
ecides when and how to make them.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
point at the
> prepared statement SQL text (just as sqlite3_sql(sqlite3_stmt*) returns?
Why don’t you write your own wrapper functions for the base SQLite calls. My
set of these functions logs where each call occurs and what the SQL was.
--
Cheers -- Tim
___
t's
nonetheless useful info, so perhaps what the sqlite website might have is an
LFAQ page (Less Frequently Asked Questions).
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi
Thanks for the update
On 6 Apr 2017 23:36, "Joe Mistachkin" wrote:
>
> Tim Bateson wrote:
> >
> > Does anyone know when the SQLite for Visual Studio 2017 Design Time
> > Components will be released?
> >
>
> The current estimate is that support fo
On 06 Apr 2017 at 19:54, Jens Alfke wrote:
> PS: Tim, for some reason your mail client (iLetter) is sending replies without
> an In-Reply-To header, which breaks up the threading (at least in my mail
> client) making it very hard to follow. There’s probably not a way for you to
>
Hi,
Does anyone know when the SQLite for Visual Studio 2017 Design Time
Components will be released?
https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
Thanks,
Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
On 06 Apr 2017 at 16:10, Simon Slavin wrote:
> On 6 Apr 2017, at 4:04pm, Tim Streater wrote:
>
>> On 06 Apr 2017 at 15:33, Simon Slavin wrote:
>>
>>> After touching, try opening the file and issuing a CREATE TABLE command.
>>> See whether it works or giv
On 06 Apr 2017 at 15:33, Simon Slavin wrote:
> On 6 Apr 2017, at 2:44pm, Tim Streater wrote:
>
>> That would appear not to be the case. Under OS X 10.9.5, I touched a
>> non-existent file and then using sqlite3.app did:
>>
>> .schema<-
On 06 Apr 2017 at 13:19, Simon Slavin wrote:
> On 6 Apr 2017, at 12:11pm, Tim Streater wrote:
>
>> When my app starts, I check that the file in question actually *is* a
>> database by doing some simple steps like open, selects from important tables,
>> and a read/wri
upport some new feature.
I don't user PRAGMA user_version because I keep reading that the continued
existence of any particular PRAGMA is completely un-guaranteed.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
splay.
This is also what I do; seconds since the epoch. I can't imagine string dates
or times as strings. You're also going to need to give the user the option to
select their date/time format, too, so converting to display should be done at
display time, not befor
1 - 100 of 644 matches
Mail list logo
