Click here to Skip to main content
14,451,642 members

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 8:38
mveZurdoDev26-Aug-19 8: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 3:55
communityengineerRichard Deeming27-Aug-19 3: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 6:36
MemberAugusto10027-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 6:40
communityengineerRichard Deeming27-Aug-19 6: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 7:23
MemberAugusto10027-Aug-19 7: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 7:30
communityengineerRichard Deeming27-Aug-19 7: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 7:36
MemberAugusto10027-Aug-19 7: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 8:07
communityengineerRichard Deeming27-Aug-19 8: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 16:14
MemberMycroft Holmes27-Aug-19 16:14 
QuestionCount the number of database hit were made Pin
desanti24-Aug-19 13:37
Memberdesanti24-Aug-19 13:37 
AnswerRe: Count the number of database hit were made Pin
Gerry Schmitz25-Aug-19 3:30
mveGerry Schmitz25-Aug-19 3:30 
GeneralRe: Count the number of database hit were made Pin
desanti25-Aug-19 4:49
Memberdesanti25-Aug-19 4:49 
GeneralRe: Count the number of database hit were made Pin
Gerry Schmitz25-Aug-19 12:38
mveGerry Schmitz25-Aug-19 12:38 
GeneralRe: Count the number of database hit were made Pin
desanti25-Aug-19 16:07
Memberdesanti25-Aug-19 16:07 
AnswerRe: Count the number of database hit were made Pin
Mycroft Holmes26-Aug-19 13:14
MemberMycroft Holmes26-Aug-19 13:14 
GeneralRe: Count the number of database hit were made Pin
desanti26-Aug-19 14:41
Memberdesanti26-Aug-19 14:41 
AnswerRe: Count the number of database hit were made Pin
Richard Deeming27-Aug-19 3:46
communityengineerRichard Deeming27-Aug-19 3:46 
QuestionAre these queries doing the same thing Pin
desanti24-Aug-19 7:37
Memberdesanti24-Aug-19 7:37 
QuestionRe: Are these queries doing the same thing Pin
Richard MacCutchan24-Aug-19 21:54
communityengineerRichard MacCutchan24-Aug-19 21:54 
AnswerRe: Are these queries doing the same thing Pin
Eddy Vluggen29-Aug-19 0:49
professionalEddy Vluggen29-Aug-19 0:49 
QuestionDigital Personal fmd.Serialized and fmd.Deserialized Pin
Member 1404752219-Aug-19 23:22
MemberMember 1404752219-Aug-19 23:22 
GeneralRe: Digital Personal fmd.Serialized and fmd.Deserialized Pin
Richard MacCutchan20-Aug-19 0:35
communityengineerRichard MacCutchan20-Aug-19 0:35 
GeneralRe: Digital Personal fmd.Serialized and fmd.Deserialized Pin
Member 1404752221-Aug-19 22:40
MemberMember 1404752221-Aug-19 22:40 
GeneralRe: Digital Personal fmd.Serialized and fmd.Deserialized Pin
Richard MacCutchan21-Aug-19 22:53
communityengineerRichard MacCutchan21-Aug-19 22:53 
Generalaccess database using vb net Pin
cws_ap15-Aug-19 20:00
Membercws_ap15-Aug-19 20: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.