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

--
Hyphessobrycon

[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.

"Hyphessobricon" <sy*********@telenet.be> escribió en el mensaje
news:tq********************@phobos.telenet-ops.be...

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

--
Hyphessobrycon

[Herfried K. Wagner [MVP]]

"VBen" <bm******@compucaremexico.com> schrieb:

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.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Hyphessobricon]

"VBen" <bm******@compucaremexico.com> schreef in bericht
news:ew**************@TK2MSFTNGP10.phx.gbl...

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.

"Hyphessobricon" <sy*********@telenet.be> escribió en el mensaje
news:tq********************@phobos.telenet-ops.be...

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

--
Hyphessobrycon

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

a thankful Hyphessobrycon