Results 1 to 4 of 4

Thread: Success

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Success

    oK if anyone remembers the problems with my Update/termination Trigger I found it works best if I do it as a Stored procedure instead of a trigger. Thanks again for your help guys. I really appreciate it

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Thats great...but it doesn't make much sense....

    Also, realize...that ANY changes must be made through the sproc.

    Any changes outside and you're data will be messed up for your process....

    May I suggest though, that you should change your data model.

    Physically moving data because of a status change (unless the volume is huge) is not a good design.


    Well, that's My Own Opinion...MOO
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Moo2.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    HI Brettt

    thank you Brett for advice I think I'll take it especially since I'm still in the learning process and you guys are the experts. I can have a update query instead. the only thing is my users are not familar with databases at all.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •