Path: csiph.com!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Michael Cole Newsgroups: microsoft.public.sqlserver.programming Subject: Re: Create function: Could not find type xxx in assembly yyyy (msg Date: Thu, 13 Oct 2016 09:06:15 +1100 Organization: A noiseless patient Spider Lines: 44 Message-ID: References: <71FD2003-4B18-47D2-A11F-69CEECC48D3C@microsoft.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15"; format=flowed Content-Transfer-Encoding: 8bit Injection-Date: Wed, 12 Oct 2016 22:07:08 -0000 (UTC) Injection-Info: mx02.eternal-september.org; posting-host="80372c7931c94477728607fa146b6dca"; logging-data="6735"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18r4BCORJUUFoP0jbuT0+Dp" X-Newsreader: MesNews/1.08.06.00-gb Cancel-Lock: sha1:056okmg9aQlLqALwdfhHwBihlJk= X-ICQ: 1701145376 Xref: csiph.com microsoft.public.sqlserver.programming:31303 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