updating a deciimal (sql in VB.Net)

[Hyphessobricon]

Hallo,

could you help with this problem?
Updating an integer, as tring ok, but a decimal ??
Update tblprice Set article = ' " & this & " ' WHERE ...
what signs do I have to put?
Thx for helping me

 

[VBen]

You should not use quotes (not single nor double) to update numeric values
in SQL.
Instead, leave the value "as is":
tmpSQL = "update MyTable set MyIntegerValue = " & MyInt & ", MyDecimalValue
= " & MyDec & ", MyStringValue = '" & MyString & "', MyBooleanValue = " &
CInt(MyBool)
I don't know if this is what you want. Let me know.
Hope this helps.
VBen.

 

[Herfried K. Wagner [MVP]]

You should not use quotes (not single nor double) to update numeric values
in SQL.
Instead, leave the value "as is":
tmpSQL = "update MyTable set MyIntegerValue = " & MyInt & ",
MyDecimalValue
= " & MyDec & ", MyStringValue = '" & MyString & "', MyBooleanValue = " &
CInt(MyBool)

.... and even better, use a parameterized '*Command' object instead of
inserting the values into the SQL command string by hand.

 

[Hyphessobricon]

You should not use quotes (not single nor double) to update numeric values
in SQL.
Instead, leave the value "as is":
tmpSQL = "update MyTable set MyIntegerValue = " & MyInt & ",
MyDecimalValue
= " & MyDec & ", MyStringValue = '" & MyString & "', MyBooleanValue = " &
CInt(MyBool)
I don't know if this is what you want. Let me know.
Hope this helps.
VBen.

Hallo,

could you help with this problem?
Updating an integer, as tring ok, but a decimal ??
Update tblprice Set article = ' " & this & " ' WHERE ...
what signs do I have to put?
Thx for helping me

That's exactly what I was looking for.
Thanks an awful lot VBen

a thankful Hyphessobrycon