SalFormTableWindow

PPJ.Runtime.Windows.SalFormTableWindow

Namespace: PPJ.Runtime.Windows

Assembly: PPJ.Web.49 (4.9.0.0)

Top level table window implementation.

public class SalFormTableWindow : SalForm, IEnumerable<SalTableRow>, IEnumerable

Constructors

Constructs a SalFormWindow object.

Properties

Boolean: Enables/Disables AutoEditing mode. When this mode is on, the grid automatically enters edit mode when a cell is selected. (Default: False)

Boolean: Allow row sizing. (Default: True)

Boolean: Enables/Disables automatic sorting on table columns. (Default: False)

SalTableColumnCollection: Returns the collection of columns.

Boolean: Prevents the split grid from getting the focus while allowing for he horizontal scroll and column resizing. (Default: False)

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)

SalTableWindow: Returns the internal table window control.

Methods

Determines whether any rows in the specified table window match certain flags.

ParameterTypeDescription

nFlagsOn

nFlagsOff

Returns: SalBoolean.

Prevents the control from updating until the EndUpdate method is called.

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.

ParameterTypeDescription

nColumnID

nFlagsOn

nFlagsOff

Returns: SalNumber.

Computes the sum of all column values or only specified column values in a table window.

ParameterTypeDescription

nColumnID

nFlagsOn

nFlagsOff

Returns: SalNumber.

Copies the contents of the specified table window rows to the Clipboard in text format.

ParameterTypeDescription

nFlagsOn

nFlagsOff

Returns: SalBoolean.

Creates a table window column of string data type at runtime.

ParameterTypeDescription

nColumnPos

nDispWidth

nMaxChars

sTitle

Returns: SalNumber.

Creates a table window column using a given data type at runtime. Allowed types are DT_String, DT_Number and DT_DateTime

ParameterTypeDescription

nColumnPos

nDispWidth

sTitle

nMaxChars

nDatatype

Returns: SalNumber.

Defines the appearance and behavior of a table window's row header.

ParameterTypeDescription

sTitle

nWidth

nFlags

column

Returns: SalBoolean.

Splits a table window horizontally.

ParameterTypeDescription

nRowsLowerHalf

bDragAdjust

Returns: SalBoolean.

Deletes a row from a table window but not from the database.

ParameterTypeDescription

nRow

nFlag

Returns: SalBoolean.

Applies a SQL DELETE statement to all table window rows with the ROW Selected flag.

ParameterTypeDescription

hSql

Returns: SalBoolean.

Applies a SQL DELETE statement to all table window rows with the ROW Selected flag.

ParameterTypeDescription

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.

ParameterTypeDescription

hSql

nFlagsOn

Returns: SalBoolean.

Applies a SQL DELETE statement to all table window rows that have nFlagsOn flags.

ParameterTypeDescription

hSql

nFlagsOn

errorHandler

Returns: SalBoolean.

Applies a SQL INSERT statement to all the rows in a table window that have the ROW New flag.

ParameterTypeDescription

hSql

bClearFlags

Returns: SalBoolean.

Applies a SQL INSERT statement to all the rows in a table window that have the ROW New flag.

ParameterTypeDescription

hSql

bClearFlags

errorHandler

Returns: SalBoolean.

Applies a SQL UPDATE statement to all table window rows with the Row Edited flag.

ParameterTypeDescription

hSql

bClearFlags

Returns: SalBoolean.

Applies a SQL UPDATE statement to all table window rows with the Row Edited flag.

ParameterTypeDescription

hSql

bClearFlags

errorHandler

Returns: SalBoolean.

Resumes updating of the list view control after suspending it by the BeginUpdate method.

Sends a SAM_FetchRow message to a table window if the row you specify is not currently in the table window cache.

ParameterTypeDescription

nRow

Returns: SalNumber.

ParameterTypeDescription

nRow

nFlagsOn

nFlagsOff

Returns: SalBoolean.

ParameterTypeDescription

nRow

nFlagsOn

nFlagsOff

Returns: SalBoolean.

ParameterTypeDescription

nColumnID

sText

Returns: SalBoolean.

Gets data from a column of a table window's context row.

ParameterTypeDescription

nColumnID

Returns: SalString.

Gets the handle of a table window column.

ParameterTypeDescription

nCol

nFlags

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.

ParameterTypeDescription

nLines

Returns: SalBoolean.

Retrieves the height of a row in lines.

Returns: SalNumber.

Retrieves the number of locked table window columns.

Returns: SalNumber.

Queries a row's flags.

ParameterTypeDescription

nRow

nFlags

Returns: SalBoolean.

Tests the state of a table window's flags.

ParameterTypeDescription

nFlags

Returns: SalBoolean.

Inserts a new blank row into a table window.

ParameterTypeDescription

nRow

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.

ParameterTypeDescription

hSql

sSelect

nMethod

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.

ParameterTypeDescription

hSql

sSelect

nMethod

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.

ParameterTypeDescription

hSql

sSelect

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.

ParameterTypeDescription

hSql

sSelect

errorHandler

Returns: SalBoolean.

ParameterTypeDescription

nRow

hWndCol

Returns: SalBoolean.

ParameterTypeDescription

sTitle

nMaxTitle

nWidth

nFlags

hWndCol

Returns: SalBoolean.

ParameterTypeDescription

nPosition

nMinRange

nMaxRange

Returns: SalBoolean.

ParameterTypeDescription

nRowsLowerHalf

bDragAdjust

Returns: SalBoolean.

ParameterTypeDescription

nMinRange

nMaxRange

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.

ParameterTypeDescription

nRow

column

nFlags

Returns: SalBoolean.

Scrolls a table window to the specified row and column.

ParameterTypeDescription

nRow

column

Returns: SalBoolean.

Assigns data to a column of a table window's context row.

ParameterTypeDescription

nColumnID

sText

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.

ParameterTypeDescription

nRow

Returns: SalBoolean.

Sets or clears row flags.

ParameterTypeDescription

nFlags

bSet

nFlagsOn

nFlagsOff

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.

ParameterTypeDescription

nRow

column

Returns: SalBoolean.

Sets a table window's focus frame row.

ParameterTypeDescription

nRow

Returns: SalBoolean.

Sets the height of a row in lines.

ParameterTypeDescription

nLines

Returns: SalBoolean.

Sets the number of locked table window columns.

ParameterTypeDescription

nLockedColumns

Returns: SalBoolean.

Defines the minimum and maximum rows (range) of a table.

ParameterTypeDescription

nMin

nMax

Returns: SalBoolean.

Sets the focus to the first, last, next, or previous row in a table window.

ParameterTypeDescription

nRowPos

Returns: SalNumber.

Sets or clears a table window row's flags.

ParameterTypeDescription

nRow

nFlags

bSet

Returns: SalBoolean.

Sets or clears a table window's flags.

ParameterTypeDescription

nFlags

bSet

Returns: SalBoolean.

Sorts the rows of a table window based on the values in one of the table window's columns.

ParameterTypeDescription

nColumnID

nOrder

Returns: SalBoolean.

Implements

NameDescription

All Sal windows (Child windows, Forms, Dialogs and MDIs) implement this interface.

Last updated