The SalTableWindow type exposes the following members.
Methods
Name | Description | |
---|---|---|
AnyRows |
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.
| |
AutoSizeCols |
Autosizes the specified column.
| |
BringWindowToTop |
Brings a window to the top of all overlapping windows.
| |
CanEditCell |
Returns true if the specific cell can be edited.
(Inherited from SalTableWindowBase.) | |
CanMoveCell |
Returns true if the current cell can be changed.
(Inherited from SalTableWindowBase.) | |
CenterWindow |
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.
| |
ClearCursor |
Clears a window's cursor.
| |
ClearSelectedColumns |
Unselects all selected columns.
(Inherited from SalTableWindowBase.) | |
ClearSelectedRows |
Unselects all selected rows from both grids.
(Inherited from SalTableWindowBase.) | |
ClearSelection |
Deselects all rows of a table window.
| |
ClearUnusedStyles |
Frees unused styles.
(Inherited from SalTableWindowBase.) | |
ColumnAverage |
Computes the average of all column values or only specified column values in a table
window.
| |
ColumnSum |
Computes the sum of all column values or only specified column values in a table
window.
| |
CopyRows |
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.
| |
CreateColumn(SalNumber, SalNumber, SalNumber, SalString) |
Creates a table window column of string data type at runtime. When you return to
design mode, destroys the column.
| |
CreateColumn(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.
| |
CreateColumnEx |
Creates a table window column using a given data type at runtime.
Allowed types are DT_String, DT_Number and DT_DateTime
| |
CreateHandle | (Inherited from SalTableWindowBase.) | |
CreateSplitGrid |
Creates the splitter and split grid, syncronizes the columns
and attaches all the events necessary to manager the split grid.
(Inherited from SalTableWindowBase.) | |
DefineRowHeader |
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.
| |
DefineSplitWindow |
Splits a table window horizontally.
| |
DeleteRow |
Deletes a row from a table window but not from the database.
| |
DeleteSelected(SalSqlHandle) |
Applies a SQL DELETE statement to all table window rows with the ROW Selected flag.
| |
DeleteSelected(SalSqlHandle, WhenSqlErrorHandler) |
Applies a SQL DELETE statement to all table window rows with the ROW Selected flag.
| |
DestroyColumns |
Destroys all automatic columns created by SalTblCreateColumn or SalTblPopulate at
runtime. This function only works on table windows that contain only automatic
columns.
| |
DestroySplitGrid |
Destroyes the split grid and the splitter control.
(Inherited from SalTableWindowBase.) | |
DestroyWindow |
Destroys a form window, a top-level table window, or a modeless dialog box created
with SalCreateWindow.
| |
DisableWindow |
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.
| |
DisableWindowAndLabel |
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.
| |
Dispose | (Inherited from SalTableWindowBase.) | |
DoDeletes(SalSqlHandle, SalNumber) |
Applies a SQL DELETE statement to all table window rows that have nFlagsOn flags.
| |
DoDeletes(SalSqlHandle, Int32, WhenSqlErrorHandler) |
Applies a SQL DELETE statement to all table window rows that have nFlagsOn flags.
| |
DoInserts(SalSqlHandle, SalBoolean) |
Applies a SQL INSERT statement to all the rows in a table window that have the ROW_New flag.
| |
DoInserts(SalSqlHandle, SalBoolean, WhenSqlErrorHandler) |
Applies a SQL INSERT statement to all the rows in a table window that have the ROW_New flag.
| |
DoUpdates(SalSqlHandle, SalBoolean) |
Applies a SQL UPDATE statement to all table window rows with the Row_Edited flag.
| |
DoUpdates(SalSqlHandle, SalBoolean, WhenSqlErrorHandler) |
Applies a SQL UPDATE statement to all table window rows with the Row_Edited flag.
| |
EnableWindow |
Enables keyboard and mouse input to a window.
| |
EnableWindowAndLabel |
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.
| |
FetchRow |
Sends a SAM_FetchRow message to a table window if the specified row
has not been already fetched.
| |
FindChild |
This function finds a child window of a given name in the specified window.
| |
FindNextRow |
Scans forward in a table looking for a row whose flags match those specified.
| |
FindPrevRow |
Scans backward in a table looking for a row whose flags match those specified.
| |
FinishEditing | (Inherited from SalTableWindowBase.) | |
FormUnitsToPixels |
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.
| |
FromControl |
Casts the control to SalTableWindow. If the control
is an instance of SalFormTableWindow, returns the inner
table control.
| |
GetCellStyle |
Returns the CellStyle object for the specified cell.
(Inherited from SalTableWindowBase.) | |
GetCellStyleNew |
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.) | |
GetClassName |
Return the name of a window's class as a string.
| |
GetColHeaderStyle |
Returns the CellStyle object for the fixed cells in the specified column.
(Inherited from SalTableWindowBase.) | |
GetColHeaderStyleNew |
Returns or creates the CellStyle object for the fixed cells in the specified column.
(Inherited from SalTableWindowBase.) | |
GetCols |
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.) | |
GetColStyle |
Returns the CellStyle object for the specified column.
(Inherited from SalTableWindowBase.) | |
GetColStyleNew |
Returns or creates the CellStyle object for the specified column.
(Inherited from SalTableWindowBase.) | |
GetColumnFromId |
Gets the table window column control with the specified id.
| |
GetColumnFromPos |
Gets the table window column control at the specified position.
| |
GetColumnText(SalNumber) |
Gets data from a column of a table window's context row.
| |
GetColumnText(SalNumber, SalString%) |
Gets data from a column of a table window's context row.
| |
GetColumnWindow |
Gets the handle of a table window column.
| |
GetContextRow |
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.
| |
GetContextRowFromCode |
Translates row codes (TBL_MinRow, TBL_MaxRow, etc) to a valid context row.
(Inherited from SalTableWindowBase.) | |
GetControlType |
Returns an object's type.
| |
GetFirstChild |
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.
| |
GetFont |
Gets a window's font name, size, and enhancements.
| |
GetLabelText(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.
| |
GetLabelText(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.
| |
GetLinesPerRow()()()() |
Retrieves the height of a row in lines.
| |
GetLinesPerRow(SalNumber%) |
Retrieves the height of a row in lines.
| |
GetLocation |
Returns a window's current position on the X and Y axes.
| |
GetLockedColumns |
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.
| |
GetName()()()() |
Gets the name of an object.
| |
GetName(SalString%) |
Gets the name of an object.
| |
GetNextChild |
Returns the handle of the next child window that matches a specified type.
| |
GetNextColumn |
Returns the next column in the columns collection in order of ID.
| |
GetParent |
Returns the handle of an object's parent window.
| |
GetProperty(SalString) |
Gets the value of a named property.
| |
GetProperty(SalString, SalString%) |
Gets the value of a named property.
| |
GetRowFlags |
Queries a row's flags.
| |
GetRowHeaderStyle |
Returns the CellStyle for the fixed cells for the specified row.
(Inherited from SalTableWindowBase.) | |
GetRowHeaderStyleNew |
Returns or creates the CellStyle for the fixed cells for the specified row.
(Inherited from SalTableWindowBase.) | |
GetRows |
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.) | |
GetRowStyle |
Returns the CellStyle object for the specified row.
(Inherited from SalTableWindowBase.) | |
GetRowStyleNew |
Returns or creates the CellStyle object for the specified row.
(Inherited from SalTableWindowBase.) | |
GetSize |
Returns a window's size.
| |
GetTableFlags |
Tests the state of a table window's flags.
| |
GetText(SalNumber) |
Retrieves the text of a window.
| |
GetText(SalString%, SalNumber) |
Retrieves the text of a window.
| |
GetWindowColor |
Gets a window's color.
| |
GetWindowState |
Returns a window's current state.
| |
HideWindow |
Hides a window.
| |
HideWindowAndLabel |
Hides a window and its associated label.
| |
HitTest |
Returns the part of the table window located at a given coordinate.
| |
InsertRow |
Inserts a new blank row into a table window.
| |
InvalidateWindow |
Causes a window to be repainted.
| |
IsDerivedFromClass |
Determines whether a window is an instance of the specified class.
| |
IsEnabled |
Determines whether a window is enabled for mouse and keyboard input.
| |
IsOnColumnMoveArea |
Returns true if the hittest result is on the column header area used to move the column.
(Inherited from SalTableWindowBase.) | |
IsValidCol |
Returns true if the col is valid in the current grid.
(Inherited from SalTableWindowBase.) | |
IsValidContextRow |
Returns true if the context row is a valid row.
(Inherited from SalTableWindowBase.) | |
IsValidRow |
Returns true if the row is valid in the current grid.
(Inherited from SalTableWindowBase.) | |
IsVisible |
Determines whether a window is currently visible.
| |
KillCellEdit |
Ends edit mode in the current cell.
| |
KillFocusRow |
Turns off the table window's focus frame.
| |
KillTimer |
Destroys an object's system timer.
| |
MoveWindow |
Moves a window a given number of form units on the X and Y axes relative to its current
position.
| |
OnAfterDragColumn | (Inherited from SalTableWindowBase.) | |
OnAfterEdit | (Inherited from SalTableWindowBase.) | |
OnAfterResizeColumn | (Inherited from SalTableWindowBase.) | |
OnAfterResizeRow | (Inherited from SalTableWindowBase.) | |
OnAfterRowColChange |
Sends SAM_RowSetContext, SAM_SetFocus and SAM_Click
when the current row or column is changed.
(Overrides SalTableWindowBase..::..OnAfterRowColChange(C1FlexGrid, RangeEventArgs).) | |
OnAfterScroll |
Fetches the rows in the visible range when the main grid is scrolled.
(Overrides SalTableWindowBase..::..OnAfterScroll(C1FlexGrid, RangeEventArgs).) | |
OnBackColorChanged | (Inherited from SalTableWindowBase.) | |
OnBeforeMouseDown |
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.) | |
OnBeforeRowColChange |
Sends SAM_KillFocus and SAM_RowValidate when the current
cell is about to change.
(Overrides SalTableWindowBase..::..OnBeforeRowColChange(C1FlexGrid, RangeEventArgs).) | |
OnBeforeSort | (Inherited from SalTableWindowBase.) | |
OnButtonClick |
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).) | |
OnCausesValidationChanged | (Inherited from SalTableWindowBase.) | |
OnChangeEdit |
Generates SAM_AnyEdit when editing a cell.
(Overrides SalTableWindowBase..::..OnChangeEdit(C1FlexGrid, EventArgs).) | |
OnChildEditWndProc |
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%).) | |
OnChildGridWndProc |
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%).) | |
OnComboCloseUp | (Inherited from SalTableWindowBase.) | |
OnComboDropDown | (Inherited from SalTableWindowBase.) | |
OnControlAdded | (Inherited from SalTableWindowBase.) | |
OnControlRemoved | (Inherited from SalTableWindowBase.) | |
OnDrawCell |
Implements custom drawing features that are not available in the standard flexgrid component
(Overrides SalTableWindowBase..::..OnDrawCell(C1FlexGrid, OwnerDrawCellEventArgs).) | |
OnEnabledChanged | (Inherited from SalTableWindowBase.) | |
OnEnter | (Inherited from SalTableWindowBase.) | |
OnEnterCell | (Inherited from SalTableWindowBase.) | |
OnFontChanged |
Adjusts the rows height if LinesPerRow > 1.
(Overrides SalTableWindowBase..::..OnFontChanged(EventArgs).) | |
OnForeColorChanged | (Inherited from SalTableWindowBase.) | |
OnGotFocus | (Overrides SalTableWindowBase..::..OnGotFocus(C1FlexGrid, IntPtr).) | |
OnHandleCreated | (Inherited from SalTableWindowBase.) | |
OnKeyDownEdit | (Inherited from SalTableWindowBase.) | |
OnKeyPressEdit | (Inherited from SalTableWindowBase.) | |
OnKeyUpEdit | (Inherited from SalTableWindowBase.) | |
OnLeaveCell | (Inherited from SalTableWindowBase.) | |
OnLeaveEdit |
Prevents the user from leaving the cell by pressing Esc if it contains
an invalid value.
(Overrides SalTableWindowBase..::..OnLeaveEdit(C1FlexGrid, RowColEventArgs).) | |
OnLoad | (Inherited from SalTableWindowBase.) | |
OnLostFocus | (Overrides SalTableWindowBase..::..OnLostFocus(C1FlexGrid, IntPtr).) | |
OnMouseDown |
Sends :
SAM_Click
SAM_DoubleClick
SAM_CaptionDoubleClick
SAM_ColumnSelectClick
SAM_CornerClick
SAM_CornerDoubleClick
SAM_RowHeaderClick
SAM_RowHeaderDoubleClick
(Overrides SalTableWindowBase..::..OnMouseDown(C1FlexGrid, MouseEventArgs).) | |
OnMouseMove |
Show the column-move cursor when the mouse
moves close to the bottom edge of the column header
(Inherited from SalTableWindowBase.) | |
OnMouseUp |
Toggle CheckBox columns on mouse up, like in CTD.
(Inherited from SalTableWindowBase.) | |
OnParentEnabledChanged | (Inherited from SalTableWindowBase.) | |
OnResize(EventArgs) | (Inherited from SalTableWindowBase.) | |
OnResize(C1FlexGrid, EventArgs) |
Fetches the rows in the visible range when the table control is resized.
(Overrides SalTableWindowBase..::..OnResize(C1FlexGrid, EventArgs).) | |
OnRowChangeValidate |
Validates the row by generating the SAM_RowValidate event on the table control.
(Overrides SalTableWindowBase..::..OnRowChangeValidate(C1FlexGrid, RangeEventArgs).) | |
OnSetupEditor | (Inherited from SalTableWindowBase.) | |
OnStartEdit | (Inherited from SalTableWindowBase.) | |
OnValidateEdit |
Validates the current column.
(Overrides SalTableWindowBase..::..OnValidateEdit(C1FlexGrid, ValidateEditEventArgs).) | |
OnValidating |
Don't validate the TableWindow control if the current cell is not validated.
| |
PasteRows |
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.
| |
PixelsToFormUnits |
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.
| |
Populate(SalSqlHandle, SalString, SalNumber) |
Populates the table window with the result of the select.
| |
Populate(SalSqlHandle, SalString, SalNumber, WhenSqlErrorHandler) |
Populates the table window with the result of the select.
| |
PostMessage |
Posts the specified message to a window by adding nMsg to hWndReceiver's message
queue.
| |
ProcessCmdKey | (Overrides SalTableWindowBase..::..ProcessCmdKey(Message%, Keys).) | |
QueryFocusCell |
Identifies the cell in a table window with the focus.
| |
QueryRowHeader |
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.
| |
QueryScroll |
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.
| |
QuerySplitWindow |
Returns the current configuration of the split table.
| |
QueryVisibleRange |
Returns the current range of visible rows in a table window.
| |
ResetTable |
Clears a table window by discarding all rows from the table window cache and setting
the table range to 0, -1.
| |
ScrollRow(SalNumber, Control) |
Scrolls a table window to the specified row and column.
| |
ScrollRow(SalNumber, Control, SalNumber) |
Scrolls a table window to the specified row and column.
| |
SelectFullRow |
Highlights the entire row.
(Inherited from SalTableWindowBase.) | |
SendMessage |
Sends the specified message to a window. SalSendMsg does not return until the processing
for the message is complete.
| |
SendMessageToChildren |
Sends a message to all child items of a form window, dialog box, table window, or
MDI window.
| |
SetColumnText |
Assigns data to a column of a table window's context row.
| |
SetContextMenu(Type, SalNumber) |
Defines a named popup menu that displays automatically when a window receives SAM_ContextMenu.
| |
SetContextMenu(SalString, SalNumber) |
Defines a named popup menu that displays automatically when a window receives SAM_ContextMenu.
| |
SetContextRow(Int32) |
Sets the table window's context row.
(Inherited from SalTableWindowBase.) | |
SetContextRow(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.
| |
SetCursor(Int32, SalNumber) |
Sets a window's cursor.
| |
SetCursor(SalResourceCursor, SalNumber) |
Sets a window's cursor.
| |
SetCursor(SalString, SalNumber) |
Sets a window's cursor from a string variable.
| |
SetCursorFile |
Sets an application-defined cursor for the specified window. Use this function to
set the cursor from an image stored in a file.
| |
SetFlagsAnyRows |
Sets or clears row flags.
| |
SetFocus |
Sets the focus to a specified window.
| |
SetFocusCell |
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.
| |
SetFocusCellStyle |
Alters the look of the focused cell. When the cell is not editable
it is shown with a solid border.
(Inherited from SalTableWindowBase.) | |
SetFocusRow |
Sets a table window's focus frame row.
| |
SetFont |
Sets a window's font, font size, and font enhancements.
| |
SetLabelText |
Sets the text of the associaetd label control.
| |
SetLinesPerRow |
Sets the height of a row in lines.
| |
SetLocation |
Moves a window to a new position (x, y) on the X and Y axes.
| |
SetLockedColumns |
Sets the number of locked columns.
| |
SetProperty |
Sets the value of a named property.
| |
SetRange |
Defines the minimum and maximum rows (range) of a table.
| |
SetRow |
Sets the focus to the first, last, next, or previous row in a table window.
| |
SetRowFlags |
Sets or clears a table window row's flags.
| |
SetSize |
Resizes a window.
| |
SetTableFlags |
Sets or clears a table window's flags.
| |
SetText |
Sets the text of a window.
| |
SetTimer |
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.
| |
SetWindowColor |
Sets a window's color.
| |
SetVisibleCore | (Overrides Control..::..SetVisibleCore(Boolean).) | |
ShowWindow |
Makes a window visible.
| |
ShowWindowAndLabel |
Makes a window and its associated label visible. A label is the label control that
immediately precedes the window in the outline.
| |
SortRows |
Sorts the rows of a table window based on the values in one of the
table window's columns.
| |
TestRowFlags |
Returns true if the row flags match the on|off masks.
(Inherited from SalTableWindowBase.) | |
TestRowHeaderFlags |
Returns true if the specified row header flags are all set.
(Inherited from SalTableWindowBase.) | |
TestTableFlags |
Returns true if the specified table flags are all set.
(Inherited from SalTableWindowBase.) | |
TrackPopupMenu(Type, SalNumber, SalNumber, SalNumber) |
Creates pop-up menus at runtime.
| |
TrackPopupMenu(SalString, SalNumber, SalNumber, SalNumber) |
Creates pop-up menus at runtime.
| |
TranslateRowContext |
Translates the context row number to a row index and grid control.
(Inherited from SalTableWindowBase.) | |
UpdateRowsHeight |
Updates the height all the rows.
(Inherited from SalTableWindowBase.) | |
UpdateWindow |
Forces the update of a window.
| |
WinHelp |
Starts the Windows help system.
| |
WndProc |
Redirect Windows message to the implementation object.
(Overrides UserControl..::..WndProc(Message%).) | |
Yield |
Processes messages for this control.
|