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

Visual Basic

 
GeneralRe: Which Visual Studio is right for ME? Pin
Member 1510932527-Jan-24 0:12
Member 1510932527-Jan-24 0:12 
GeneralRe: Which Visual Studio is right for ME? Pin
Richard Andrew x6427-Jan-24 4:13
professionalRichard Andrew x6427-Jan-24 4:13 
Questionmysql to tally Pin
CHANDRA SEKAR Nov202230-Nov-23 21:52
CHANDRA SEKAR Nov202230-Nov-23 21:52 
AnswerRe: mysql to tally Pin
Dave Kreskowiak1-Dec-23 5:27
mveDave Kreskowiak1-Dec-23 5:27 
QuestionHow 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
Kudzanai Victor8-Nov-23 19:41
Kudzanai Victor8-Nov-23 19:41 
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
Richard MacCutchan8-Nov-23 22:39
mveRichard MacCutchan8-Nov-23 22:39 
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 
I have a SQLite DB attached to a VB.Net app. I have about two years of data I would like to not loose.
So with DB Browser I can change the two fields from TEXT to INTEGER.
Then make necessary changes in the code to reflect the changes in the DB.
Below are the variables that are declared in a Data Module used for searching
Public gvYear As String
Public gvFromMonth As Integer
Public gvToMonth As Integer

Only change here gvYear will become an Integer

Here is the code that created the original DB
Public Sub makeTxData()

       'create table TxDataTable String for cmd
       Dim create_table As String = String.Empty
       create_table = "CREATE TABLE IF NOT EXISTS TxData(
                       TID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
                       txSortDate TEXT,
                       txYear TEXT,
                       txType TEXT,
                       txAmount TEXT,
                       txCKNum TEXT,
                       txDesc TEXT,
                       txBalance TEXT,
                       txSearchMonth TEXT)"

       Dim dbTable As String = "TxDataTable"

Changes here txYear and txSearchMonth will be INTEGERS txSearchMonth int that reflects month of year

Steps for Process
Copy DB and Paste DB in another folder
Make Changes to Code that creates the DB
Make Changes in the DB manually with DB Browser
Uninstall the app and make new exe file with Inno Setup with new GUID
Create the new DB and delete the DB that is created then Paste the OLD DB in the new app version

I am sure I am overlooking something here so I guess the question is
Will this work ?
Is there a better way to accomplish this ?
Because this is a Check Book app I hate to loose the data.
What are the risks of this happening ?
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 
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 

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.