V
ven
hello i`m makin a asp.net service with database connection where i have an
insert with decimal value, when i run my function i get this error :
There are fewer columns in the INSERT statement than values specified in the
VALUES clause. The number of values in the VALUES clause must match the
number of columns specified in the INSERT statement
this is my insert :
Dim queryString2 = "INSERT INTO
[pozycja_zamowienia]([id_artykulu],[id_zamowienia],[cena_netto],[cena_brutto],[zamowiono],[trybrejestracji],[typ],[kod_vat],[jednostka])
values" & _
"('" & id_artykulu & "','" & numer & "'," & cena_netto & "," & cena_brutto &
"," & ilosc & ",'" & tryb & "','" & typ & "','" & kod_vat & "','" &
jednostka & "')"
where ilosc is my decimal value, everythings works when i have '" & ilosc &
"' and ilosc was a string value, but the database field is a decimal field
and i change ilosc from string to decimal and it wont work now
insert with decimal value, when i run my function i get this error :
There are fewer columns in the INSERT statement than values specified in the
VALUES clause. The number of values in the VALUES clause must match the
number of columns specified in the INSERT statement
this is my insert :
Dim queryString2 = "INSERT INTO
[pozycja_zamowienia]([id_artykulu],[id_zamowienia],[cena_netto],[cena_brutto],[zamowiono],[trybrejestracji],[typ],[kod_vat],[jednostka])
values" & _
"('" & id_artykulu & "','" & numer & "'," & cena_netto & "," & cena_brutto &
"," & ilosc & ",'" & tryb & "','" & typ & "','" & kod_vat & "','" &
jednostka & "')"
where ilosc is my decimal value, everythings works when i have '" & ilosc &
"' and ilosc was a string value, but the database field is a decimal field
and i change ilosc from string to decimal and it wont work now