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

Re: SubscriberDevice.ID ???

Subject: Re: SubscriberDevice.ID ???
From: tarpan
Date: Wed, 11 May 2005 11:26:06 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Thank you for the help.

"Shyam Pather [MSFT]" wrote:

> I posted a reply to this yesterday, but for some reason it hasn't shown up
> in the newsgroup. I'll try to restate my reply here:
> 
> [SubscriberId, DeviceName] is the unique key for subscriber devices. In the
> NS design, there is no seperable "friendly name" built into the subscriber
> device records. In general, NS tries to stay away from storing
> presentation-level data because every application has different requirements
> for this type of data and it is very difficult to design a generic solution.
> You can always store "presentation names" yourself in a separate table and
> refer to the NS subscriber device records by [SubscriberId, DeviceName].
> 
> If you don't want to explicitly store the friendly name yourself, you can
> also achieve the same thing by creating a new NS subscriber device with the
> new name, copying over the other properties from the old device, and then
> deleting the old device.
> 
> -shyam
> 
> -- 
> Learn more about SQL-NS:
> http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/
> ---------------------------------------------
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm.
> ---------------------------------------------
> "tarpan" <[email protected]> wrote in message
> news:[email protected]
> > %-)
> > ID is not intended to be used by applications???
> > If I use Name as an ID that field I have to use as a Name?
> >
> > DB basics (extremly simplified):
> > - Every entity has to has ID and Name.
> > - ID is a unique key used inside the application for address the enity
> > - Name is some enity parameter presentable for a user
> >
> > I can "identify devices by name". But what field I have to present to the
> > user? Let say user has added device with name "email". Next day the user
> has
> > dicided to rename "email" to "E-mail". Apperantly, it is not possible,
> > because Name field IS the ID and ID can not be changed. What to do?
> >
> >
> >
> >
> > "Shyam Pather [MSFT]" wrote:
> >
> > > The ID is an internally used indentifier, not intended to be used by
> > > applications. Your application should identify devices by name. For a
> given
> > > subscriber, all devices must have a unique name. So, the pair
> [SubscriberID,
> > > DeviceName] is always unique.
> > > Hope this helps.
> > > -shyam
> > >
> > > -- 
> > > Learn more about SQL-NS:
> > > http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/
> > > ---------------------------------------------
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > Use of included script samples are subject to the terms specified at
> > > http://www.microsoft.com/info/cpyright.htm.
> > > ---------------------------------------------
> > > "tarpan" <[email protected]> wrote in message
> > > news:[email protected]
> > > > Hello,
> > > >
> > > > SubscriberDevice does not have the ID field ! How you guys identify
> the
> > > > device?
> > > > Name is read only field (once entered it can not be changed).
> > >
> > >
> > >
> 
> 
> 

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