Toad World® Forums

sql server table valued function DDL not reverse engineered successfully


#1

Hi,

TDM has not been able to successfully model/reverse engineer/compare my sql server table valued functions.

For example the relevant DDL for one function is:

CREATE function [xxx].[ParseStringParamToDateRange] (@stringIn VARCHAR(1000))
returns @dateTable TABLE(
STRINGIN NVARCHAR(MAX)
, RangeTypeDesc varchar(100)
,DateVal DATE
)
AS

blah,blah,blah…

However, TDM reverse engineers the following:

CREATE function [xxx].[ParseStringParamToDateRange] (@stringIn VARCHAR(1000))
RETURNS
AS

That’s it! The reverse engineering loses the definition of the return table, so of course the sql in the model is invalid.

Am I doing something wrong in TDM? If I am not doing anything wrong, is there a workaround aside from manually copying and pasting the ddl into a model?

Thanks,

Ken


#2

Hi Ken,

it’s our bug - TDM-322. It’s already been fixed for the next TDM version 5.2.

Thanks a lot!

Please check your private messages section. Thanks.

Regards, Vladka + TDM Team