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


==== Edit Table Problem (OpenInsight 32-bit Specific) ====
=== At 17 JUN 2003 07:09:36AM Dave Berkovsky wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>


I have an Edittable that consists of several database bound columns and one symbolic that is calculated based on three other columns in editable. I am trying to remove blank row in LOSTFOCUS event.



Function LostFocus(CtrlEntId,CtrlClassId,Flag,FocusId)

  success=ETMethod (CtrlEntId, "TRIM", "", "")

  Forward_Event()

RETURN 0



If I insert blank row and tab out from edittable once everything

seems to work fine. Empty row is removed, but if I do it twice, what is happening is empty row is removed but calculated column is not

shifting up with the rest. Does anyone have any an idea what am I doing wrong?



TIA

Dave



Dave
</QUOTE>
----

=== At 17 JUN 2003 08:54AM Richard Richter wrote:  ===

<QUOTE>Dave,



It's my experience that at least one of the columns is never null. Therefore, if I read through that column and get a null property, I delete the line using the delete statment for each column. 



So, I read the non-null (is that a word? column and count the value marks + 1. I then do a for next and if the column data is null use the delete command to delete the row completely. 



It works for me all the time. I hope this helps.



Richard Richter

</QUOTE>


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