SQL Server administration and T-SQL development, Web Programming with ASP.NET and Javascript, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software

Kodyaz Development Resources

Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Vista, etc.

Re: Function signature of "FillRow" method (as designated by SqlFunctionAttribute.FillRowMethodName) does not match SQL declaration for table valued CLR function'CLRSplitString' due to column 1.

  •  09-01-2010, 8:47 AM

    Re: Function signature of "FillRow" method (as designated by SqlFunctionAttribute.FillRowMethodName) does not match SQL declaration for table valued CLR function'CLRSplitString' due to column 1.

    OK, I found a solution.

    Here is the definition of FillRow method, which I defined in the FillRowMethodName attribute of table valued CLR function CLRSplitString.
    By the way, the columns are numbered by a zero based index method.
    So "due to column 1" refers to second parameter which is InputString.
    When I changed the ByVal to ByRef, I could successfully create the table valued CLR function (CLR sql split function) on MS SQL Server 2008 R2 database server.

    Public Shared Sub FillRow(ByVal row As Object, ByRef InputString As String)


    Eralper
    Kodyaz.com
View Complete Thread
Copyright © 2004 - 2011 Eralper Yilmaz. All rights reserved.
Community Server, by Telligent Systems