HI,
I have been trying to fix a problem which is due to incompatibility between a customized report New contribution and ft_get_address sql function. This function has changed in v12 and has a new parameter @allow_multiple_contact_points. I have changed the report setup to accomodate the new parameter: List Filter Acts Upon
But still I am getting error related to ft_get_address:
An insufficient number of arguments were supplied for the procedure or function ft_get_address
Does anyone where can we see this function is being called from and fix the problem.
Regards,
Renu.
Unknown said: But still I am getting error related to ft_get_address: An insufficient number of arguments were supplied for the procedure or function ft_get_address
I'm very familiar with that error as I've been working on getting all of our reports v12-compatible. Under v11, this syntax was correct for that function, e.g.:
outer apply [FT_GET_ADDRESS] (GETDATE(), null, null, o.customer_no) b
Hi Chris,
Thanks for your help. I did the same thing before I saw this message. This was the fix(Adding fifth parameter in ft_get_address) and it works fine now.
If I would have seen this before I would have saved a lot of time. But neverthelless thank you so much and I will reach out to this forum next time I need help.