Click here to Skip to main content
15,847,653 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Which Visual Studio is right for ME? Pin
ramsey benson26-Jan-24 12:52
ramsey benson26-Jan-24 12:52 
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 
Lots of problems here.

Kudzanai Victor wrote:
Select * from ABRASIVE_CUT_OFF_SAW


Problem 1 (most serious): The name of the tool should be kept IN a database column. It should NOT be a table.

Design you are looking for is likely like this

Table: Tool
Columns: Id, Name, Description

Table: Tool_Attribute
Columns: Tool_Id, Name, Description

If you need more detail for Attribute you might add one or two more columns. If more detail than that is added then you might need an additional third table.

Once you do the above then getting a list of all tools consists of querying the first table. This includes name, description AND the id.

Then detail for a single tool is gotten by using the id from the above list.

------------------------------------------

Kudzanai Victor wrote:
Select * from ABRASIVE_CUT_OFF_SAW


Problem 2: Don't use the asterisk.

Rather explicitly name the columns that you want to retrieve.
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 
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 

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.