|
Group: StrataFrame Users
Posts: 50,
Visits: 163
|
That worked. Now my next issue: The DT package creates tables, views and also a UDF that 1 of the views refer to. The view and the UDF work perfect in SQL so there is no issue with Syntax of the View or UDF as far as SQL is concerned. But when I use the DT to dun the package I get an error when the View is being created:
Creating failed for view, Sql Exception: funcConvertVersionNumber is not recognized as a built in function name.
I played around with changing the "priority" of the UDF to be less than and also greater than the priority on the view with no luck.
Here is the view:
SELECT vc_int_codeid, vc_vcr_version, vc_dte_entry_date, vc_bit_mandatory, vc_vcr_ftp, funcConvertVersionNumber(vc_vcr_version) as VersionNumberValue FROM dbo.tblVersionControl
Here is the UDF as it appears in the dt:
(@VersionString varchar(30))
RETURNS decimal(20,3)
AS
BEGIN
DECLARE @strVersionReversed varchar(30) -- holds reversed version number
DECLARE @strVersionNumWhole varchar(30) -- holds whole number of converted version number
DECLARE @strVersionNumDec varchar(20) -- holds decimal number of converted version number
DECLARE @decVersionConverted decimal(20,3) -- holds converted version number
-- reverse the version string
SET @strVersionReversed = REVERSE(@VersionString)
-- Separate the revision number from the major, minor, and build number
SET @strVersionNumWhole = SUBSTRING(@strVersionReversed, CHARINDEX('.', @strVersionReversed) + 1, 30)
SET @strVersionNumDec = SUBSTRING(@strVersionReversed, 1, CHARINDEX('.', @strVersionReversed))
SET @strVersionNumWhole = REPLACE(REVERSE(@strVersionNumWhole), '.', '') -- reverse to proper order AND remove decimals
SET @strVersionNumDec = REVERSE(@strVersionNumDec) -- reverse to proper order
SET @decVersionConverted = CAST(@strVersionNumWhole + @strVersionNumDec as decimal(20,3)) -- build decimal value of version number
RETURN(@decVersionConverted) -- return the number value
END
Why is this erroring?
|