T
TR
I am at this point (<<<) in my Insert logic against a SQL2000 back-end:
Try
....
MyDataset.Tables(0).DefaultView.RowStateFilter = DataViewRowState.Added
If MyDataset.Tables(0).DefaultView.Count > 0 Then
Adapter.Update(MyDataset.Tables(0))
End If
Catch ex as Exception
RaiseEvent MyErrorEvent(ex) '<<< here
Finally
End Try
The code is raising a SqlClient.SqlException:
{"Syntax error converting the varchar value 'Test' to a column of data
type int."}
Since there are multiple integer-type columns in the table, it would be
very helpful to know which of them is the one involved in the
SqlException. === Is it possible to determine that in the debugger? ===
I think the exception may be spurious, for when I look at things in the
Immediate Window, it all looks OK:
?adapter.InsertCommand.Parameters("@addr1").Value
"Test" {String}
String: "Test"
The correct column is being updated with the value 'Test'. I don't see
any parameters with incorrect SourceColumn mappings, and "addr1" the
source column for parameter("@addr1") is not used more than once in the
code where the parameters are instantiated. And in the stored procedure,
the insert(column-list) values(param-list) has correct column-parameter
match up.
Thanks
TR
Try
....
MyDataset.Tables(0).DefaultView.RowStateFilter = DataViewRowState.Added
If MyDataset.Tables(0).DefaultView.Count > 0 Then
Adapter.Update(MyDataset.Tables(0))
End If
Catch ex as Exception
RaiseEvent MyErrorEvent(ex) '<<< here
Finally
End Try
The code is raising a SqlClient.SqlException:
{"Syntax error converting the varchar value 'Test' to a column of data
type int."}
Since there are multiple integer-type columns in the table, it would be
very helpful to know which of them is the one involved in the
SqlException. === Is it possible to determine that in the debugger? ===
I think the exception may be spurious, for when I look at things in the
Immediate Window, it all looks OK:
?adapter.InsertCommand.Parameters("@addr1").Value
"Test" {String}
String: "Test"
The correct column is being updated with the value 'Test'. I don't see
any parameters with incorrect SourceColumn mappings, and "addr1" the
source column for parameter("@addr1") is not used more than once in the
code where the parameters are instantiated. And in the stored procedure,
the insert(column-list) values(param-list) has correct column-parameter
match up.
Thanks
TR