CodeSmith Community
Your Code. Your Way. Faster!

How to implement SQL Query Notification in Nettiers

Latest post 10-31-2007 10:45 AM by mathisr. 5 replies.
  • 10-24-2007 10:51 AM

    • mathisr
    • Top 150 Contributor
    • Joined on 03-05-2006
    • Posts 32
    • Points 490

    How to implement SQL Query Notification in Nettiers

    Does anybody have any input or insight on grafting SQL Query Notification Technology onto NetTiers?

    I suppose the requirements would be;

    Event notification to TList or VList objects!

    And only need to check the TimeStamp field not all fields?

     

    secret
    Filed under:
    • Post Points: 35
  • 10-31-2007 9:00 AM In reply to

    • donig
    • Top 100 Contributor
    • Joined on 02-16-2004
    • Virginia, USA
    • Posts 41
    • Points 1,230

    Re: How to implement SQL Query Notification in Nettiers

    Are you trying to write your Nofification rules using NetTiers objects?

    You can write custom code to use within SSNS. I've done this for custom formatters. Still not sure what you are asking, though...

    ------------------------------------------------- Member of the .NetTiers team -------------------------------------------------
    • Post Points: 60
  • 10-31-2007 10:16 AM In reply to

    • mathisr
    • Top 150 Contributor
    • Joined on 03-05-2006
    • Posts 32
    • Points 490

    Re: How to implement SQL Query Notification in Nettiers

    Thanks for reply,

    Yup I'm trying implement SQL Notificiation Query with NetTires;

    Something similar to this webpage: http://9tutorials.com/2007/05/10/implementing-sql-server-2005-query-notifications-in-c-windows-application.html

    But I'm uncertain of the best approach ? Any idea?

    Thanx

    secret
    • Post Points: 5
  • 10-31-2007 10:22 AM In reply to

    • mathisr
    • Top 150 Contributor
    • Joined on 03-05-2006
    • Posts 32
    • Points 490

    Re: How to implement SQL Query Notification in Nettiers

    Just in case I was not very clear.

    I would like a simple notification of when a table becomes modified so I can refresh entities in memory.

    For example say I have an employee TList<Employee> and the user has multiple forms open employee information.

    So if another user changes any employee information at the server all applications would be notified and could make
    the appropriate steps to refresh. Normally I maintain a single TList<> for data in the app so I would only need to update
    the NetTiers entities in the list, then any forms needing refreshing would be hooked to the TList's Date Changed event.

    Am I crazy or would this work?

    secret
    • Post Points: 35
  • 10-31-2007 10:41 AM In reply to

    • donig
    • Top 100 Contributor
    • Joined on 02-16-2004
    • Virginia, USA
    • Posts 41
    • Points 1,230

    Re: How to implement SQL Query Notification in Nettiers

    Actually, I interpreted that as wanting to use SSNS, not the query notification feature...never mind. Embarrassed

    ------------------------------------------------- Member of the .NetTiers team -------------------------------------------------
    • Post Points: 35
  • 10-31-2007 10:45 AM In reply to

    • mathisr
    • Top 150 Contributor
    • Joined on 03-05-2006
    • Posts 32
    • Points 490

    Re: How to implement SQL Query Notification in Nettiers

    Ok, thanks for considering helping though!

    Anybody else?

    secret
    • Post Points: 5
Page 1 of 1 (6 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems