mssql invalid precision value

Databases
1

Using odbc on windows 10 with mssql 2012 with web app.
error invalid precision value

2

is there a question here?

3

yes
if any one now about this error invalid precision value by ODBCDatabase

Dim Db as ODBCDatabase
Db =New ODBCDatabase
row.Column(“Name”) = “Penguins”
row.Column(“Coach”) = “Bob Roberts”
row.Column(“City”) = “Boston”

DB.InsertRecord(“Team”, row)

4

where is a reference to a named database TABLE? or the row for that matter

5

Sorry

Dim Db as ODBCDatabase
Dim row as DatabaseRecord

Db =New ODBCDatabase
row=New DatabaseRecord

row.Column(“Name”) = “Penguins”
row.Column(“Coach”) = “Bob Roberts”
row.Column(“City”) = “Boston”

DB.InsertRecord(“Team”, row)

i have all connect to msqlserver with no problems the problem is when i go to InsertRecord

6

are there more fields than just those 3?
is there a numeric field that is not allowed to be Null?

7

yes but i pass all fields with data and same error

8

That is an known error when using UFT-16 Values with ODBC… Perhaps your String to insert is longer then the Databasefield…

9

For numeric fields use row.intergercolumn
row.IntegerColumn(“Qty”) = 3
You indicated that you have numeric fields that do not allow Null. So just enter 0 if no value. You will need to enter Some value if Null is not allowed. For text fields that don’t allow Null you can use an empty string “”