Skip to main content

Using tsf_user() in a default value expression

Harm Horstman
Superhero
Forum|alt.badge.img+21

Using dbo.tsf_user() in a default value expression gives errors during execution of the source code. 

 

 

 

 

Cannot DROP FUNCTION 'tsf_user' because it is being referenced by object 'DF_prd_insert_user'.

/* Drop function tsf_user first. */

if exists (select 1 from sysobjects
           where name = 'tsf_user' and (type = 'FN' or type = 'TF' or type = 'IF'))
   drop function tsf_user

 

Any workaround ideas?

Logic will get you from A to B. Imagination will take you everywhere (Albert Einstein)
K.Bakkenes
1 person likes this
  • K.Bakkenes
    K.Bakkenes
Did this topic help you find an answer to your question?
This topic has been closed for replies.

2 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi Harm,

As workaround you could do only Smart upgrades and no Full upgrades as Full upgrades will try and drop all functions. This is a bit tricky so I suggest creating a TCP ticket for this so we can make sure the use of tsf_user() inside default value expressions will go smoothly.

"Wake me up before you low-code" | On holiday 06-02 till 27-06
Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi Harm, 

I just tried this and it still does not result in a successful execution when chosen for a Full upgrade. That is because, during a full upgrade, the tsf_user function gets dropped and recreated. We would still like a TCP ticket for this so we can keep you updated about the resolution of this issue.

 

Edit: in Platform version 2023.1, this functionality has changed which ensures that the tsf_user function can be used.

"Wake me up before you low-code" | On holiday 06-02 till 27-06
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings