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

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

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
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	Thu, 13 Oct 2016 09:06:15 +1100
Organization	A noiseless patient Spider
Lines	44
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>
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

Show key headers only | 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