Hi, I have problems to create code fpr my custom procedures
The procedure is very simple an follows the naming convention of .nettiers
The table is called app_translations and this is the procedure
CREATE PROCEDURE _app_translations_ListColumnNames
(
@table NVARCHAR(50),
@language NVARCHAR(5) = 'EN'
)
AS
IF EXISTS(SELECT 1 FROM sysobjects WHERE name= @table)
BEGIN
DECLARE @SQL_STMT VARCHAR(8000)
DECLARE @name varchar(255)
IF (@language <> '')
BEGIN
-- select @table
SET @name = 'a.ANAME_'+@language
-- SET @SQL_STMT = 'SELECT a.ANAME, "'+@name+'" = (CASE WHEN ' + @name + ' IS NULL THEN a.ANAME_EN ELSE ' + @name + ' END), ATYPE FROM attributes a, entities e
SET @SQL_STMT = 'SELECT a.ANAME, ALIAS = (CASE WHEN ' + @name + ' IS NULL THEN a.ANAME_EN ELSE ' + @name + ' END), ATYPE FROM attributes a, entities e
WHERE e.t_id = a.t_id
AND e.dbtname like ''' + @table + ''''
-- print @sql_stmt
EXEC(@SQL_STMT)
END
END
I am working with the templates .netTiers 2.0.0.0 beta 2
This are the relevant properties
<property name="IncludeCustoms">True</property>
<property name="CustomNonMatchingReturnType">DataSet</property>
<property name="CustomProcedureStartsWith">_{0}_</property>
<property name="ProcedurePrefix" />
I have done a lot of trials but I never found the generated code in the file
SqlApp_translationsProviderBase.generated.cs
#region Custom Methods
#endregion
where i supposed to find the generated code;
the section above was empty
Now I have no idea what to do and request help
best reagards Michael