Click here to Skip to main content
15,851,915 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Choroid29-Oct-23 19:18
Choroid29-Oct-23 19:18 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Richard MacCutchan29-Oct-23 23:39
mveRichard MacCutchan29-Oct-23 23:39 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Choroid30-Oct-23 6:30
Choroid30-Oct-23 6:30 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Richard MacCutchan30-Oct-23 7:24
mveRichard MacCutchan30-Oct-23 7:24 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
jschell31-Oct-23 6:58
jschell31-Oct-23 6:58 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Dave Kreskowiak31-Oct-23 7:42
mveDave Kreskowiak31-Oct-23 7:42 
AnswerRe: Change Field Data Type in SQLite DB and Use with changes Pin
Gerry Schmitz29-Oct-23 7:26
mveGerry Schmitz29-Oct-23 7:26 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
k505429-Oct-23 8:45
mvek505429-Oct-23 8:45 
Are you aware that SQLite does not statically type it's columns, so even if you declare a column as type int, you can still insert any value into the column and SQLite will not validate for you?

e.g.
SQL
sqlite> create table test(i int, d date);
sqlite> insert into test(i,d) values("seven", "Hello");
sqlite> insert into test(i, d) values(7, "2023-01-01");
sqlite> select * from test;
seven|Hello
7|2023-01-01
sqlite>

See Datatypes In SQLite

Since that's the case, you might wish to write insert/update triggers so that invalid input is flagged before database insert/updates. That might cause significant performance degradation, though, so maybe strict data validation in the application and the data converter would be a better approach.
Keep Calm and Carry On

GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Choroid29-Oct-23 19:33
Choroid29-Oct-23 19:33 
QuestionVB.Net SQLite Search Between two Integers Pin
Choroid24-Oct-23 17:03
Choroid24-Oct-23 17:03 
AnswerRe: VB.Net SQLite Search Between two Integers Pin
Gerry Schmitz24-Oct-23 20:56
mveGerry Schmitz24-Oct-23 20:56 
GeneralRe: VB.Net SQLite Search Between two Integers Pin
Choroid25-Oct-23 7:26
Choroid25-Oct-23 7:26 
GeneralRe: VB.Net SQLite Search Between two Integers Pin
Choroid25-Oct-23 14:08
Choroid25-Oct-23 14:08 
GeneralRe: VB.Net SQLite Search Between two Integers Pin
Choroid28-Oct-23 22:13
Choroid28-Oct-23 22:13 
AnswerRe: VB.Net SQLite Search Between two Integers Pin
Choroid25-Oct-23 14:04
Choroid25-Oct-23 14:04 
GeneralRe: VB.Net SQLite Search Between two Integers Pin
Richard Deeming25-Oct-23 23:36
mveRichard Deeming25-Oct-23 23:36 
GeneralRe: VB.Net SQLite Search Between two Integers Pin
Choroid26-Oct-23 7:02
Choroid26-Oct-23 7:02 
QuestionIssue with "Windows Form App" Disappearing in VB.NET 2022 Pin
ionline4u26-Aug-23 23:53
ionline4u26-Aug-23 23:53 
AnswerRe: Issue with "Windows Form App" Disappearing in VB.NET 2022 Pin
Victor Nijegorodov27-Aug-23 1:05
Victor Nijegorodov27-Aug-23 1:05 
GeneralRe: Issue with "Windows Form App" Disappearing in VB.NET 2022 Pin
ionline4u27-Aug-23 1:35
ionline4u27-Aug-23 1:35 
GeneralRe: Issue with "Windows Form App" Disappearing in VB.NET 2022 Pin
Dave Kreskowiak27-Aug-23 5:56
mveDave Kreskowiak27-Aug-23 5:56 
GeneralRe: Issue with "Windows Form App" Disappearing in VB.NET 2022 Pin
Richard MacCutchan27-Aug-23 7:28
mveRichard MacCutchan27-Aug-23 7:28 
AnswerRe: Issue with "Windows Form App" Disappearing in VB.NET 2022 Pin
Richard MacCutchan27-Aug-23 2:29
mveRichard MacCutchan27-Aug-23 2:29 
QuestionPrinterSettings.CanDuplex appears to not be working Pin
lewist5721-Aug-23 6:27
lewist5721-Aug-23 6:27 
AnswerRe: PrinterSettings.CanDuplex appears to not be working Pin
Gerry Schmitz22-Aug-23 8:48
mveGerry Schmitz22-Aug-23 8:48 

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.