Database Edit Table; which column (OpenInsight Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[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]]


==== Database Edit Table; which column (OpenInsight Specific) ====
=== At 13 SEP 1999 03:55:47PM Jim Jones wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
How can I determine, programmically, which column( and value) has focus within a 'database edit table' control?

 I would also like to be able to set the 'TEXT' property for a specific column (and value) in  a  'database edit table' control  with my program.  



I've tried several approaches and seem to be at a deadend. Any suggestions  would be appreciated.



Thanks,

J.J.




</QUOTE>
----

=== At 13 SEP 1999 05:05PM CT Savell wrote:  ===

<QUOTE>I think you are looking for the POSCHANGED event which delivers NextRow and NextColumn whenever the position of the edit table cell with focus changes.

</QUOTE>

----

=== At 13 SEP 1999 05:28PM Stephen S. Revelation wrote:  ===

<QUOTE>Jim,



CT Savell is correct is referring to the POSCHANGED event to retrieve the next cell position to receive focus.  Alternatively, to get the current(with focus) position at anytime, use the SELPOS property.  As far as setting text to a particular cell in an edit table, I'd recommend using the CELLPOS property to set the TEXT property.



Good Luck,



Stephen Revelation

</QUOTE>

----

=== At 13 SEP 1999 07:39PM Richard Hunt wrote:  ===

<QUOTE>Your question...



How can I determine, programmically, which column( and value) has  focus within a 'database edit table' control?



answer...



POSITION=GET_PROPERTY(CTRLENTID,'SELPOS')

COLUMN=POSITION

ROW=POSITION



----------

question...



I would also like to be able to set the 'TEXT' property for a specific column (and value) in a 'database edit table' control with my program.



answer...



POSITION=COLUMN:@FM:ROW

OLD_POSITION=SET_PROPERTY(CTRLENTID,'ACCESSPOS',POSITION)

OLD_TEXT=SET_PROPERTY(CTRLENTID,'ACCESSDATA',TEXT)



I hope this helps. Edit tables are very tricky. and are interesting too.

</QUOTE>


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