Groups > microsoft.public.sqlserver.programming > #31303

Re: Create function: Could not find type xxx in assembly yyyy (msg

From	Michael Cole <invalid@invalid.com>
Newsgroups	microsoft.public.sqlserver.programming
Subject	Re: Create function: Could not find type xxx in assembly yyyy (msg
Date	2016-10-13 09:06 +1100
Organization	A noiseless patient Spider
Message-ID	<ntmc6b$6if$1@dont-email.me> (permalink)
References	<AB84A7E2-4598-455F-826C-095B7C9488D7@microsoft.com> <Xns9CD99E44284B8Yazorman@127.0.0.1> <71FD2003-4B18-47D2-A11F-69CEECC48D3C@microsoft.com> <ebb47c7e-3497-4d5b-866c-12576bab0382@googlegroups.com>

Show all headers | View raw

swetha.mandanapu@gmail.com submitted this idea :
> On Sunday, December 6, 2009 at 10:16:01 AM UTC-6, Frans wrote:
>> Hi Erland,
>> 
>> the error message (My.SQLserver) is from another try.
>> 
>> This is the create function statement now:
>> CREATE FUNCTION fnGetLastStepcompleted
>> (
>> 	@DossierID int
>> )
>> RETURNS INT 
>> 
>> AS EXTERNAL NAME [UDF_CLR].[UserDefinedFunctions].GetLastStepCompleted
>> GO
>> 
>> Message: Could not find Type 'UserDefinedFunctions' in assembly 'UDF_CLR'.
>> 
>> 
>> The Visual Studio 2008 package:
>> 
>> Public Class UserDefinedFunctions
>>      Public Shared Function GetLastStepCompleted(ByVal DossierID As Integer) 
>> As SqlString
>>         Dim svc As New NotaflowClientService.ClientService
>>         Dim D As New NotaflowClientService.Dossier
>>         D = svc.GetDossier(DossierID, True)
>>         Return (D.LastStepCompleted.ToString)
>>     End Function
>> 
>> End Class
>> 
>> I debug and the UDF_CLR Assemblie is created.
>> 
>> It looks like syntax to me, but maybe it's something else.
>> Help is appreciated.
>
> I have the same issue. funtion built from Visualstudio 2008. Did you find a 
> resolution to the issue?

You are replying to a 17 year old message.

-- 
Michael Cole

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: Create function: Could not find type xxx in assembly yyyy (msg swetha.mandanapu@gmail.com - 2016-10-12 07:50 -0700
  Re: Create function: Could not find type xxx in assembly yyyy (msg Michael Cole <invalid@invalid.com> - 2016-10-13 09:06 +1100
    Re: Create function: Could not find type xxx in assembly yyyy (msg Erland Sommarskog <esquel@sommarskog.se> - 2016-10-13 13:42 +0000
      Re: Create function: Could not find type xxx in assembly yyyy (msg Michael Cole <invalid@invalid.com> - 2016-10-14 09:36 +1100

csiph-web