Prev: SQL: Spelling out numbers to words for month
Next: varbinary(max) field in sql server 2005 problems
From: Erland Sommarskog on 13 Mar 2010 13:36
sirrahhc via SQLMonster.com (u58702(a)uwe) writes:
> Hey guys, I guess I need to correct myself. The trigger is working, but
> only on the back end. When I change the field in the LegalAssistant
> table it does indeed update the MSUHearing1 table, but only on the back
> end. When I pull up the app and look it is not updating on the
> frontend. Weird....I will continue to play with and let you guys know
> what I find, thanks!!

If you want the trigger to update you see on the client, you will need
to do quite some work. The easiest is surely to requery.

Keep in mind that your client and SQL Server are disjunct processes,
communicating over a TCP/IP connection, and there is no way SQL Server
can update the client's memory space over that connection.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

First  |  Prev  | 
Pages: 1 2
Prev: SQL: Spelling out numbers to words for month
Next: varbinary(max) field in sql server 2005 problems