Click here to Skip to main content
15,886,065 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
ZurdoDev26-Aug-19 7:38
professionalZurdoDev26-Aug-19 7:38 
AnswerRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Richard Deeming27-Aug-19 2:55
mveRichard Deeming27-Aug-19 2:55 
GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Augusto10027-Aug-19 5:36
Augusto10027-Aug-19 5:36 
GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Richard Deeming27-Aug-19 5:40
mveRichard Deeming27-Aug-19 5:40 
GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Augusto10027-Aug-19 6:23
Augusto10027-Aug-19 6:23 
GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Richard Deeming27-Aug-19 6:30
mveRichard Deeming27-Aug-19 6:30 
GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Augusto10027-Aug-19 6:36
Augusto10027-Aug-19 6:36 
GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Richard Deeming27-Aug-19 7:07
mveRichard Deeming27-Aug-19 7:07 
DO NOT STORE NUMBERS AS STRINGS!

Numbers do not have "commas" or other formatting information. They are just numbers.

1,234.56 is the same as 1234.56, which is the same as 1234.5600. They are all the same number.

If you're trying to store formatted values in your database, then you're doing it wrong.

Store values in the correct data type, and format the values in the user interface.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Mycroft Holmes27-Aug-19 15:14
professionalMycroft Holmes27-Aug-19 15:14 
QuestionCount the number of database hit were made Pin
desanti24-Aug-19 12:37
desanti24-Aug-19 12:37 
AnswerRe: Count the number of database hit were made Pin
Gerry Schmitz25-Aug-19 2:30
mveGerry Schmitz25-Aug-19 2:30 
GeneralRe: Count the number of database hit were made Pin
desanti25-Aug-19 3:49
desanti25-Aug-19 3:49 
GeneralRe: Count the number of database hit were made Pin
Gerry Schmitz25-Aug-19 11:38
mveGerry Schmitz25-Aug-19 11:38 
GeneralRe: Count the number of database hit were made Pin
desanti25-Aug-19 15:07
desanti25-Aug-19 15:07 
AnswerRe: Count the number of database hit were made Pin
Mycroft Holmes26-Aug-19 12:14
professionalMycroft Holmes26-Aug-19 12:14 
GeneralRe: Count the number of database hit were made Pin
desanti26-Aug-19 13:41
desanti26-Aug-19 13:41 
AnswerRe: Count the number of database hit were made Pin
Richard Deeming27-Aug-19 2:46
mveRichard Deeming27-Aug-19 2:46 
QuestionAre these queries doing the same thing Pin
desanti24-Aug-19 6:37
desanti24-Aug-19 6:37 
QuestionRe: Are these queries doing the same thing Pin
Richard MacCutchan24-Aug-19 20:54
mveRichard MacCutchan24-Aug-19 20:54 
AnswerRe: Are these queries doing the same thing Pin
Eddy Vluggen28-Aug-19 23:49
professionalEddy Vluggen28-Aug-19 23:49 
QuestionDigital Personal fmd.Serialized and fmd.Deserialized Pin
Member 1404752219-Aug-19 22:22
Member 1404752219-Aug-19 22:22 
GeneralRe: Digital Personal fmd.Serialized and fmd.Deserialized Pin
Richard MacCutchan19-Aug-19 23:35
mveRichard MacCutchan19-Aug-19 23:35 
GeneralRe: Digital Personal fmd.Serialized and fmd.Deserialized Pin
Member 1404752221-Aug-19 21:40
Member 1404752221-Aug-19 21:40 
GeneralRe: Digital Personal fmd.Serialized and fmd.Deserialized Pin
Richard MacCutchan21-Aug-19 21:53
mveRichard MacCutchan21-Aug-19 21:53 
Generalaccess database using vb net Pin
cws_ap15-Aug-19 19:00
cws_ap15-Aug-19 19:00 

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.