In that case, and following the example in my previous post, you could do the 
following:

In the second form, which you said has a private data session, you could use 
optimistic table buffering, thus:

load event

cursorsetprop('buffering',5,'thetabletobeupdated')

in the save event

tableupdate(1,.t.,'thetabletobeupdated')

then, in the calling form:

do form secondmodalform 

and you should refresh the grid (if you used one to do your lookup) or the 
combo (if it is a small table)

thisform.grid1.refresh  

or 

thisform.combo1.requery()

Rafael Copquin

  ----- Original Message ----- 
  From: Eurico Chagas Filho 
  To: [EMAIL PROTECTED] 
  Sent: Monday, June 11, 2007 9:40 AM
  Subject: How to update a table ?


  Hi

  Sorry, my bad. The table, table1, resides in the form's environment and
  is not updated, it's just for lookup. But, in another form table1 is
  updated and I need to access the fresh data in table1. The only way
  is to issue an USE than USE AGAIN or what ?

  TIA, E.

  No virus found in this outgoing message.
  Checked by AVG Free Edition. 
  Version: 7.5.472 / Virus Database: 269.8.13/843 - Release Date: 6/10/2007
  1:39 PM
   



[excessive quoting removed by server]

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to