On Wed, 10 Oct 2018 at 05:18, Warren Young wrote:
> That event was the immediate spur to start this Fossil forum project, but
> if you search the archives, there are multiple threads. Here’s one from
> about a year ago:
>
>
>
On Sat, 13 Oct 2018 at 02:20, Lars Frederiksen wrote:
> I type info into some labeledits and by pressing "Append to DB" button
> this code is executed (fdqGoser2 is a FDQuery)
>
> fdqGloser2.Open;
> fdqGloser2.Append;
> fdqGloser2.FieldByName('Graesk').AsString:= ledGræsk.Text;
> ...
>
On Sat, 13 Oct 2018 at 00:21, Chris Locke wrote:
> > 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.
>
For the record, "delete the journal file" is terrible
On Sunday, 14 October, 2018 12:38, Roger Binns wrote:
>I use sqlite3_complete in my shell in order to determine when a
>complete statement has been input and can be run. (Otherwise a continuation
>"sqlite> " prompt is shown.)
>If the line entered is:
>
> -- hello
>Then the sqlite shell
Comments have no effect on the completeness of a statement, you will have
to look for leading '--' explicitly.
On Sun., 14 Oct. 2018, 13:38 Roger Binns, wrote:
> I use sqlite3_complete in my shell in order to determine when a complete
> statement has been input and can be run. (Otherwise a
I use sqlite3_complete in my shell in order to determine when a complete
statement has been input and can be run. (Otherwise a continuation
"sqlite> " prompt is shown.)
If the line entered is:
-- hello
Then the sqlite shell does not issue a continuation and "executes" the
text. However
On 14-10-2018 17:07, J Decker wrote:
> (sorry for the math err s/16/32/g and s/512/256/ - I double and halfed
> the wrong directions.)
>
> On Sun, Oct 14, 2018 at 7:57 AM J Decker wrote:
>
>>
>> On Sun, Oct 14, 2018 at 7:24 AM Luuk wrote:
>>
>>> On 14-10-2018 16:17, Simon Slavin wrote:
On
(sorry for the math err s/16/32/g and s/512/256/ - I double and halfed
the wrong directions.)
On Sun, Oct 14, 2018 at 7:57 AM J Decker wrote:
>
>
> On Sun, Oct 14, 2018 at 7:24 AM Luuk wrote:
>
>> On 14-10-2018 16:17, Simon Slavin wrote:
>> > On 14 Oct 2018, at 12:56pm, J Decker wrote:
>> >
On 14 Oct 2018, at 3:24pm, J Decker wrote:
> B and C would apply if there was a vacuum also; adding data, and deleteting
> data, the db ends up with lots of zeros
> Also between non-integral pages; messages that are say 700 bytes; so 4096%
> 700 is 596; which is all filled with zeros...
On Sun, Oct 14, 2018 at 7:24 AM Luuk wrote:
> On 14-10-2018 16:17, Simon Slavin wrote:
> > On 14 Oct 2018, at 12:56pm, J Decker wrote:
> >
> >> Is there maybe a compile option for sqlite to fill empty space in a db
> with random data rather than 0 ?
> > There is not. But
> >
> > (A) It may be
On 14-10-2018 16:17, Simon Slavin wrote:
> On 14 Oct 2018, at 12:56pm, J Decker wrote:
>
>> Is there maybe a compile option for sqlite to fill empty space in a db with
>> random data rather than 0 ?
> There is not. But
>
> (A) It may be an easy change to the source code
> (B) Your operating
On Sun, Oct 14, 2018 at 7:17 AM Simon Slavin wrote:
> On 14 Oct 2018, at 12:56pm, J Decker wrote:
>
> > Is there maybe a compile option for sqlite to fill empty space in a db
> with random data rather than 0 ?
>
> There is not. But
>
> (A) It may be an easy change to the source code
>
Sure;
On 14 Oct 2018, at 12:56pm, J Decker wrote:
> Is there maybe a compile option for sqlite to fill empty space in a db with
> random data rather than 0 ?
There is not. But
(A) It may be an easy change to the source code
(B) Your operating system may have a setting to do this automatically to
On Sun, Oct 14, 2018 at 5:48 AM Bob Gailer wrote:
> On Oct 14, 2018 7:57 AM, "J Decker" wrote:
> >
> > Is there maybe a compile option for sqlite to fill empty space in a db
> with
> > random data rather than 0 ?
>
> I don't know about compile options.
>
> You could do a 1 time update to set
On Oct 14, 2018 7:57 AM, "J Decker" wrote:
>
> Is there maybe a compile option for sqlite to fill empty space in a db
with
> random data rather than 0 ?
I don't know about compile options.
You could do a 1 time update to set all 0 columns to random(1,99), and
create a trigger to do the same on
Is there maybe a compile option for sqlite to fill empty space in a db with
random data rather than 0 ?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On Tue, Oct 9, 2018 at 5:18 PM Warren Young wrote:
> ... The problem is happening because spam gets reflected off this list, so
> people click “This is Spam” in Gmail, which causes Gmail’s spam filters to
> treat all messages on the list as more spammish. The more that happens,
> the less
17 matches
Mail list logo
