• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Strange issue for database update?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Strange issue for database update?


  • Subject: Re: Strange issue for database update?
  • From: Jonathan Rochkind <email@hidden>
  • Date: Mon, 12 Apr 2004 11:06:29 -0500

Sure----if the database, through a trigger, changes a column---how would WO/EOF possibly know about this change? It can't possibly know about it until the next time it fetches from the database. Just the way EOF works.

This is essesntially the same problem as if another process (rather than the db itself through a trigger) had made a modification, and your app didn't see it, because your app had not had a reason to refetch that row. See:

http://wodev.spearway.com/cgi-bin/WebObjects/WODev.woa/wa/Main?wikiPage=GettingFreshDataFromDatabase

At 12:28 PM -0700 4/10/04, David Sue wrote:
After updating two fields of one record in Database,say field "a" and "b", "a" was updated by programming and "b" was updated by trigger,I refetch the record I can see "a" was updated but I can't see the update of "b",in fact "b" was updated also in database,does anybody have same issue ever?

Thanks!

David
Yahoo! Tax Center - File online by April 15th
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.


References: 
 >Strange issue for database update? (From: David Sue <email@hidden>)

  • Prev by Date: Re: Allows Concurrent Request Documentation
  • Next by Date: Re: Moving projects between machines
  • Previous by thread: Re: Strange issue for database update?
  • Next by thread: What class generates the sql?
  • Index(es):
    • Date
    • Thread