microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: NotificationBatchId

Subject: Re: NotificationBatchId
From: "SVA"
Date: 30 Jun 2005 02:51:37 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Thank you Joe.

I have found a solution that is based on your idea #1.
The workaround is to create a dummy computed column so that it is
passed to the hashtable.

It looks as follows:
<NotificationClasses>
<NotificationClass>
<NotificationClassName>myClassName</NotificationClassName>
<Schema>
<ComputedFields>
  <ComputedField>
    <FieldName>nID</FieldName>
    <SqlExpression>
    N.NotificationId
    </SqlExpression>
  </ComputedField>
</ComputedFields>
...


The above sample applies to NotificationId column, but the same
approach can be used for the NotificationBatchId as well.

Perhaps NS team should consider adding an explicit support for the
NotificationID and NotificationBatchId fields in the FormatContent
method of the IContentFormatter interface.

Once again, thank you.

Regards, 
 Vladislav.


<Prev in Thread] Current Thread [Next in Thread>