Remarque
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de vous connecter ou de modifier des répertoires.
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de modifier des répertoires.
Provides a location for all of the computed notification field definitions for one notification class.
Syntaxe
<NotificationClasses>
<NotificationClass>
...
<Schema>
...
<ComputedFields>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type |
None. |
Default value |
None. |
Occurrence |
Optional once per /NotificationClass/Schema node. |
Updates |
Can be added and deleted when updating the application. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
Notes
If you add or delete the ComputedFields element, SQL Server deletes and recreates the corresponding notification class when you update the application. This includes dropping and re-creating the SQL Server tables used by this notification class.
.gif "ms146600.note(fr-fr,SQL.90).gif") Remarque : |
|---|
| Make sure to back up your application database before updating the application. |
Exemple
The following example shows a populated ComputedFields node. The computed fields, MaxChange and AvgChange, show the maximum growth and the average growth of the stocks in a chronicle table.
<ComputedFields>
<ComputedField>
<FieldName>StockPrice</FieldName>
<SqlExpression>CONVERT(NVARCHAR(10), StockPrice, 1)
</SqlExpression>
</ComputedField>
</ComputedFields>
Voir aussi
Référence
Application Definition File Reference
Autres ressources
Définition du schéma de notification
Mise à jour des instances et des applications