Click here to Skip to main content
15,877,280 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Richard MacCutchan29-Oct-23 22:39
mveRichard MacCutchan29-Oct-23 22:39 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Choroid30-Oct-23 5:30
Choroid30-Oct-23 5:30 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Richard MacCutchan30-Oct-23 6:24
mveRichard MacCutchan30-Oct-23 6:24 
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 
Are you aware that SQLite does not statically type it's columns
I was that is why I designed the DB with all the columns as TEXT
The issue was the search variable txSearchMonth is not entered it is being read from the DB as TEXT
Only the two variables gvFromMonth & gvToMonth are selected from a drop down combo box
the txSearchMonth only contains 1 to 12
So because they were TEXT a search for 1 to 3 would bring 10 data along
When I changed the txSearchMonth to INTEGER with these lines of code in DB Browser the search function as intended

ALTER TABLE TxData ADD NxData INTEGER

UPDATE TxData SET NxData = txSearchMonth

ALTER TABLE TxData DROP COLUMN txSearchMonth

ALTER TABLE TxData RENAME COLUMN NxData to txSearchMonth


VB
cmd.CommandText = "SELECT * FROM TxData WHERE txSearchMonth >= $gvFromMonth AND txSearchMonth <= $gvToMonth AND txYear = $gvYear "


Thanks for the reply and advice
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 
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 

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.