The SalTableWindow type exposes the following members.

Methods

  NameDescription
Public methodAnyRows
Determines whether any rows in the specified table window match certain flags. If you set flagsOn to zero (0) and flagsOff to zero (0), SalTblAnyRows returns TRUE if the table window contains any rows at all, regardless of their flags.
Public methodAutoSizeCols
Autosizes the specified column.
Public methodBringWindowToTop
Brings a window to the top of all overlapping windows.
Protected methodCanEditCell
Returns true if the specific cell can be edited.
(Inherited from SalTableWindowBase.)
Protected methodCanMoveCell
Returns true if the current cell can be changed.
(Inherited from SalTableWindowBase.)
Public methodCenterWindow
Centers a window. If the window is a top-level window, it centers it on the desktop. If the window is a child window, it centers it on top of its parent.
Public methodClearCursor
Clears a window's cursor.
Protected methodClearSelectedColumns
Unselects all selected columns.
(Inherited from SalTableWindowBase.)
Protected methodClearSelectedRows
Unselects all selected rows from both grids.
(Inherited from SalTableWindowBase.)
Public methodClearSelection
Deselects all rows of a table window.
Protected methodClearUnusedStyles
Frees unused styles.
(Inherited from SalTableWindowBase.)
Public methodColumnAverage
Computes the average of all column values or only specified column values in a table window.
Public methodColumnSum
Computes the sum of all column values or only specified column values in a table window.
Public methodCopyRows
Copies the contents of the specified table window rows to the Clipboard in text format. In the Clipboard, columns are delimited by TAB characters and rows are delimited by end-of-line characters. Set flagsOn to zero (0) and flagsOff to zero (0) to copy the entire table.
Public methodCreateColumn(SalNumber, SalNumber, SalNumber, SalString)
Creates a table window column of string data type at runtime. When you return to design mode, destroys the column.
Public methodCreateColumn(SalNumber, SalNumber, SalNumber, SalString, DataType)
Creates a table window column of string data type at runtime. When you return to design mode, destroys the column.
Public methodCreateColumnEx
Creates a table window column using a given data type at runtime. Allowed types are DT_String, DT_Number and DT_DateTime
Protected methodCreateHandle (Inherited from SalTableWindowBase.)
Protected methodCreateSplitGrid
Creates the splitter and split grid, syncronizes the columns and attaches all the events necessary to manager the split grid.
(Inherited from SalTableWindowBase.)
Public methodDefineRowHeader
Defines the appearance and behavior of a table window's row header. The row header is a non-editable area on the left edge of a table window that displays information that stays displayed even when a user scrolls horizontally. A typical use of a row header is the display of row numbers.
Public methodDefineSplitWindow
Splits a table window horizontally.
Public methodDeleteRow
Deletes a row from a table window but not from the database.
Public methodDeleteSelected(SalSqlHandle)
Applies a SQL DELETE statement to all table window rows with the ROW Selected flag.
Public methodDeleteSelected(SalSqlHandle, WhenSqlErrorHandler)
Applies a SQL DELETE statement to all table window rows with the ROW Selected flag.
Public methodDestroyColumns
Destroys all automatic columns created by SalTblCreateColumn or SalTblPopulate at runtime. This function only works on table windows that contain only automatic columns.
Protected methodDestroySplitGrid
Destroyes the split grid and the splitter control.
(Inherited from SalTableWindowBase.)
Public methodDestroyWindow
Destroys a form window, a top-level table window, or a modeless dialog box created with SalCreateWindow.
Public methodDisableWindow
Disables keyboard and mouse input to a window. If the window contains text (for example, a push button), the text is grayed. If the window is a data field, it cannot receive the focus.
Public methodDisableWindowAndLabel
Disables keyboard and mouse input to a window and grays out its associated label. A label is the label control that immediately precedes the window in the outline. The label control must have a mnemonic. If the window contains text (for example, a push button), the text is grayed. If the window is a data field, it cannot receive the focus.
Protected methodDispose (Inherited from SalTableWindowBase.)
Public methodDoDeletes(SalSqlHandle, SalNumber)
Applies a SQL DELETE statement to all table window rows that have nFlagsOn flags.
Public methodDoDeletes(SalSqlHandle, Int32, WhenSqlErrorHandler)
Applies a SQL DELETE statement to all table window rows that have nFlagsOn flags.
Public methodDoInserts(SalSqlHandle, SalBoolean)
Applies a SQL INSERT statement to all the rows in a table window that have the ROW_New flag.
Public methodDoInserts(SalSqlHandle, SalBoolean, WhenSqlErrorHandler)
Applies a SQL INSERT statement to all the rows in a table window that have the ROW_New flag.
Public methodDoUpdates(SalSqlHandle, SalBoolean)
Applies a SQL UPDATE statement to all table window rows with the Row_Edited flag.
Public methodDoUpdates(SalSqlHandle, SalBoolean, WhenSqlErrorHandler)
Applies a SQL UPDATE statement to all table window rows with the Row_Edited flag.
Public methodEnableWindow
Enables keyboard and mouse input to a window.
Public methodEnableWindowAndLabel
Enables keyboard and mouse input to a window and enables its associated label as well. A label is the label control that immediately precedes the window in the outline.
Public methodFetchRow
Sends a SAM_FetchRow message to a table window if the specified row has not been already fetched.
Public methodFindChild
This function finds a child window of a given name in the specified window.
Public methodFindNextRow
Scans forward in a table looking for a row whose flags match those specified.
Public methodFindPrevRow
Scans backward in a table looking for a row whose flags match those specified.
Protected methodFinishEditing (Inherited from SalTableWindowBase.)
Public methodFormUnitsToPixels
Computes the number of pixels in the number of form units. Form units are a unit of measurement used by functions which move and position objects. Form units are computed using physical units (pixels) in conjunction with the window's font size.
Public methodStatic memberFromControl
Casts the control to SalTableWindow. If the control is an instance of SalFormTableWindow, returns the inner table control.
Public methodGetCellStyle
Returns the CellStyle object for the specified cell.
(Inherited from SalTableWindowBase.)
Public methodGetCellStyleNew
Returns or creates the CellStyle object for the specified cell. The CellStyle is guaranteed not to be one of the cached CellStyle instances.
(Inherited from SalTableWindowBase.)
Public methodGetClassName
Return the name of a window's class as a string.
Public methodGetColHeaderStyle
Returns the CellStyle object for the fixed cells in the specified column.
(Inherited from SalTableWindowBase.)
Public methodGetColHeaderStyleNew
Returns or creates the CellStyle object for the fixed cells in the specified column.
(Inherited from SalTableWindowBase.)
Protected methodGetCols
Returns the column collection from the grid. This is a safe call and throws an exception if the grid has been disposed. Otherwide the grid throws a generic NullReferenceException.
(Inherited from SalTableWindowBase.)
Public methodGetColStyle
Returns the CellStyle object for the specified column.
(Inherited from SalTableWindowBase.)
Public methodGetColStyleNew
Returns or creates the CellStyle object for the specified column.
(Inherited from SalTableWindowBase.)
Public methodGetColumnFromId
Gets the table window column control with the specified id.
Public methodGetColumnFromPos
Gets the table window column control at the specified position.
Public methodGetColumnText(SalNumber)
Gets data from a column of a table window's context row.
Public methodGetColumnText(SalNumber, SalString%)
Gets data from a column of a table window's context row.
Public methodGetColumnWindow
Gets the handle of a table window column.
Public methodGetContextRow
Returns a table window's current context row. Before sending a SAM_FetchRow message, automatically sets the context row so that assignments made while processing the message reference the correct row.
Protected methodGetContextRowFromCode
Translates row codes (TBL_MinRow, TBL_MaxRow, etc) to a valid context row.
(Inherited from SalTableWindowBase.)
Public methodGetControlType
Returns an object's type.
Public methodGetFirstChild
Returns the handle of the first child window of the specified type. You can use this function to get the handles of MDI child windows.
Public methodGetFont
Gets a window's font name, size, and enhancements.
Public methodGetLabelText(SalNumber)
Retrieves the text of the label associated to a control. Important: The label control does not require a mnemonic for the functions listed above to operate.
Public methodGetLabelText(SalString%, SalNumber)
Retrieves the text of the label associated to a control. Important: The label control does not require a mnemonic for the functions listed above to operate.
Public methodGetLinesPerRow()()()()
Retrieves the height of a row in lines.
Public methodGetLinesPerRow(SalNumber%)
Retrieves the height of a row in lines.
Public methodGetLocation
Returns a window's current position on the X and Y axes.
Public methodGetLockedColumns
Retrieves the number of locked table window columns. Locked table window columns do not scroll horizontally; they are fixed to the left side of the table window. All other columns appear to scroll under the locked columns.
Public methodGetName()()()()
Gets the name of an object.
Public methodGetName(SalString%)
Gets the name of an object.
Public methodGetNextChild
Returns the handle of the next child window that matches a specified type.
Public methodGetNextColumn
Returns the next column in the columns collection in order of ID.
Public methodGetParent
Returns the handle of an object's parent window.
Public methodGetProperty(SalString)
Gets the value of a named property.
Public methodGetProperty(SalString, SalString%)
Gets the value of a named property.
Public methodGetRowFlags
Queries a row's flags.
Public methodGetRowHeaderStyle
Returns the CellStyle for the fixed cells for the specified row.
(Inherited from SalTableWindowBase.)
Public methodGetRowHeaderStyleNew
Returns or creates the CellStyle for the fixed cells for the specified row.
(Inherited from SalTableWindowBase.)
Protected methodGetRows
Returns the row collection from the grid. This is a safe call and throws an exception if the grid has been disposed. Otherwide the grid throws a generic NullReferenceException.
(Inherited from SalTableWindowBase.)
Public methodGetRowStyle
Returns the CellStyle object for the specified row.
(Inherited from SalTableWindowBase.)
Public methodGetRowStyleNew
Returns or creates the CellStyle object for the specified row.
(Inherited from SalTableWindowBase.)
Public methodGetSize
Returns a window's size.
Public methodGetTableFlags
Tests the state of a table window's flags.
Public methodGetText(SalNumber)
Retrieves the text of a window.
Public methodGetText(SalString%, SalNumber)
Retrieves the text of a window.
Public methodGetWindowColor
Gets a window's color.
Public methodGetWindowState
Returns a window's current state.
Public methodHideWindow
Hides a window.
Public methodHideWindowAndLabel
Hides a window and its associated label.
Public methodHitTest
Returns the part of the table window located at a given coordinate.
Public methodInsertRow
Inserts a new blank row into a table window.
Public methodInvalidateWindow
Causes a window to be repainted.
Public methodIsDerivedFromClass
Determines whether a window is an instance of the specified class.
Public methodIsEnabled
Determines whether a window is enabled for mouse and keyboard input.
Protected methodIsOnColumnMoveArea
Returns true if the hittest result is on the column header area used to move the column.
(Inherited from SalTableWindowBase.)
Protected methodIsValidCol
Returns true if the col is valid in the current grid.
(Inherited from SalTableWindowBase.)
Protected methodIsValidContextRow
Returns true if the context row is a valid row.
(Inherited from SalTableWindowBase.)
Protected methodIsValidRow
Returns true if the row is valid in the current grid.
(Inherited from SalTableWindowBase.)
Public methodIsVisible
Determines whether a window is currently visible.
Public methodKillCellEdit
Ends edit mode in the current cell.
Public methodKillFocusRow
Turns off the table window's focus frame.
Public methodKillTimer
Destroys an object's system timer.
Public methodMoveWindow
Moves a window a given number of form units on the X and Y axes relative to its current position.
Protected methodOnAfterDragColumn (Inherited from SalTableWindowBase.)
Protected methodOnAfterEdit (Inherited from SalTableWindowBase.)
Protected methodOnAfterResizeColumn (Inherited from SalTableWindowBase.)
Protected methodOnAfterResizeRow (Inherited from SalTableWindowBase.)
Protected methodOnAfterRowColChange
Sends SAM_RowSetContext, SAM_SetFocus and SAM_Click when the current row or column is changed.
(Overrides SalTableWindowBase..::..OnAfterRowColChange(C1FlexGrid, RangeEventArgs).)
Protected methodOnAfterScroll
Fetches the rows in the visible range when the main grid is scrolled.
(Overrides SalTableWindowBase..::..OnAfterScroll(C1FlexGrid, RangeEventArgs).)
Protected methodOnBackColorChanged (Inherited from SalTableWindowBase.)
Protected methodOnBeforeMouseDown
Process OnMouseDown before it reaches the inner grid to: - suppress toggling of check boxes on mouse down - select the entire row when clicking on row header - select the column when clicking on the column header - select multiple rows if control or shift is down - prevent moving the focus cell if not validated
(Inherited from SalTableWindowBase.)
Protected methodOnBeforeRowColChange
Sends SAM_KillFocus and SAM_RowValidate when the current cell is about to change.
(Overrides SalTableWindowBase..::..OnBeforeRowColChange(C1FlexGrid, RangeEventArgs).)
Protected methodOnBeforeSort (Inherited from SalTableWindowBase.)
Protected methodOnButtonClick
Generates SAM_Click when the edit button is clicked. This is not CTD standard, it's an extension for CellType.Button.
(Overrides SalTableWindowBase..::..OnButtonClick(C1FlexGrid, RowColEventArgs).)
Protected methodOnCausesValidationChanged (Inherited from SalTableWindowBase.)
Protected methodOnChangeEdit
Generates SAM_AnyEdit when editing a cell.
(Overrides SalTableWindowBase..::..OnChangeEdit(C1FlexGrid, EventArgs).)
Protected methodOnChildEditWndProc
Receives all windows messages from the cell editor control before they are processed by the control's WndProc. Returns true to indicate that the message has been handled and the control's WndProc should not process it.
(Overrides SalTableWindowBase..::..OnChildEditWndProc(NativeWindow, Control, Message%).)
Protected methodOnChildGridWndProc
Receives all the Windows messages from the inner flexgrid control before they are processed by the grids WndProc. All the messages are dispatched to the MessageActions handler. This function returns true if the message is processed and should not be dispatched to the default window procedure.
(Overrides SalTableWindowBase..::..OnChildGridWndProc(NativeWindow, C1FlexGrid, Message%).)
Protected methodOnComboCloseUp (Inherited from SalTableWindowBase.)
Protected methodOnComboDropDown (Inherited from SalTableWindowBase.)
Protected methodOnControlAdded (Inherited from SalTableWindowBase.)
Protected methodOnControlRemoved (Inherited from SalTableWindowBase.)
Protected methodOnDrawCell
Implements custom drawing features that are not available in the standard flexgrid component
(Overrides SalTableWindowBase..::..OnDrawCell(C1FlexGrid, OwnerDrawCellEventArgs).)
Protected methodOnEnabledChanged (Inherited from SalTableWindowBase.)
Protected methodOnEnter (Inherited from SalTableWindowBase.)
Protected methodOnEnterCell (Inherited from SalTableWindowBase.)
Protected methodOnFontChanged
Adjusts the rows height if LinesPerRow > 1.
(Overrides SalTableWindowBase..::..OnFontChanged(EventArgs).)
Protected methodOnForeColorChanged (Inherited from SalTableWindowBase.)
Protected methodOnGotFocus (Overrides SalTableWindowBase..::..OnGotFocus(C1FlexGrid, IntPtr).)
Protected methodOnHandleCreated (Inherited from SalTableWindowBase.)
Protected methodOnKeyDownEdit (Inherited from SalTableWindowBase.)
Protected methodOnKeyPressEdit (Inherited from SalTableWindowBase.)
Protected methodOnKeyUpEdit (Inherited from SalTableWindowBase.)
Protected methodOnLeaveCell (Inherited from SalTableWindowBase.)
Protected methodOnLeaveEdit
Prevents the user from leaving the cell by pressing Esc if it contains an invalid value.
(Overrides SalTableWindowBase..::..OnLeaveEdit(C1FlexGrid, RowColEventArgs).)
Protected methodOnLoad (Inherited from SalTableWindowBase.)
Protected methodOnLostFocus (Overrides SalTableWindowBase..::..OnLostFocus(C1FlexGrid, IntPtr).)
Protected methodOnMouseDown
Sends : SAM_Click SAM_DoubleClick SAM_CaptionDoubleClick SAM_ColumnSelectClick SAM_CornerClick SAM_CornerDoubleClick SAM_RowHeaderClick SAM_RowHeaderDoubleClick
(Overrides SalTableWindowBase..::..OnMouseDown(C1FlexGrid, MouseEventArgs).)
Protected methodOnMouseMove
Show the column-move cursor when the mouse moves close to the bottom edge of the column header
(Inherited from SalTableWindowBase.)
Protected methodOnMouseUp
Toggle CheckBox columns on mouse up, like in CTD.
(Inherited from SalTableWindowBase.)
Protected methodOnParentEnabledChanged (Inherited from SalTableWindowBase.)
Protected methodOnResize(EventArgs) (Inherited from SalTableWindowBase.)
Protected methodOnResize(C1FlexGrid, EventArgs)
Fetches the rows in the visible range when the table control is resized.
(Overrides SalTableWindowBase..::..OnResize(C1FlexGrid, EventArgs).)
Protected methodOnRowChangeValidate
Validates the row by generating the SAM_RowValidate event on the table control.
(Overrides SalTableWindowBase..::..OnRowChangeValidate(C1FlexGrid, RangeEventArgs).)
Protected methodOnSetupEditor (Inherited from SalTableWindowBase.)
Protected methodOnStartEdit (Inherited from SalTableWindowBase.)
Protected methodOnValidateEdit
Validates the current column.
(Overrides SalTableWindowBase..::..OnValidateEdit(C1FlexGrid, ValidateEditEventArgs).)
Protected methodOnValidating
Don't validate the TableWindow control if the current cell is not validated.
Public methodPasteRows
Pastes the contents of the Clipboard to the specified table window. Assumes the Clipboard data is in text format with cells delimited by tab characters and rows delimited by end-of-line characters. Inserts the new rows into the table window without overwriting existing rows, and converts the data to the data types of the corresponding table window columns.
Public methodPixelsToFormUnits
Computes the number of form units based on the number of pixels. Form units are a unit of measurement used by functions that move and position objects. Form units are computed using physical units (pixels) in conjunction with a window's font sizes.
Public methodPopulate(SalSqlHandle, SalString, SalNumber)
Populates the table window with the result of the select.
Public methodPopulate(SalSqlHandle, SalString, SalNumber, WhenSqlErrorHandler)
Populates the table window with the result of the select.
Public methodPostMessage
Posts the specified message to a window by adding nMsg to hWndReceiver's message queue.
Protected methodProcessCmdKey (Overrides SalTableWindowBase..::..ProcessCmdKey(Message%, Keys).)
Public methodQueryFocusCell
Identifies the cell in a table window with the focus.
Public methodQueryRowHeader
Gets a table window's row header definition. The row header is a non-editable area on the left edge of a table window that displays information that you do not want to scroll off the screen as the user scrolls horizontally. A typical use is the display of row numbers.
Public methodQueryScroll
Returns a table window's current scroll position and range. The scroll position is the row number of the row that is currently at the top of the window. You set the table window range with SalTblSetRange and changes it when you insert or delete rows from the table window.
Public methodQuerySplitWindow
Returns the current configuration of the split table.
Public methodQueryVisibleRange
Returns the current range of visible rows in a table window.
Public methodResetTable
Clears a table window by discarding all rows from the table window cache and setting the table range to 0, -1.
Public methodScrollRow(SalNumber, Control)
Scrolls a table window to the specified row and column.
Public methodScrollRow(SalNumber, Control, SalNumber)
Scrolls a table window to the specified row and column.
Protected methodSelectFullRow
Highlights the entire row.
(Inherited from SalTableWindowBase.)
Public methodSendMessage
Sends the specified message to a window. SalSendMsg does not return until the processing for the message is complete.
Public methodSendMessageToChildren
Sends a message to all child items of a form window, dialog box, table window, or MDI window.
Public methodSetColumnText
Assigns data to a column of a table window's context row.
Public methodSetContextMenu(Type, SalNumber)
Defines a named popup menu that displays automatically when a window receives SAM_ContextMenu.
Public methodSetContextMenu(SalString, SalNumber)
Defines a named popup menu that displays automatically when a window receives SAM_ContextMenu.
Protected methodSetContextRow(Int32)
Sets the table window's context row.
(Inherited from SalTableWindowBase.)
Public methodSetContextRow(SalNumber)
Sets a table window's context row. Setting the context row does not send a SAM_FetchRow message. If the row is not currently in memory, creates a new row in memory and sets its cell values to null.
Public methodSetCursor(Int32, SalNumber)
Sets a window's cursor.
Public methodSetCursor(SalResourceCursor, SalNumber)
Sets a window's cursor.
Public methodSetCursor(SalString, SalNumber)
Sets a window's cursor from a string variable.
Public methodSetCursorFile
Sets an application-defined cursor for the specified window. Use this function to set the cursor from an image stored in a file.
Public methodSetFlagsAnyRows
Sets or clears row flags.
Public methodSetFocus
Sets the focus to a specified window.
Public methodSetFocusCell
Sets the focus to the specified table window cell (row and column). Puts the table window into edit mode and lets the user select a portion of the data in the cell.
Protected methodSetFocusCellStyle
Alters the look of the focused cell. When the cell is not editable it is shown with a solid border.
(Inherited from SalTableWindowBase.)
Public methodSetFocusRow
Sets a table window's focus frame row.
Public methodSetFont
Sets a window's font, font size, and font enhancements.
Public methodSetLabelText
Sets the text of the associaetd label control.
Public methodSetLinesPerRow
Sets the height of a row in lines.
Public methodSetLocation
Moves a window to a new position (x, y) on the X and Y axes.
Public methodSetLockedColumns
Sets the number of locked columns.
Public methodSetProperty
Sets the value of a named property.
Public methodSetRange
Defines the minimum and maximum rows (range) of a table.
Public methodSetRow
Sets the focus to the first, last, next, or previous row in a table window.
Public methodSetRowFlags
Sets or clears a table window row's flags.
Public methodSetSize
Resizes a window.
Public methodSetTableFlags
Sets or clears a table window's flags.
Public methodSetText
Sets the text of a window.
Public methodSetTimer
Creates a system timer for a given object. When a timer event occurs, sends SAM_Timer messages to the object in specified intervals. Timers are a limited global resource. Your application must check the value returned by SalTimerSet to verify that the timer was created.
Public methodSetWindowColor
Sets a window's color.
Protected methodSetVisibleCore (Overrides Control..::..SetVisibleCore(Boolean).)
Public methodShowWindow
Makes a window visible.
Public methodShowWindowAndLabel
Makes a window and its associated label visible. A label is the label control that immediately precedes the window in the outline.
Public methodSortRows
Sorts the rows of a table window based on the values in one of the table window's columns.
Protected methodTestRowFlags
Returns true if the row flags match the on|off masks.
(Inherited from SalTableWindowBase.)
Protected methodTestRowHeaderFlags
Returns true if the specified row header flags are all set.
(Inherited from SalTableWindowBase.)
Protected methodTestTableFlags
Returns true if the specified table flags are all set.
(Inherited from SalTableWindowBase.)
Public methodTrackPopupMenu(Type, SalNumber, SalNumber, SalNumber)
Creates pop-up menus at runtime.
Public methodTrackPopupMenu(SalString, SalNumber, SalNumber, SalNumber)
Creates pop-up menus at runtime.
Public methodTranslateRowContext
Translates the context row number to a row index and grid control.
(Inherited from SalTableWindowBase.)
Protected methodUpdateRowsHeight
Updates the height all the rows.
(Inherited from SalTableWindowBase.)
Public methodUpdateWindow
Forces the update of a window.
Public methodWinHelp
Starts the Windows help system.
Protected methodWndProc
Redirect Windows message to the implementation object.
(Overrides UserControl..::..WndProc(Message%).)
Public methodYield
Processes messages for this control.

See Also