View source for Child tables

{{PageHeader|Child Table, Grid & Column}}


__TOC__


<!------------------------------------------------------------------------------------------------------------------------------>
{{TipHeader|What message is send when a DropDown column item is selected (clicked)}}
When an item from a column dropdown list is selected, the message SAM_AnyEdit is send to the column message actions section.<br>
<br>

<!------------------------------------------------------------------------------------------------------------------------------>
{{TipHeader|How to hide the window displayed in the taskbar when a column dropdown list is opened}}
When you open the dropdown list of a table column, a window is shown on the Windows taskbar.<br>
To get rid of this window use this code under the message actions of the table column<br>
<br>
First declare these three WinApi functions in the external functions section
<pre>
Library name: USER32.DLL
   Function: FindWindowA
      Export Ordinal: 0
      Returns
         Window Handle: HWND
      Parameters
         String: LPCSTR
         String: LPCSTR

   Function: GetWindowLongA
      Export Ordinal: 0
      Returns
         Number: LONG
      Parameters
         Window Handle: HWND
         Number: INT

   Function: SetWindowLongA
      Export Ordinal: 0
      Returns
         Number: LONG
      Parameters
         Window Handle: HWND
         Number: INT
         Number: LONG
</pre>
<br>
Also declare these constants
<pre>
   Number: GWL_EXSTYLE      = -20
   Number: WS_EX_TOOLWINDOW = 0x80
</pre>
<br>
Here the actual code for removing the window from the taskbar
<pre>
On SAM_DropDown
   Set hWndDropDown = FindWindowA( "Gupta:DropDown", "" )
   If NOT hWndDropDown
      ! Maybe it is an older TD version, so search for another classname
      Set hWndDropDown = FindWindowA( ":DropDown", "" )
   If hWndDropDown
      If NOT GetWindowLongA( hWndDropDown,GWL_EXSTYLE ) & WS_EX_TOOLWINDOW
         Call SetWindowLongA( hWndDropDown, GWL_EXSTYLE, GetWindowLongA( hWndDropDown,GWL_EXSTYLE ) | WS_EX_TOOLWINDOW )
</pre>

Here you can download a sample:<br>
{{Download
|URL=http://samples.tdcommunity.net/index.php?dir=&file=WIKI_DropDownColumn_NoWindowInTaskbar.zip
|TEXT=WIKI_DropDownColumn_NoWindowInTaskbar.zip
}}
<br>


<!------------------------------------------------------------------------------------------------------------------------------>

{{TipHeader|Double Height column headers}}
It wasn't obvious to me that this could be done but the business analyst really wanted it for her screen design. A coworker remembered how she had done it once: Just embed a newline in the column title and Gupta handles it automgically. Works at design time, just embed ctrl/enter in the column's "Object Title" property, or at run time using SalTblSetColumnTitle()<br>
<br>
<pre>Call SalTblSetColumnTitle ( tblX.columnN, "Column header part 1 
		column header part 2" )</pre><br>
<br>

<!------------------------------------------------------------------------------------------------------------------------------>

{{TipHeader|How to set popup-edit columns to read-only or to disabled state}}
On columns having cell-type 'Popup edit' there are only two states available:<br>
*Editable Yes
*Editable No
<br>
When the column is editable, the text inside the popup edit box can be selected and changed.<br>
When the column is not editable, the popup edit box is not presented when clicking on a cell.<br>
<br>
So it is not possible to see the contents of a cell without allowing the user to change the text.<br>
<br>
The next solution adds two more options for Popup edit columns:<br>
*Readonly
*Disabled
<br>
The trick is to get the window handle of the popup edit box and use it to set it to read-only or disabled states.<br>
<br>
Declare these constants
<pre>
   Number: WM_USER              = 0x0400
   Number: SAM_GetExtEdit       = WM_USER + 119
   Number: EM_SETREADONLY       = 0x00CF
</pre>
<br>
The constant SAM_GetExtEdit is an internal undocumented message to get the edit part of popup edit columns.<br>
<br>
The next piece of code shows how to get the window handle of the edit box and set it to read-only or disabled.<br>
Here is a table called tblTest which contains a column col1 having type 'Popup edit':
<pre>
   Set nPopup = SalSendMsg( tblTest, SAM_GetExtEdit, SalTblQueryColumnID( tblTest.col1 ) - 1, 0 )
   If nPopup > 0
      Set hWndPopUp = SalNumberToWindowHandle( nPopup )
      ! Set it to READ ONLY
      Call SalSendMsg( hWndPopUp, EM_SETREADONLY, TRUE, 0 )
      ! Or set it to disabled
      Call SalDisableWindow( hWndPopUp )
</pre>

Here you can download a sample:<br>
{{Download
|URL=http://samples.tdcommunity.net/index.php?dir=&file=WIKI_PopupEditColumn_ReadOnly.zip
|TEXT=WIKI_PopupEditColumn_ReadOnly.zip
}}




[[Category:Child Objects]]