PPJ Desktop API
HomeCurrent IssuesDownloads
  • Welcome
  • Concepts
  • PPJ.Runtime.49
    • General
      • Sal
      • Sys
      • SalApplication
      • SalNamedProperties
      • SalWindow
      • WindowActionsEventArgs
      • SalXML
    • COM
      • SalCoClass
      • SalObject
      • SalOleErrorInfo
      • SalSafeArray
      • SalVariant
    • Controls
      • SalActiveX
      • SalBackgroundText
      • SalCheckBox
      • SalComboBox
      • SalContext
      • SalCustomControl
      • SalDataField
        • DataType
      • SalFrame
        • BorderStyle
      • SalGeneralWindow
      • SalGroupBox
      • SalGroupSeparator
      • SalHorizontalScrollBar
      • SalLine
        • LineStyle
        • LineType
      • SalListBox
      • SalMultilineField
      • SalNavigationBar
      • SalOptionButton
        • OptionButtonStyle
      • SalPicture
        • ImageStorage
      • SalPushbutton
      • SalRadioButton
      • SalTableWindow
        • CellType
        • FocusRowStyle
        • RowsSizingStyle
        • SalTableColumn
        • SalTableColumnCollection
        • SalTableRow
        • SalTableRowCollection
        • SalTableWindowBase
      • SalTreeControl
        • SalTreeItem
      • SalUserControl
      • SalVerticalScrollBar
    • Forms
      • AccessoryType
      • SalDialogBox
      • SalForm
      • SalFormClientArea
      • SalFormStatusBar
      • SalFormTableWindow
      • SalFormToolBar
      • SalFormWindow
      • SalMDIWindow
      • SalRibbonBarBase
      • SalRibbonBarForm
      • SalRibbonBarMDI
      • SalRibbonStatusBar
    • Interfaces
      • ISalControl
      • ISalEditControl
      • ISalListControl
      • ISalPictureControl
      • ISalRadioButton
      • ISalReport
      • ISalType
      • ISalAccessory
      • ISalMenu
      • ISalWindow
    • Internet
      • FtpEventArgs
      • FtpEventHandler
      • HttpEventArgs
      • HttpEventHandler
      • SalFtpClient
      • SalHttpClient
      • SalQuickFTP
      • SalQuickHTTP
    • Menus
      • SalContextMenu
      • SalFormMainMenu
      • SalMenuColumn
      • SalMenuItem
      • SalMenuRow
      • SalMenuSeparator
      • SalPopupMenu
      • SalWindowsMenu
    • QO
      • QO
      • SalQuickHTML
      • SalQuickTabs
      • SalQuickTabsDialog
      • SalQuickTabsForm
      • SalQuickTabsParent
      • SalQuickTabsParentDialog
      • SalQuickTabsParentForm
      • SalQuickToolTipCheckBox
      • SalQuickToolTipChildTable
      • SalQuickToolTipComboBox
      • SalQuickToolTipDataField
      • SalQuickToolTipHScrollBar
      • SalQuickToolTipListBox
      • SalQuickToolTipMultilineField
      • SalQuickToolTipOptionButton
      • SalQuickToolTipPicture
      • SalQuickToolTipPushButton
      • SalQuickToolTipRadioButton
      • SalQuickToolTipTableWindow
      • SalQuickToolTipVScrollBar
      • SalToolTipManager
    • Sql
      • SalSqlBindVariables
      • SalSqlError
      • SalSqlHandle
      • SalSqlSessionHandle
      • Sql
      • SqlContext
      • SqlOra
      • WhenSqlError
    • Types
      • SalArray
      • SalArray<T>
      • SalBinary
      • SalBoolean
      • SalDateTime
      • SalFileHandle
      • SalFunctionalClass
      • SalNumber
      • SalResource
      • SalString
      • SalStringContext
      • SalWindowHandle
  • PPJ.Runtime.DDE.49
    • General
      • SalDDE
  • PPJ.Runtime.Vis.49
    • General
      • Vis
      • VisTblEx
    • Controls
      • VisCalendar
      • VisCalendarDropDown
      • VisColorComboBox
      • VisColorListBox
      • VisColorPalette
      • VisColorPaletteBase
      • VisColorPaletteDropDown
      • VisComboBoxBase
      • VisDesktopListBox
      • VisDirListBox
      • VisDirTreeListBox
      • VisDriveListBox
      • VisDropDownBase
      • VisFileListBox
      • VisFontComboBox
      • VisFontListBox
      • VisFontNameComboBox
      • VisFontNameListBox
      • VisListBoxBase
      • VisListBoxExtension
      • VisListView
      • VisListViewDropDown
      • VisMeter
      • VisOutlineComboBox
      • VisOutlineListBox
      • VisPictureComboBox
      • VisPictureListBox
      • VisPoint
      • VisRadioListBox
      • VisRect
      • VisRichEdit
      • VisSize
      • VisSpinField
      • VisSplitter
      • VisSplitterWindow
        • Orientation
  • PPJ.Runtime.XSal.49
    • General
      • XSal
      • XSalScript
    • Controls
      • XSalFlatButton
      • XSalHSplitter
      • XSalSeparator
      • XSalSeparatorDoubleRaised
      • XSalSeparatorEtched
      • XSalSeparatorInvisible
      • XSalSeparatorSingleRaised
      • XSalSplitter
      • XSalToolbar
      • XSalToolbox
      • XSalVSplitter
Powered by GitBook
On this page
  • Constructors
  • SalFormTableWindow()
  • Properties
  • AllowAutoEditing
  • AllowFiltering
  • AllowRowSizing
  • AllowSorting
  • Columns
  • ExtendLastColumn
  • FocusRowStyle
  • Icon
  • Item(id)
  • Item(name)
  • LinesPerRow
  • ReadOnly
  • RowSizingStyle
  • ShowCellLabels
  • ShowCursor
  • ShowFocusRow
  • TableWindow
  • Trimming
  • UseNativeTypes
  • UseVisualStyles
  • VirtualMode
  • Methods
  • AnyRows(nFlagsOn, nFlagsOff)
  • ClearSelection()
  • ColumnAverage(columnID, flagsOn, flagsOff)
  • ColumnSum(columnID, flagsOn, flagsOff)
  • CopyRows(flagsOn, flagsOff)
  • CreateColumn(columnPos, dispWidth, maxChars, title)
  • CreateColumnEx(columnPos, dispWidth, title, maxChars, datatype)
  • DefineRowHeader(title, width, flags, column)
  • DefineSplitWindow(rowsLowerHalf, dragAdjust)
  • DeleteRow(row, flag)
  • DeleteSelected(hSql)
  • DeleteSelected(hSql, errorHandler)
  • DestroyColumns()
  • DoDeletes(hSql, flagsOn)
  • DoDeletes(hSql, flagsOn, errorHandler)
  • DoInserts(hSql, clearFlags)
  • DoInserts(hSql, clearFlags, errorHandler)
  • DoUpdates(hSql, clearFlags)
  • DoUpdates(hSql, clearFlags, errorHandler)
  • FetchRow(row)
  • FindNextRow(row, flagsOn, flagsOff)
  • FindPrevRow(row, flagsOn, flagsOff)
  • GetColumnText(columnID, text)
  • GetColumnText(columnID)
  • GetColumnWindow(col, flags)
  • GetContextRow()
  • GetLinesPerRow(lines)
  • GetLinesPerRow()
  • GetLockedColumns()
  • GetMergedRange(row, col, clip)
  • GetRowFlags(row, flags)
  • GetTableFlags(flags)
  • HitTest(x, y, row, col, flags)
  • InsertRow(row)
  • KillCellEdit()
  • KillFocusRow()
  • PasteRows()
  • Populate(hSql, select, method)
  • Populate(hSql, select, method, errorHandler)
  • Populate(hSql, select)
  • Populate(hSql, select, errorHandler)
  • QueryFocusCell(row, col)
  • QueryRowHeader(title, maxTitle, width, flags, col)
  • QueryScroll(position, minRange, maxRange)
  • QuerySplitWindow(rowsLowerHalf, dragAdjust)
  • QueryVisibleRange(minRange, maxRange)
  • ResetTable()
  • ScrollRow(row, column, flags)
  • ScrollRow(row, column)
  • SetColumnText(columnID, text)
  • SetContextRow(row)
  • SetFlagsAnyRows(flags, set, flagsOn, flagsOff)
  • SetFocusCell(row, column, editMin, editMax)
  • SetFocusRow(row)
  • SetLinesPerRow(lines)
  • SetLockedColumns(lockedColumns)
  • SetRange(min, max)
  • SetRow(rowPos)
  • SetRowFlags(row, flags, set)
  • SetTableFlags(flags, set)
  • SortRows(columnID, order)
  • Inherited By
  • Implements
  1. PPJ.Runtime.49
  2. Forms

SalFormTableWindow

PPJ.Runtime.Windows.SalFormTableWindow

PreviousSalFormStatusBarNextSalFormToolBar

Last updated 2 years ago

Namespace: PPJ.Runtime.Windows

Assembly: PPJ.Runtime.49 (4.9.0.0)

Top level table window implementation.

public class SalFormTableWindow : SalForm, IEnumerable<SalTableRow>, IEnumerable
Public Class SalFormTableWindow
    Inherits SalForm
    Implements IEnumerable(Of SalTableRow), IEnumerable

Constructors

SalFormTableWindow()

Constructs a SalFormWindow object.

Properties

AllowAutoEditing

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

AllowFiltering

: Enables/Disables the excel-style filtering feature. (Default: False)

Set the property 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.

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.

Methods

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

Parameter
Type
Description

nFlagsOn

nFlagsOff

Deselects all rows of a table window.

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

Parameter
Type
Description

columnID

flagsOn

flagsOff

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

Parameter
Type
Description

columnID

flagsOn

flagsOff

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

Parameter
Type
Description

flagsOn

flagsOff

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

Parameter
Type
Description

columnPos

dispWidth

maxChars

title

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

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

Parameter
Type
Description

title

width

flags

column

Splits a table window horizontally.

Parameter
Type
Description

rowsLowerHalf

dragAdjust

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

Parameter
Type
Description

row

flag

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.

Parameter
Type
Description

col

flags

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.

Parameter
Type
Description

row

col

clip

Queries a row's flags.

Parameter
Type
Description

row

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

Parameter
Type
Description

row

col

Parameter
Type
Description

title

maxTitle

width

flags

col

Parameter
Type
Description

position

minRange

maxRange

Parameter
Type
Description

rowsLowerHalf

dragAdjust

Parameter
Type
Description

minRange

maxRange

Clears a table window by discarding all rows from the table window cache and setting the table range to 0, -1.

Scrolls a table window to the specified row and column.

Parameter
Type
Description

row

column

flags

Scrolls a table window to the specified row and column.

Parameter
Type
Description

row

column

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

Parameter
Type
Description

columnID

text

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

Sets or clears row flags.

Parameter
Type
Description

flags

set

flagsOn

flagsOff

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.

Parameter
Type
Description

row

column

editMin

editMax

Sets a table window's focus frame row.

Parameter
Type
Description

row

Sets the height of a row in lines.

Parameter
Type
Description

lines

Sets the number of locked table window columns.

Parameter
Type
Description

lockedColumns

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

Parameter
Type
Description

min

max

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

Parameter
Type
Description

rowPos

Sets or clears a table window row's flags.

Parameter
Type
Description

row

flags

set

Sets or clears a table window's flags.

Parameter
Type
Description

flags

set

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

Parameter
Type
Description

columnID

order

Inherited By

Name
Description

Pushbutton with tool tip support

Implements

Name
Description

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

AllowRowSizing

: Allow row sizing. (Default: True)

AllowSorting

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

Columns

: Returns the collection of columns.

ExtendLastColumn

: 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.

Item(id)

: Returns the table column object with the specified column ID. The ID is 1-based.

Item(name)

: Returns the table column object with the specified name.

LinesPerRow

: Number of lines per row.

ReadOnly

: 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)

RowSizingStyle

: Keeps all rows of the same height. (Default: FreeSize)

ShowCellLabels

: Gets or sets whether the grid should display labels over cells whose contents are partially hidden. (Default: False)

ShowCursor

: Enables/Disables the arrow icon on the current row. (Default: False)

ShowFocusRow

: Enables/Disables the focus frame around the current row. (Default: True)

TableWindow

: Returns the internal table window control.

Trimming

: Defines how to trim the content that doesn't fit the width of the cell. (Default: None)

UseNativeTypes

: Returns or sets whether the grid tries to parse the edited value into the native type of the column. (Default: False)

UseVisualStyles

: Enables/Disabled drawing of columns and rows headers using the current visual style theme renderer. (Default: False)

VirtualMode

: 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)

AnyRows(nFlagsOn, nFlagsOff)

Returns: .

ClearSelection()

Returns: .

ColumnAverage(columnID, flagsOn, flagsOff)

Returns: .

ColumnSum(columnID, flagsOn, flagsOff)

Returns: .

CopyRows(flagsOn, flagsOff)

Returns: .

CreateColumn(columnPos, dispWidth, maxChars, title)

Returns: .

CreateColumnEx(columnPos, dispWidth, title, maxChars, datatype)

Returns: .

DefineRowHeader(title, width, flags, column)

Returns: .

DefineSplitWindow(rowsLowerHalf, dragAdjust)

Returns: .

DeleteRow(row, flag)

Returns: .

DeleteSelected(hSql)

Returns: .

DeleteSelected(hSql, errorHandler)

Returns: .

DestroyColumns()

Returns: .

DoDeletes(hSql, flagsOn)

Returns: .

DoDeletes(hSql, flagsOn, errorHandler)

Returns: .

DoInserts(hSql, clearFlags)

Returns: .

DoInserts(hSql, clearFlags, errorHandler)

Returns: .

DoUpdates(hSql, clearFlags)

Returns: .

DoUpdates(hSql, clearFlags, errorHandler)

Returns: .

FetchRow(row)

Returns: .

FindNextRow(row, flagsOn, flagsOff)

Returns: .

FindPrevRow(row, flagsOn, flagsOff)

Returns: .

GetColumnText(columnID, text)

Returns: .

GetColumnText(columnID)

Returns: .

GetColumnWindow(col, flags)

Returns: .

GetContextRow()

Returns: .

GetLinesPerRow(lines)

Returns: .

GetLinesPerRow()

Returns: .

GetLockedColumns()

Returns: .

GetMergedRange(row, col, clip)

Returns: .

GetRowFlags(row, flags)

Returns: .

GetTableFlags(flags)

Returns: .

HitTest(x, y, row, col, flags)

Returns: .

InsertRow(row)

Returns: .

KillCellEdit()

Returns: .

KillFocusRow()

Returns: .

PasteRows()

Returns: .

Populate(hSql, select, method)

Returns: .

Populate(hSql, select, method, errorHandler)

Returns: .

Populate(hSql, select)

Returns: .

Populate(hSql, select, errorHandler)

Returns: .

QueryFocusCell(row, col)

Returns: .

QueryRowHeader(title, maxTitle, width, flags, col)

Returns: .

QueryScroll(position, minRange, maxRange)

Returns: .

QuerySplitWindow(rowsLowerHalf, dragAdjust)

Returns: .

QueryVisibleRange(minRange, maxRange)

Returns: .

ResetTable()

Returns: .

ScrollRow(row, column, flags)

Returns: .

ScrollRow(row, column)

Returns: .

SetColumnText(columnID, text)

Returns: .

SetContextRow(row)

Returns: .

SetFlagsAnyRows(flags, set, flagsOn, flagsOff)

Returns: .

SetFocusCell(row, column, editMin, editMax)

Returns: .

SetFocusRow(row)

Returns: .

SetLinesPerRow(lines)

Returns: .

SetLockedColumns(lockedColumns)

Returns: .

SetRange(min, max)

Returns: .

SetRow(rowPos)

Returns: .

SetRowFlags(row, flags, set)

Returns: .

SetTableFlags(flags, set)

Returns: .

SortRows(columnID, order)

Returns: .

Boolean
Boolean
SalTableColumnCollection
Boolean
FocusRowStyle
Icon
SalTableColumn
SalTableColumn
Int32
Boolean
RowsSizingStyle
Boolean
Boolean
Boolean
SalTableWindow
StringTrimming
Boolean
Boolean
Boolean
SalBoolean
SalBoolean
SalNumber
SalNumber
SalBoolean
SalNumber
SalNumber
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalNumber
SalBoolean
SalBoolean
SalBoolean
SalString
SalWindowHandle
SalNumber
SalBoolean
SalNumber
SalNumber
CellRange
SalBoolean
SalBoolean
SalBoolean
SalNumber
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalBoolean
SalNumber
SalBoolean
SalBoolean
SalBoolean
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalString
SalNumber
SalNumber
SalString
SalNumber
SalNumber
SalString
SalNumber
SalNumber
Control
SalNumber
SalBoolean
SalNumber
SalNumber
SalSqlHandle
SalSqlHandle
WhenSqlErrorHandler
SalSqlHandle
SalNumber
SalSqlHandle
SalNumber
WhenSqlErrorHandler
SalSqlHandle
SalBoolean
SalSqlHandle
SalBoolean
WhenSqlErrorHandler
SalSqlHandle
SalBoolean
SalSqlHandle
SalBoolean
WhenSqlErrorHandler
SalNumber
SalNumber&
SalNumber
SalNumber
SalNumber&
SalNumber
SalNumber
SalNumber
SalString&
SalNumber
SalNumber
SalNumber
SalNumber&
Int32
Int32
Boolean
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber&
SalWindowHandle&
SalNumber&
SalNumber
SalSqlHandle
SalString
SalNumber
SalSqlHandle
SalString
SalNumber
WhenSqlErrorHandler
SalSqlHandle
SalString
SalSqlHandle
SalString
WhenSqlErrorHandler
SalNumber&
SalWindowHandle&
SalString&
SalNumber
SalNumber&
SalNumber&
SalWindowHandle&
SalNumber&
SalNumber&
SalNumber&
SalNumber&
SalBoolean&
SalNumber&
SalNumber&
SalNumber
Control
SalNumber
SalNumber
Control
SalNumber
SalString
SalNumber
SalNumber
SalBoolean
SalNumber
SalNumber
SalNumber
Control
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalNumber
SalBoolean
SalNumber
SalBoolean
SalNumber
SalNumber
SalQuickToolTipTableWindow
ISalWindow
Boolean
Boolean
UseNativeTypes