Click here to Skip to main content
15,845,469 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: How do i populate say combobox2 depending on a *selected* ms access database table in combobox1 without writing If statements for each and every table in the database in vb.net windows forms Pin
jschell9-Nov-23 8:18
jschell9-Nov-23 8:18 
QuestionChange Field Data Type in SQLite DB and Use with changes Pin
Choroid27-Oct-23 16:47
Choroid27-Oct-23 16:47 
AnswerRe: Change Field Data Type in SQLite DB and Use with changes Pin
Richard MacCutchan27-Oct-23 23:24
mveRichard MacCutchan27-Oct-23 23:24 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Choroid28-Oct-23 9:05
Choroid28-Oct-23 9:05 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Richard MacCutchan28-Oct-23 9:54
mveRichard MacCutchan28-Oct-23 9:54 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Choroid28-Oct-23 21:57
Choroid28-Oct-23 21:57 
AnswerRe: Change Field Data Type in SQLite DB and Use with changes Pin
Dave Kreskowiak28-Oct-23 5:39
mveDave Kreskowiak28-Oct-23 5:39 
AnswerRe: Change Field Data Type in SQLite DB and Use with changes Pin
Choroid28-Oct-23 21:55
Choroid28-Oct-23 21:55 
Make Changes in the DB manually with DB Browser This was perhaps the simplest solution for me

I did not want to learn all the code to put these commands behind a button click procedure


DB Browse has a tab labeled Execute SQL so my first task was to create a new Column in the DB Table

SQL
ALTER TABLE TxData ADD NxData INTEGER

Where TxData is the TABLE name and NxData is a new column with INTEGER type data. I hope

Next I needed to write the values in the old column to the new colum

SQL
UPDATE TxData SET NxData = txSearchMonth

OK Now we still have a column txSearchMonth that is referenced in the SQLite searches in the application

Because this column was created as a column with TEXT it needs to be deleted

It was causing errors in my SQLite Searches
SQL
ALTER TABLE TxData DROP COLUMN txSearchMonth

One last step I have not implemented that will save me from rewriting code in the searches is to RE-Name

the NxData column to txSearchMonth


Any one who wants to share a little code to use these commands with a button click feel free I am all EYE's
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Richard MacCutchan28-Oct-23 23:33
mveRichard MacCutchan28-Oct-23 23:33 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Choroid29-Oct-23 7:02
Choroid29-Oct-23 7:02 
GeneralRe: Change Field Data Type in SQLite DB and Use with changes Pin
Richard MacCutchan29-Oct-23 7:20
mveRichard MacCutchan29-Oct-23 7:20 
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 
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 

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.