I'm coding that now. I never thought about it. Thank you!
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Jens Alfke
Sent: Friday, January 5, 2018 1:34 PM
To: SQLite mailing list
Subject: Re: [sqlite] new Error database disk imag
8, at 4:51 PM, Ron Barnes wrote:
>
> I hope not since I use synclock in my code when ever a thread is attempting a
> write to the database. That seems like the only issue from that page that I
> may be doing. I could have up to 30 or more threads reading from the DB but
> only
ubject: Re: [sqlite] new Error database disk image is malformed
On 2018/01/04 9:49 PM, Ron Barnes wrote:
> Hi All,
>
> I keep generating this error and I can't figure out why. I have deleted and
> re-created the database but it keeps popping up.
>
> Error
>
> d
malformed
On 2018/01/04 9:49 PM, Ron Barnes wrote:
> Hi All,
>
> I keep generating this error and I can't figure out why. I have deleted and
> re-created the database but it keeps popping up.
>
> Error
>
> database disk image is malformed
>
>
> Any ide
Hi All,
I keep generating this error and I can't figure out why. I have deleted and
re-created the database but it keeps popping up.
Error
database disk image is malformed
Any ideas why?
-Ron
___
sqlite-users mailing list
sqlite-users@mailin
😊
Than you!
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Stephen Chrzanowski
Sent: Tuesday, September 26, 2017 4:31 PM
To: SQLite mailing list
Subject: Re: [sqlite] Is there a way to perform a muti-level sort and extract
of la
[sqlite] Is there a way to perform a muti-level sort and
>extract of large data sets?
>
>
>
>On 26 Sep 2017, at 6:24pm, Ron Barnes wrote:
>
>> I need to sort them as follows...
>>
>> Sort Field 1 Ascending
>> Sort Field 2 Ascending WITHIN field 1 Sort
Sent: Tuesday, September 26, 2017 2:14 PM
To: SQLite mailing list
Subject: Re: [sqlite] Is there a way to perform a muti-level sort and extract
of large data sets?
On Sep 26, 2017, at 11:24 AM, Ron Barnes wrote:
>
> I have approximately 600 million records that need to be sorted
Where
perform a muti-level sort and extract
of large data sets?
On 26 Sep 2017, at 6:24pm, Ron Barnes wrote:
> I need to sort them as follows...
>
> Sort Field 1 Ascending
> Sort Field 2 Ascending WITHIN field 1
> Sort Field 3 Ascending WITHIN field 2 WITHIN field 1 Sort Field 4
>
Hello All,
I have approximately 600 million records that need to be sorted and then
extracted to a flat file. I am unable to code a solution using visual Basic
.NET. It was suggested to me that a DB engine could perform my task for me.
Is there a way to accomplish this using the multi-level s
ction.html> named "regexp"
is added at run-time, then the "*X* REGEXP *Y*" operator will be implemented as
a call to "regexp(*Y*,*X*)".
https://sqlite.org/lang_expr.html
Type of regular expression needed:
https://social.msdn.microsoft.com/Forums/en-US/7f38ee7b-15e
/Time field Statement question
On 2017/04/12 3:08 PM, Ron Barnes wrote:
> Hello Ryan,
>
> That Code below worked as you said it should. Awesome! And Thank you!
>
> I now have the days difference for each row.
>
> I have one other question if I may pose it to you, how do I c
S category
FROM Volume_Information) derivedtbl_1
GROUP BY category
Thanks,
-Ron
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of R Smith
Sent: Wednesday, April 12, 2017 8:32 AM
To: sqlite-users@mailinglists.sqlite.org
Subject: Re:
-users@mailinglists.sqlite.org
Subject: Re: [sqlite] SQLite - Interrogate Date/Time field Statement question
On 2017/04/12 1:24 AM, Ron Barnes wrote:
> Hello all,
>
> To everyone who helped me before - thank you very much!
>
> I'm coding in Visual Basic .NET (Visual Studio 2015) C
d as
a call to "regexp(*Y*,*X*)".
https://sqlite.org/lang_expr.html
Type of regular expression needed:
https://social.msdn.microsoft.com/Forums/en-US/7f38ee7b-15e2-4e2c-8389-1266f496e4b2/regular-expression-to-get-date-format-from-string?forum=csharplanguage
​Jim Callahan
On Tue, Apr 11, 2017 at 10:0
-boun...@mailinglists.sqlite.org] On
Behalf Of Simon Slavin
Sent: Tuesday, April 11, 2017 9:31 PM
To: SQLite mailing list
Subject: Re: [sqlite] Select Statement returning incorrect information
On 12 Apr 2017, at 2:27am, Ron Barnes wrote:
> I needed to add the Cast parameter.
Assuming you are
el
Your specification actually requires day counts; so you may need Julian dates
after all.
Jim Callahan
Orlando, FL
On Tue, Apr 11, 2017 at 7:24 PM, Ron Barnes wrote:
> Hello all,
>
> To everyone who helped me before - thank you very much!
>
> I'm coding in Visual Basic
ss Than 25 GB'
ELSE 'Larger Than 25GB' END) AS category
FROM Volume_Information) derivedtbl_1
GROUP BY category
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Ron Barnes
Sent: Tuesday, April 11, 2017 9:15 PM
To:
Hello All,
With the select statement below and my test data of 43 files, I expected the
following results
22 'Less than 1MB'
4 'Less than 5MB'
7 'Less than 10MB'
4 'Less than 15MB'
6 'Less than 20MB'
Instead I get
16 'Less than 1MB'
18 'Less than 5MB'
9 'Larger than 25GB'
I have been pulling
Hello all,
To everyone who helped me before - thank you very much!
I'm coding in Visual Basic .NET (Visual Studio 2015) Community.
I have to count a Date/Time field and the problem is, this field contains data
in a format I'm not sure can be counted.
I need to count all the dates in the field
Hi All,
I am new to this mailing list.
Is anyone working with Visual Studio 2015 or belter and using reportviewer? If
yes, what was the procedure?
I'm having the devils of a time trying to generate reports using SQLite.
Would anyone be able to provide a TuT or maybe a link to one tha can help?
All,
Pardon me for interjecting.
Are there any reporting solutions that work with VB 2015?
-Ron
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of James K. Lowden
Sent: Saturday, April 1, 2017 8:11 PM
To: sqlite-users@mailinglists.s
22 matches
Mail list logo