I'm not quite sure of what you mean, because you are missign some explanation.
Therefore, I assume you want to update the original table with a value from the
table open in the modal form.
I would do this:
In the modal form:
init event
thisform.addproperty('oRecord')
suppose you show a grid and you want to select a complete record from the table
that is the recordsource of this grid. You would have a method in your form
with this code:
(your cursor is placed on the grid line you want to select)
scatter name thisform.oRecord
The above code places the whole record into the object property you created.
In the unload event of this form, you simply return the oRecord object to the
calling form:
return thisform.oRecord
Now, in the first form, you would have this code, presumably in a click event
of a button:
local oRecord
do form secondmodalform to oRecord
select thetableyouwanttoupdate
locate for ( whatever record you want to update)
gather from name oRecord
In the above manner you are returning a full record from a modal form and can
use it to update your table. On the other hand, assuming you wanted to get only
a few fields from the record you just brought back, you could select them
directly from the oRecord object, thus:
gather from name oRecord fields account,custname,custaddress
Hope it helps
Rafael Copquin
----- Original Message -----
From: Eurico Chagas Filho
To: [EMAIL PROTECTED]
Sent: Monday, June 11, 2007 8:17 AM
Subject: How to update a table ?
Hi
I have this table in the form's environment, than I open another form,
modal, with a private datasession. When I get back I would like to
update the table, what's the best way ?
Thanks, E.
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.11/838 - Release Date: 6/7/2007
2:21 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.
