Click here to Skip to main content
15,880,392 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
jschell31-Oct-23 5:58
jschell31-Oct-23 5:58 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Dave Kreskowiak31-Oct-23 6:42
mveDave Kreskowiak31-Oct-23 6:42 
AnswerRe: Change Field Data Type in SQLite DB and Use with changes Pin
Gerry Schmitz29-Oct-23 6:26
mveGerry Schmitz29-Oct-23 6:26 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
k505429-Oct-23 7:45
mvek505429-Oct-23 7:45 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Choroid29-Oct-23 18:33
Choroid29-Oct-23 18:33 
QuestionVB.Net SQLite Search Between two Integers Pin
Choroid24-Oct-23 16:03
Choroid24-Oct-23 16:03 
AnswerRe: VB.Net SQLite Search Between two Integers Pin
Gerry Schmitz24-Oct-23 19:56
mveGerry Schmitz24-Oct-23 19:56 
GeneralRe: VB.Net SQLite Search Between two Integers Pin
Choroid25-Oct-23 6:26
Choroid25-Oct-23 6:26 
I agree on the use of Integer and Strings in a search not the best design.
Other searches where I use just one month and the year work fine.

FWIW if I search for Jan to Feb by not using Feb and use Mar instead I get the proper results
ie Jan & Feb data only. It is as if the rdr does not know when to stop reading ? ? ?

When the app loads this test runs.It is to find the 4 Tue of the month. Could it be interfering ?

VB
    Function FourthTueOfNextMonth(dt As Date) As Date
        ' Start with the First Day of the Month, from the date passed in.
        ' Add one Month to that to get the first Day of the NEXT month.
        Dim currDate As Date = (New Date(dt.Year, dt.Month, 1)).AddMonths(1)
        ' Find the First Tuesday of the Month
        While currDate.DayOfWeek <> DayOfWeek.Tuesday
            currDate = currDate.AddDays(1)
        End While
        ' Add three more Weeks to jump to Fourth Tuesday
        Return currDate.AddDays(21)
    End Function

I have looked at the DB with DB Browser all data looks fine 
When I create the table I used this syntax
txSearchMonth TEXT)" same format for Year
Not sure changing to Numeric would solve the issue.
Thanks for the reply

GeneralRe: VB.Net SQLite Search Between two Integers Pin
Choroid25-Oct-23 13:08
Choroid25-Oct-23 13:08 
GeneralRe: VB.Net SQLite Search Between two Integers Pin
Choroid28-Oct-23 21:13
Choroid28-Oct-23 21:13 
AnswerRe: VB.Net SQLite Search Between two Integers Pin
Choroid25-Oct-23 13:04
Choroid25-Oct-23 13:04 
GeneralRe: VB.Net SQLite Search Between two Integers Pin
Richard Deeming25-Oct-23 22:36
mveRichard Deeming25-Oct-23 22:36 
GeneralRe: VB.Net SQLite Search Between two Integers Pin
Choroid26-Oct-23 6:02
Choroid26-Oct-23 6:02 
QuestionIssue with "Windows Form App" Disappearing in VB.NET 2022 Pin
ionline4u26-Aug-23 22:53
ionline4u26-Aug-23 22:53 
AnswerRe: Issue with "Windows Form App" Disappearing in VB.NET 2022 Pin
Victor Nijegorodov27-Aug-23 0:05
Victor Nijegorodov27-Aug-23 0:05 
GeneralRe: Issue with "Windows Form App" Disappearing in VB.NET 2022 Pin
ionline4u27-Aug-23 0:35
ionline4u27-Aug-23 0:35 
GeneralRe: Issue with "Windows Form App" Disappearing in VB.NET 2022 Pin
Dave Kreskowiak27-Aug-23 4:56
mveDave Kreskowiak27-Aug-23 4:56 
GeneralRe: Issue with "Windows Form App" Disappearing in VB.NET 2022 Pin
Richard MacCutchan27-Aug-23 6:28
mveRichard MacCutchan27-Aug-23 6:28 
AnswerRe: Issue with "Windows Form App" Disappearing in VB.NET 2022 Pin
Richard MacCutchan27-Aug-23 1:29
mveRichard MacCutchan27-Aug-23 1:29 
QuestionPrinterSettings.CanDuplex appears to not be working Pin
lewist5721-Aug-23 5:27
lewist5721-Aug-23 5:27 
AnswerRe: PrinterSettings.CanDuplex appears to not be working Pin
Gerry Schmitz22-Aug-23 7:48
mveGerry Schmitz22-Aug-23 7:48 
QuestionConvert/Read SQL Image field into pdf Pin
Benniit19-Jul-23 9:07
Benniit19-Jul-23 9:07 
AnswerRe: Convert/Read SQL Image field into pdf Pin
Richard MacCutchan19-Jul-23 22:18
mveRichard MacCutchan19-Jul-23 22:18 
GeneralRe: Convert/Read SQL Image field into pdf Pin
Benniit20-Jul-23 4:22
Benniit20-Jul-23 4:22 
GeneralRe: Convert/Read SQL Image field into pdf Pin
Richard MacCutchan20-Jul-23 4:32
mveRichard MacCutchan20-Jul-23 4:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.