Click here to Skip to main content
15,879,613 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Change Field Data Type in SQLite DB and Use with changes Pin
Dave Kreskowiak28-Oct-23 4:39
mveDave Kreskowiak28-Oct-23 4:39 
AnswerRe: Change Field Data Type in SQLite DB and Use with changes Pin
Choroid28-Oct-23 20:55
Choroid28-Oct-23 20:55 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Richard MacCutchan28-Oct-23 22:33
mveRichard MacCutchan28-Oct-23 22:33 
That is one of the most dangerous processes I have ever seen. Modifying your live data base in place and even dropping columns is something I would never dream of.

Also in the following statement:
SQL
UPDATE TxData SET NxData = txSearchMonth

You need to check that the NxData column has actually been converted from TEXT to INTEGER, because SQLite is quite happy storing text in integer fields: see Datatypes In SQLite[^].
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Choroid29-Oct-23 6:02
Choroid29-Oct-23 6:02 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Richard MacCutchan29-Oct-23 6:20
mveRichard MacCutchan29-Oct-23 6:20 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Choroid29-Oct-23 18:18
Choroid29-Oct-23 18:18 
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 
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 

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.