Partager via


SPList.ValidationFormula - Propriété

Gets or sets a formula that is evaluated each time that a list item is added or updated.

Espace de noms :  Microsoft.SharePoint
Assembly :  Microsoft.SharePoint (dans Microsoft.SharePoint.dll)

Syntaxe

'Déclaration
Public Property ValidationFormula As String
    Get
    Set
'Utilisation
Dim instance As SPList
Dim value As String

value = instance.ValidationFormula

instance.ValidationFormula = value
public string ValidationFormula { get; set; }

Valeur de propriété

Type : System.String
The formula that will be used to evaluate data in the item. The rules for constructing a formula are similar to those for creating formulas for calculated fields. For more information, see Calculated Field Formulas.

Exceptions

Exception Condition
ArgumentException

The string is too long. The maximum length of a validation formula string is 1024.

Remarques

Each time that a list item is added or updated, the validation formula is evaluated. If the formula evaluates to false, or if a calculation error occurs, the update is not permitted and the message in the ValidationMessage property is displayed.

Keep in mind that each field in a list item has a ValidationFormula property of its own. The difference is that the validation formula for a field can refer only to that field, whereas the validation formula for a list item can refer to several or even all fields in the item.

Notes

Formula validation is independent of the type of validation controlled by the EnforceDataValidation property.

Voir aussi

Référence

SPList classe

SPList - Membres

Microsoft.SharePoint - Espace de noms

ValidationMessage

ValidationFormula

EnforceDataValidation