Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Kick Start My Brain
Message
De
18/02/2011 11:54:31
 
 
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Divers
Thread ID:
01500443
Message ID:
01500736
Vues:
44
>>>>>Hi again Naomi,
>>>>>
>>>>>how do I use this function in a computed field now? I've added the field to the table and put GetDatePaidTo(PolicyHeaderPK) as the formula but it tells me "Error validating the formula for the column" when I try to save the table definition.
>>>>
>>>>
>>>>Looks like I need to enter it like this:
>>>>
>>>>([dbo].[GetDatePaidTo]([PolicyHeaderPK]))
>>>
>>>Yes, for functions you always need to specify the schema.
>>
>>It was more than just the schema, the brackets/parentheses are apparently also necessary
>
>I don't think so. You can type without brackets, SSMS designer will convert to brackets by itself.

OK, I must have done something else wrong then. Thanks again.
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform