Func in SQL Sever does not appear in designer

Posts   
 
    
shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 06-Jun-2012 11:10:24   

LLBLGEN 3.5 SQL Server 2005 C# Windows Application LLBLGEN Runtime Frame work .NET framework 4.0

I created the following func on sql server

CREATE FUNCTION fncurrentdate
()
RETURNS varchar(30)
AS
BEGIN
declare @return varchar(30)
select @return =convert(varchar, getdate(), 22)
return @return
end

But when I refresh in LLBLGEN, this func does not appear in catalog designer. Any reason? since I need to use the func in LLBLGEN generated code

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39910
Joined: 17-Aug-2003
# Posted on: 06-Jun-2012 11:58:45   

Functions aren't imported, only stored procedures.

Frans Bouma | Lead developer LLBLGen Pro
shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 06-Jun-2012 12:05:37   

Otis wrote:

Functions aren't imported, only stored procedures.

OK