Re: [sqlite] Reporting Solutions that work with SQLite / VB 2015?

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:

Re: [sqlite] Continuous recovery of journal

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

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

-the-1904-date-system-in-excel 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 <rbar...@njdevils.net> wrote: > Hello all, > > To everyone who helped me before - thank you ver

[sqlite] Select Statement returning incorrect information

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

[sqlite] SQLite - Interrogate Date/Time field Statement question

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

Re: [sqlite] Select Statement returning incorrect information

riginal 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: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org> Subject: [sqlite] Select Statement returning incorrect information Hello All,

Re: [sqlite] Select Statement returning incorrect information

...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Tuesday, April 11, 2017 9:31 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Select Statement returning incorrect information On 12 Apr 2017, at 2:27am, Ron Barnes <rbar...@njdevils.net> wrote:

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

/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

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

uot;. 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:00 PM, Ron Barnes <rbar...@

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

-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) Commun

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

@mailinglists.sqlite.org] On Behalf Of R Smith Sent: Wednesday, April 12, 2017 8:32 AM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite - Interrogate Date/Time field Statement question On 2017/04/12 2:13 PM, Ron Barnes wrote: > Hi Jim, > > I ran an overnight job

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

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-15e2-4e2c-8389-1266f496e4b2/regular-expression-to-g

Re: [sqlite] Is there a way to perform a muti-level sort and extract of large data sets?

: SQLite mailing list >Subject: Re: [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 <rbar...@njdevils.net> wrote: > >> I need to sort them as follows... >> >> Sort Field

Re: [sqlite] Is there a way to perform a muti-level sort and extract of large data sets?

Sent: Tuesday, September 26, 2017 2:14 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> 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 <rbar...@njdevils.net> wrote:

Re: [sqlite] Is there a way to perform a muti-level sort and extract of large data sets?

org> Subject: Re: [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 <rbar...@njdevils.net> wrote: > I need to sort them as follows... > > Sort Field 1 Ascending > Sort Field 2 Ascending WITHIN field 1

Re: [sqlite] Is there a way to perform a muti-level sort and extract of large data sets?

 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

[sqlite] Is there a way to perform a muti-level sort and extract of large data sets?

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

Re: [sqlite] new Error database disk image is malformed

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:

[sqlite] new Error database disk image is malformed

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

Re: [sqlite] new Error database disk image is malformed

: [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 > > database di

Re: [sqlite] new Error database disk image is malformed

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 > > database disk image is malformed > > > Any ideas wh

Re: [sqlite] new Error database disk image is malformed

image is malformed > On Jan 4, 2018, at 4:51 PM, Ron Barnes <rbar...@njdevils.net> 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 ha