Using odbc on windows 10 with mssql 2012 with web app.
error invalid precision value
is there a question here?
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)
where is a reference to a named database TABLE? or the row for that matter
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
are there more fields than just those 3?
is there a numeric field that is not allowed to be Null?
yes but i pass all fields with data and same error
That is an known error when using UFT-16 Values with ODBC… Perhaps your String to insert is longer then the Databasefield…
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 “”