Multiple tables (OpenInsight Specific) [Revelation On-Line Wiki]

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

At 28 JUN 1998 09:23:49PM Richard Richter wrote:

OpenInsight Specific

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

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

Richard,

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

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

View this thread on the forum...