SalFormTableWindow
PPJ.Runtime.Windows.SalFormTableWindow
Namespace: PPJ.Runtime.Windows
Assembly: PPJ.Runtime.49 (4.9.0.0)
Top level table window implementation.
C#
VB.NET
public class SalFormTableWindow : SalForm, IEnumerable<SalTableRow>, IEnumerable
Public Class SalFormTableWindow
Inherits SalForm
Implements IEnumerable(Of SalTableRow), IEnumerable
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
)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: 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
)Boolean: Gets or sets whether the grid should display labels over cells whose contents are partially hidden. (Default:
False
)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.
Deselects all rows of a table window.
Computes the average of all column values or only specified column values in a table window.
Computes the sum of all column values or only specified column values in a table window.
Copies the contents of the specified table window rows to the Clipboard in text format.
Creates a table window column of string data type at runtime.
Creates a table window column using a given data type at runtime. Allowed types are DT_String, DT_Number and DT_DateTime
Defines the appearance and behavior of a table window's row header.
Splits a table window horizontally.
Parameter | Type | Description |
---|---|---|
rowsLowerHalf | | |
dragAdjust | |
Deletes a row from a table window but not from the database.
Applies a SQL DELETE statement to all table window rows with the ROW Selected flag.
Parameter | Type | Description |
---|---|---|
hSql | |
Applies a SQL DELETE statement to all table window rows with the ROW Selected flag.
Parameter | Type | Description |
---|---|---|
hSql | | |
errorHandler | |
Destroys all automatic columns created by SalTblCreateColumn or SalTblPopulate at runtime. This function only works on table windows that contain only automatic columns.
Applies a SQL DELETE statement to all table window rows that have nFlagsOn flags.
Parameter | Type | Description |
---|---|---|
hSql | | |
flagsOn | |
Applies a SQL DELETE statement to all table window rows that have nFlagsOn flags.
Parameter | Type | Description |
---|---|---|
hSql | | |
flagsOn | | |
errorHandler | |
Applies a SQL INSERT statement to all the rows in a table window that have the ROW New flag.
Parameter | Type | Description |
---|---|---|
hSql | | |
clearFlags | |
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 | |
Applies a SQL UPDATE statement to all table window rows with the Row Edited flag.
Parameter | Type | Description |
---|---|---|
hSql | | |
clearFlags | |
Applies a SQL UPDATE statement to all table window rows with the Row Edited flag.
Parameter | Type | Description |
---|---|---|
hSql | | |
clearFlags | | |
errorHandler | |
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 | |
Parameter | Type | Description |
---|---|---|
row | | |
flagsOn | | |
flagsOff | |
Parameter | Type | Description |
---|---|---|
row | | |
flagsOn | | |
flagsOff | |
Parameter | Type | Description |
---|---|---|
columnID | | |
text | |
Gets data from a column of a table window's context row.
Parameter | Type | Description |
---|---|---|
columnID | |
Gets the handle of a table window column.
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.
Parameter | Type | Description |
---|---|---|
lines | |
Retrieves the height of a row in lines.
Retrieves the number of locked table window columns.
Overrides GetMergedRange to allow the SalTableWindow class to override the method.
Queries a row's flags.
Tests the state of a table window's flags.
Parameter | Type | Description |
---|---|---|
flags | |
Parameter | Type | Description |
---|---|---|
x | | |
y | | |
row | | |
col | | |
flags | |
Inserts a new blank row into a table window.
Parameter | Type | Description |
---|---|---|
row | |
Takes a row out of edit mode and selects the row. This causes the row to receive both SAM_Validate and SAM_KillFocus messages.
Turns off the table window's focus frame.
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.
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 | |
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 | |
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 | |
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 | |