SalFormTableWindow
PPJ.Runtime.Windows.SalFormTableWindow
Last updated
PPJ.Runtime.Windows.SalFormTableWindow
Last updated
Namespace: PPJ.Runtime.Windows
Assembly: PPJ.Runtime.49 (4.9.0.0)
Top level table window implementation.
Constructs a SalFormWindow object.
Boolean: Enables/Disables AutoEditing mode. When this mode is on, the grid automatically enters edit mode when a cell is selected. (Default: False)
Boolean: Enables/Disables the excel-style filtering feature. (Default: False)
Set the property UseNativeTypes to true to be able to use the type-specific filters, otherwise the filters operate on the displayed value. When using native types in conjunction with a non-standard format or an edit mask that cannot be parsed to a native value, it is possible to lose the edited value when it cannot be parsed.
Boolean: Allow row sizing. (Default: True)
Boolean: Enables/Disables automatic sorting on table columns. (Default: False)
SalTableColumnCollection: Returns the collection of columns.
Boolean: Enables/Disables the extension of the last column to fill the grid. (Default: False)
FocusRowStyle: Enables/Disables the focus frame around the current row. (Default: Thick)
Icon: Overrides the default Image property.
SalTableColumn: Returns the table column object with the specified column ID. The ID is 1-based.
SalTableColumn: Returns the table column object with the specified name.
Int32: Number of lines per row.
Boolean: Returns/Sets the ReadOnly flag. When the ReadOnly flag is true the entire TableWindow control cannot be edited. However, the Mouse, scrolling and the Keyboard are still active. (Default: False)
RowsSizingStyle: Keeps all rows of the same height. (Default: FreeSize)
Boolean: Gets or sets whether the grid should display labels over cells whose contents are partially hidden. (Default: False)
Boolean: Enables/Disables the arrow icon on the current row. (Default: False)
Boolean: Enables/Disables the focus frame around the current row. (Default: True)
SalTableWindow: Returns the internal table window control.
StringTrimming: Defines how to trim the content that doesn't fit the width of the cell. (Default: None)
Boolean: Returns or sets whether the grid tries to parse the edited value into the native type of the column. (Default: False)
When using native types in conjunction with a non-standard format or an edit mask that cannot be parsed to a native value, it is possible to lose the edited value when it cannot be parsed.
Boolean: Enables/Disabled drawing of columns and rows headers using the current visual style theme renderer. (Default: False)
Boolean: Enables or disables virtual mode. When virtual mode is on, the rows are fetched from the data source as they are scrolled into view. (Default: False)
Determines whether any rows in the specified table window match certain flags.
Returns: SalBoolean.
Deselects all rows of a table window.
Returns: SalBoolean.
Computes the average of all column values or only specified column values in a table window.
Returns: SalNumber.
Computes the sum of all column values or only specified column values in a table window.
Returns: SalNumber.
Copies the contents of the specified table window rows to the Clipboard in text format.
Returns: SalBoolean.
Creates a table window column of string data type at runtime.
Returns: SalNumber.
Creates a table window column using a given data type at runtime. Allowed types are DT_String, DT_Number and DT_DateTime
| Parameter | Type | Description |
|---|---|---|
columnPos | ||
dispWidth | ||
title | ||
maxChars | ||
datatype |
Returns: SalNumber.
Defines the appearance and behavior of a table window's row header.
Returns: SalBoolean.
Splits a table window horizontally.
| Parameter | Type | Description |
|---|---|---|
rowsLowerHalf | ||
dragAdjust |
Returns: SalBoolean.
Deletes a row from a table window but not from the database.
Returns: SalBoolean.
Applies a SQL DELETE statement to all table window rows with the ROW Selected flag.
| Parameter | Type | Description |
|---|---|---|
hSql |
Returns: SalBoolean.
Applies a SQL DELETE statement to all table window rows with the ROW Selected flag.
| Parameter | Type | Description |
|---|---|---|
hSql | ||
errorHandler |
Returns: SalBoolean.
Destroys all automatic columns created by SalTblCreateColumn or SalTblPopulate at runtime. This function only works on table windows that contain only automatic columns.
Returns: SalBoolean.
Applies a SQL DELETE statement to all table window rows that have nFlagsOn flags.
| Parameter | Type | Description |
|---|---|---|
hSql | ||
flagsOn |
Returns: SalBoolean.
Applies a SQL DELETE statement to all table window rows that have nFlagsOn flags.
| Parameter | Type | Description |
|---|---|---|
hSql | ||
flagsOn | ||
errorHandler |
Returns: SalBoolean.
Applies a SQL INSERT statement to all the rows in a table window that have the ROW New flag.
| Parameter | Type | Description |
|---|---|---|
hSql | ||
clearFlags |
Returns: SalBoolean.
Applies a SQL INSERT statement to all the rows in a table window that have the ROW New flag.
| Parameter | Type | Description |
|---|---|---|
hSql | ||
clearFlags | ||
errorHandler |
Returns: SalBoolean.
Applies a SQL UPDATE statement to all table window rows with the Row Edited flag.
| Parameter | Type | Description |
|---|---|---|
hSql | ||
clearFlags |
Returns: SalBoolean.
Applies a SQL UPDATE statement to all table window rows with the Row Edited flag.
| Parameter | Type | Description |
|---|---|---|
hSql | ||
clearFlags | ||
errorHandler |
Returns: SalBoolean.
Sends a SAM_FetchRow message to a table window if the row you specify is not currently in the table window cache.
| Parameter | Type | Description |
|---|---|---|
row |
Returns: SalNumber.
| Parameter | Type | Description |
|---|---|---|
row | ||
flagsOn | ||
flagsOff |
Returns: SalBoolean.
| Parameter | Type | Description |
|---|---|---|
row | ||
flagsOn | ||
flagsOff |
Returns: SalBoolean.
| Parameter | Type | Description |
|---|---|---|
columnID | ||
text |
Returns: SalBoolean.
Gets data from a column of a table window's context row.
| Parameter | Type | Description |
|---|---|---|
columnID |
Returns: SalString.
Gets the handle of a table window column.
Returns: SalWindowHandle.
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.
Returns: SalNumber.
| Parameter | Type | Description |
|---|---|---|
lines |
Returns: SalBoolean.
Retrieves the height of a row in lines.
Returns: SalNumber.
Retrieves the number of locked table window columns.
Returns: SalNumber.
Overrides GetMergedRange to allow the SalTableWindow class to override the method.
Returns: CellRange.
Queries a row's flags.
Returns: SalBoolean.
Tests the state of a table window's flags.
| Parameter | Type | Description |
|---|---|---|
flags |
Returns: SalBoolean.
| Parameter | Type | Description |
|---|---|---|
x | ||
y | ||
row | ||
col | ||
flags |
Returns: SalBoolean.
Inserts a new blank row into a table window.
| Parameter | Type | Description |
|---|---|---|
row |
Returns: SalNumber.
Takes a row out of edit mode and selects the row. This causes the row to receive both SAM_Validate and SAM_KillFocus messages.
Returns: SalBoolean.
Turns off the table window's focus frame.
Returns: SalBoolean.
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.
Returns: SalBoolean.
Compiles, binds, and executes a SQL SELECT statement, then fetches the rows of the result set and populates a table window with them.
| Parameter | Type | Description |
|---|---|---|
hSql | ||
select | ||
method |
Returns: SalBoolean.
Compiles, binds, and executes a SQL SELECT statement, then fetches the rows of the result set and populates a table window with them.
| Parameter | Type | Description |
|---|---|---|
hSql | ||
select | ||
method | ||
errorHandler |
Returns: SalBoolean.
Compiles, binds, and executes a SQL SELECT statement, then fetches the rows of the result set and populates a table window with them.
| Parameter | Type | Description |
|---|---|---|
hSql | ||
select |
Returns: SalBoolean.
Compiles, binds, and executes a SQL SELECT statement, then fetches the rows of the result set and populates a table window with them.
| Parameter | Type | Description |
|---|---|---|
hSql | ||
select | ||
errorHandler |
Returns: SalBoolean.
| Parameter | Type | Description |
|---|---|---|
row | ||
col |
Returns: SalBoolean.
| Parameter | Type | Description |
|---|---|---|
title | ||
maxTitle | ||
width | ||
flags | ||
col |
Returns: SalBoolean.
| Parameter | Type | Description |
|---|---|---|
position | ||
minRange | ||
maxRange |
Returns: SalBoolean.
| Parameter | Type | Description |
|---|---|---|
rowsLowerHalf | ||
dragAdjust |
Returns: SalBoolean.
| Parameter | Type | Description |
|---|---|---|
minRange | ||
maxRange |
Returns: SalBoolean.
Clears a table window by discarding all rows from the table window cache and setting the table range to 0, -1.
Returns: SalBoolean.
Scrolls a table window to the specified row and column.
Returns: SalBoolean.
Scrolls a table window to the specified row and column.
Returns: SalBoolean.
Assigns data to a column of a table window's context row.
Returns: SalBoolean.
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.
| Parameter | Type | Description |
|---|---|---|
row |
Returns: SalBoolean.
Sets or clears row flags.
| Parameter | Type | Description |
|---|---|---|
flags | ||
set | ||
flagsOn | ||
flagsOff |
Returns: SalBoolean.
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.
Returns: SalBoolean.
Sets a table window's focus frame row.
| Parameter | Type | Description |
|---|---|---|
row |
Returns: SalBoolean.
Sets the height of a row in lines.
| Parameter | Type | Description |
|---|---|---|
lines |
Returns: SalBoolean.
Sets the number of locked table window columns.
| Parameter | Type | Description |
|---|---|---|
lockedColumns |
Returns: SalBoolean.
Defines the minimum and maximum rows (range) of a table.
Returns: SalBoolean.
Sets the focus to the first, last, next, or previous row in a table window.
| Parameter | Type | Description |
|---|---|---|
rowPos |
Returns: SalNumber.
Sets or clears a table window row's flags.
| Parameter | Type | Description |
|---|---|---|
row | ||
flags | ||
set |
Returns: SalBoolean.
Sets or clears a table window's flags.
| Parameter | Type | Description |
|---|---|---|
flags | ||
set |
Returns: SalBoolean.
Sorts the rows of a table window based on the values in one of the table window's columns.
Returns: SalBoolean.
| Name | Description |
|---|---|
Pushbutton with tool tip support |
| Name | Description |
|---|---|
All Sal windows (Child windows, Forms, Dialogs and MDIs) implement this interface. |
