[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== How to send data from native table to edit table? (OpenInsight Specific) ====
=== At 11 JUN 1999 08:16:03AM Thuan and Keyvan wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
How to send data from native table to edit table?



We have read some of the previous articles on this forum about how to send data to edit tables instead of popup table 

but there are no concrete examples. 

We have tried the following codes without success. 

The datafields in the native table(addressbook) in our example are not multivalue. 

Please heeeeeeeeeeeeeeeeeeeelp! Thanks





        $Insert Logical

     Done=FALSE$

     Open "addressbook" To address_table Then

	      Select address_table

	         Loop

	      ReadNext ID Then

	      

	     	     

         displaydata=READ_ROW(addressbook, ID, 0)

         

         rt=send_message(edittable,INSERT,1,displaydata)



             End Else Done=TRUE$

     

           Until Done Repeat

 


</QUOTE>
----

=== At 11 JUN 1999 11:15AM Terry Evans wrote:  ===

<QUOTE>If the edittable is empty why not load an array with the data then the control.



$Insert Logical

Done=FALSE$

Open "addressbook" To address_table Then

Select address_table

array='

Loop

ReadNext ID Then



displaydata=READ_ROW(addressbook, ID, 0)

array=displaydata; * appends data to array

*-array=insert(array, 1, 0, 0, displaydata); * prepends data

*-rt=send_message(edittable,INSERT,1,displaydata)



End Else Done=TRUE$



Until Done Repeat

Set_Property(edittable, 'ARRAY', array)

</QUOTE>

----

=== At 23 JUN 1999 02:37PM Cameron Revelation wrote:  ===

<QUOTE>Thuan and Keyvan,



In most cases, this is done automatically by binding the edit table to fields of a record.  If the data that you want to display is only going to come from one record at a time from a particular table, you do not have to do any coding to make this work.  See the "Database Association" portion of the Edit Table properties.



Cameron Purdy

Revelation Software

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=7D6F710CE9610E638525678D0043635E|View this thread on the  forum...]]