Not without seeing the code for MyInsertMethod, my guess would be you have defined a parameter on SQLCommand with a size too small to handle one of the strings you are attempting to put into it.
On 6/24/05, Bob Filipiak <[EMAIL PROTECTED]> wrote: > I'm reading selected records from one table in a database into a dataset and > then trying to insert the records into a different table in the database > using: > > For Each dRow2 in ds.Tables(0).Rows > ret = MyInsertMethod(Trim(dRow2.Item(1)), Trim(dRow2.Item(2)), > Trim(dRow2.Item(3)), CDate(dRow2.Item(4)), CDate(dRow2.Item(5)), > dRow2.Item(6), Trim((dRow2.Item(7)))) > response.write(ret & "Record added") > Next > > I'm getting: System.Data.SqlClient.SqlException: String or binary data would > be truncated. The statement has been terminated. > > Here is the Function: > Function MyInsertMethod(ByVal networkEng As String, ByVal task As String, > ByVal actionType As String, ByVal startDate As Date, ByVal endDate As Date, > ByVal hrs As Single, ByVal probComment As String) As Integer > > Any ideas? > > [Non-text portions of this message have been removed] > > > > > Yahoo! Groups Links > > > > > > > -- Dean Fiala Very Practical Software, Inc http://www.vpsw.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
