[[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]]


==== Multiple tables (OpenInsight Specific) ====
=== At 28 JUN 1998 09:23:49PM Richard Richter wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
I am trying to read a column of data in one DBTABLE from another DBTABlE that has focusin OIS 3.6.



From within DBTABLE_7 I want to get a column of data from ad dbtable called "PATIENT_EMP_INS". I set the cursor (I tried both SELPOS and ACCESSPOS), and then I try to read the column of data with DATACOL. The result is null when I know there's data there. The following are the two lines of code:



v=Set_Property(CtrlEntID1,"F.":".PATIENT_EMP_INS","SELPOS",10:@FM:1)

PatPS=Get_Property(CtrlEntID1,"F.":".PATIENT_EMP_INS","DATACOL")



Any ideas what I'm doing wrong?



Thanks,

Richard
</QUOTE>
----

=== At 29 JUN 1998 07:33AM Cameron Revelation wrote:  ===

<QUOTE>Richard,



[i]v=Set_Property(CtrlEntID1,"F.":".PATIENT_EMP_INS","SELPOS",10:@FM:1)

PatPS=Get_Property(CtrlEntID1,"F.":".PATIENT_EMP_INS","DATACOL")[/i]



You are using "DATACOL" when the property name is "COLDATA".



It is easier to use:



ColData=Send_Message(Ctrl, "TEXT_BY_POS", ColNum, 0)



This method does not change the edit table selection.  Search in the help file for TEXT_BY_POS.



Cameron Purdy

Revelation Software

</QUOTE>


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