SalTableColumn

PPJ.Runtime.Windows.SalTableColumn

Namespace: PPJ.Runtime.Windows

Assembly: PPJ.Runtime.49 (4.9.0.0)

Summary description for SalTableColumn.

public class SalTableColumn : Control, ISalWindow, ISalEditControl, ISalControl, ISalListControl, IConvertible, IComparer

Constructors

Constructs a new SalTableColumn. The SalTableColumn control is made invisible by moving it outside of the bounds of the parent SalTableWindow control.

Properties

Boolean: Allow Drop (Default: False)

Boolean: Enables/Disables filtering on this column. (Default: False)

AnchorStyles: Anchor (Default: Top, Left)

Color: Returns/Sets the column's background color.

Image: Background Image (Default: null)

ImageLayout: Background Image Layout (Default: Tile)

Boolean: Causes Validation

Color: Returns/Sets th current cell text color

CellType: Indicates the type of control used to edit the cell. (Default: Standard)

CharacterCasing: Indicates if all characters should be left alone or converted to uppercase or lowercase. (Default: Normal)

CellCheckBox: Defines the behavior of the check box column.

CellComboBox: Defines the behavior of the combo box column.

CultureInfo: Returns/Sets the culture to use for this control. (Default: null)

Cursor: Cursor

Control: Returns/Sets the custom editor control used to edit cells. (Default: null)

DataType: Value type of the text box control. (Default: String)

SalDateTime: DateTime value property.

DockStyle: Dock (Default: None)

String: Indicates the edit mask to apply to the text. (Default: "")

Boolean: Enables/Disables the built-in spell checker. (Default: False)

Int32: Returns/Sets the column flags on this column.

String: Format string. (Default: "")

Column: Returns/Sets the underlying flexgrid column.

Int32: Unique column id.

ImeMode: ImeMode

Boolean: Returns true if the column has been automatically created.

Boolean: Returns true if the column has been dynamically created.

Control: Returns/Sets the label associated with this control.

Point: Location

Int32: Maximum number of characters. (Default: 100)

Boolean: Returns/Sets the modified flag on the current cell.

SalNamedProperties: Returns the collection of named properties.

SalNumber: Number value property.

SalTableWindow: Returns the parent SalTableWindow control.

Char: Indicates the character to display for password input. (Default: "\0")

String: Returns the text to use when displaying password-protected columns.

CellPopupBox: Defines the behavior of the popup edit column.

Int32: Column position.

Boolean: Controls whether the text in the cell can be changed. (Default: False)

Boolean: RightToLeft

Boolean: Selects/Deselcts the column.

Size: Size

Column: Returns/Sets the underlying flexgrid column for the split grid.

Int32: TabIndex

Boolean: TabStop

String: Overrides the default text property to keep it in sync with the grid cell and to convert boolean values.

HorizontalAlignment: Indicates how the text should be aligned. (Default: Left)

String: Column's title. (Default: "")

HorizontalAlignment: Indicates how the column header should be aligned. (Default: Center)

Int32: Column Width. (Default: 80)

Boolean: Indicates if lines are automatically word-wrapped for multi line cells. (Default: False)

Methods

Adds a string to a list box or combo box.

ParameterTypeDescription

sName

Returns: SalNumber.

Computes the average of all column values or only specified column values in a table window. Use row flags constants to specify the rows to use in the computation. For example, you can choose to average only the values of modified rows.

ParameterTypeDescription

flagsOn

The flags that the row should have. You can combine ROW* flags using the OR (|) operator.

flagsOff

The flags that the row should not have. You can combine ROW* flags using the OR (|) operator:

Returns: Decimal. Average

Brings a window to the top of all overlapping windows.

Returns: SalBoolean.

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.

Returns: SalBoolean.

Clears the value from a data field, multi line field, or table window column.

Returns: SalBoolean.

Clears a window's cursor.

ParameterTypeDescription

type

Returns: SalBoolean.

Deletes all entries from a list box or combo box.

Returns: SalBoolean.

Define a column as a check box.

ParameterTypeDescription

flags

checkedValue

uncheckedValue

Returns: SalBoolean.

Define a column as a drop down list.

ParameterTypeDescription

flags

lines

Returns: SalBoolean.

Define a column as a popup edit window.

ParameterTypeDescription

flags

lines

Returns: SalBoolean.

Deletes a list box or combo box entry.

ParameterTypeDescription

nIndex

Returns: SalNumber.

Destroys a form window, a top-level table window, or a modeless dialog box created with SalCreateWindow.

Returns: SalBoolean.

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.

Returns: SalBoolean.

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.

Returns: SalBoolean.

Enables keyboard and mouse input to a window.

Returns: SalBoolean.

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.

Returns: SalBoolean.

This function finds a child window of a given name in the specified window.

ParameterTypeDescription

windowName

Returns: SalWindowHandle.

Dispatches the specified message (Window Actions) directly to the control's WindowActions event handlers, without going through Windows message loop.

ParameterTypeDescription

nMsg

nMywParam

nMylParam

Returns: SalNumber.

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.

ParameterTypeDescription

formUnits

The number of form units.

vertical

If the form units are on the X axis, set this parameter to FALSE. If the form units are on the Y axis, set this parameter to TRUE.

Returns: SalNumber.

Returns the SalTableColumn instance from the specified control.

ParameterTypeDescription

ctrl

Target control on which to execute the call.

Returns: SalTableColumn.

ParameterTypeDescription

type

Returns: SalBoolean.

Indicates whether a column is a check box, drop down list, popup edit, or standard column.

Returns: SalNumber.

Return the name of a window's class as a string.

Returns: SalString.

Tests the state of a table window column's flags.

ParameterTypeDescription

flags

Returns: SalBoolean.

Gets a table window column's identifier.

Returns: SalNumber.

Gets a table window column's relative position.

Returns: SalNumber.

ParameterTypeDescription

text

maxLen

Returns: SalNumber.

Gets the title of a table window column.

ParameterTypeDescription

maxLen

Returns: SalString.

ParameterTypeDescription

width

Returns: SalBoolean.

Returns the width (in form units) of a table window column.

Returns: SalNumber.

Returns an object's type.

Returns: SalNumber.

Returns the maximum length of a data field, multi line text field, or table window column.

Returns: SalNumber.

Returns a data field's or table window column's data type.

Returns: SalNumber.

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.

ParameterTypeDescription

typeMask

One or more window types combined (using the OR (|) operator) to create a mask of child window types.

Returns: SalWindowHandle.

ParameterTypeDescription

name

size

enhancement

Returns: SalBoolean.

ParameterTypeDescription

sPicture

Returns: SalBoolean.

Gets the picture format of a data field or table window column.

Returns: SalString.

Returns the current format of a data field or table window column.

Returns: SalNumber.

ParameterTypeDescription

sText

bFormat

Returns: SalBoolean.

Copies the contents of a data field or table window column to a string. This function also lets you copy the format of the data.

ParameterTypeDescription

bFormat

Returns: SalString.

ParameterTypeDescription

sMask

Returns: SalBoolean.

Gets the input mask of a data field or table window column.

Returns: SalString.

Retrieves the window handle of the label (label control) that is associated with the hWndTarget parameter. There must be a mnemonic in that label, and it must immediately precede hWndTarget in the outline, or this function will fail.

Returns: SalWindowHandle.

ParameterTypeDescription

sText

nMaxLength

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

ParameterTypeDescription

nMaxLength

Returns: SalString.

Returns the number of list box or combo box entries.

Returns: SalNumber.

Determines whether the specified list box or combo box entry is selected.

ParameterTypeDescription

index

Returns: SalBoolean.

ParameterTypeDescription

index

text

Returns: SalNumber.

Returns the text of the specified item.

ParameterTypeDescription

index

Returns: SalString.

Returns the length of a list box or combo box entry.

ParameterTypeDescription

index

Returns: SalNumber.

ParameterTypeDescription

fileName

Returns: SalBoolean.

Fetches the selected directory or file name from a list box or combo box.

Returns: SalString. Name of the selected file in t he control.

Returns the index of the selected entry in a combo box or single-selection list box.

Returns: SalNumber.

Returns an array of index numbers of selected list box entries.

ParameterTypeDescription

nSelectedArray

Returns: SalBoolean.

Returns the number of selected entries in a multiple-selection list box. Specify single- or multiple-selection in the list box's customizer.

Returns: SalNumber.

ParameterTypeDescription

x

y

Returns: SalBoolean.

ParameterTypeDescription

text

Returns: SalBoolean.

Gets the name of an object.

Returns: SalString.

Returns the handle of the next child window that matches a specified type.

ParameterTypeDescription

typeMask

One or more window types combined (using the OR (|) operator) to create a mask of child window types.

Returns: SalWindowHandle.

Returns the handle of an object's parent window.

Returns: SalWindowHandle.

ParameterTypeDescription

name

value

Returns: SalBoolean.

Gets the value of a named property.

ParameterTypeDescription

name

Returns: SalString.

ParameterTypeDescription

width

height

Returns: SalBoolean.

ParameterTypeDescription

text

maxLen

Returns: SalNumber.

Retrieves the text of a window.

ParameterTypeDescription

maxLen

Returns: SalString.

ParameterTypeDescription

sText

Returns: SalBoolean.

Unmasks the text from a masked edit control.

Returns: SalString.

Gets a window's color.

ParameterTypeDescription

colorIndex

Returns: SalNumber.

Returns a window's current state.

Returns: SalNumber.

Hides a window.

Returns: SalBoolean.

Hides a window and its associated label.

Returns: SalBoolean.

Inserts an entry into a list box or combo box at a specified position.

ParameterTypeDescription

nIndex

sAdd

Returns: SalNumber.

Causes a window to be repainted.

Returns: SalBoolean.

Determines whether a window is an instance of the specified class.

ParameterTypeDescription

typeClass

Returns: SalBoolean.

Verifies whether a data field, multi line text field, or table window column is null or empty.

Returns: SalBoolean.

Determines whether a window is enabled for mouse and keyboard input.

Returns: SalBoolean.

Returns the setting of the Field Edit Flag for a data field, multi line field, combo box, table window's context row cell, or picture.

Returns: SalBoolean.

Validates the contents of a data field or table window column using the current profile.

Returns: SalBoolean.

Verifies whether a data field, multi line text field, or table window column contains a valid date/time value. For multi line text fields, the date/time value must be the only item in the field.

Returns: SalBoolean.

Verifies whether a data field, multi line text field, or table window column contains a valid decimal value. For multi line text fields, the decimal value must be the only item in the field.

ParameterTypeDescription

nPrecision

nScale

Returns: SalBoolean.

Verifies whether a data field, multi line text field, or table window column contains a valid integer value. For multi line text fields, the integer value must be the only item in the field.

Returns: SalBoolean.

Verifies whether a data field, multi line text field, or table window column contains a valid numeric value. Valid numbers are integers or floating point numbers, negative and positive. For multi line text fields, the numeric value must be the only item in the field.

Returns: SalBoolean.

Determines whether a window is currently visible.

Returns: SalBoolean.

Destroys an object's system timer.

ParameterTypeDescription

idEvent

Returns: SalBoolean.

Moves a window a given number of form units on the X and Y axes relative to its current position.

ParameterTypeDescription

xOffset

yOffset

Returns: SalBoolean.

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.

ParameterTypeDescription

numPixels

vertical

If the form units are on the X axis, set this parameter to FALSE. If the form units are on the Y axis, set this parameter to TRUE.

Returns: SalNumber.

Populates a list box or combo box with a result set. SalListPopulate overrides any settings made with SalListSetTabs. If the SELECT statement returns data from multiple columns, each column's data displayed in a list box is separated by tabs. However, due to a Microsoft Windows limitation, each column's data displayed in a combo box is separated by a single '|' character. There is no space between one column's data, the separator character, and another column's data.

ParameterTypeDescription

hSql

sSelect

Returns: SalBoolean.

Populates a list box or combo box with a result set. SalListPopulate overrides any settings made with SalListSetTabs. If the SELECT statement returns data from multiple columns, each column's data displayed in a list box is separated by tabs. However, due to a Microsoft Windows limitation, each column's data displayed in a combo box is separated by a single '|' character. There is no space between one column's data, the separator character, and another column's data.

ParameterTypeDescription

hSql

sSelect

errorHandler

Returns: SalBoolean.

ParameterTypeDescription

ctrlPath

pathName

attributes

Returns: SalBoolean.

Posts the specified message to a window by adding nMsg to hWndReceiver's message queue.

ParameterTypeDescription

nMsg

nMywParam

nMylParam

Returns: SalBoolean.

ParameterTypeDescription

flags

checkedValue

uncheckedValue

Returns: SalBoolean.

ParameterTypeDescription

flags

lines

Returns: SalBoolean.

ParameterTypeDescription

flags

lines

Returns: SalBoolean.

Sends the specified message to a window. SalSendMsg does not return until the processing for the message is complete.

ParameterTypeDescription

nMsg

nMywParam

nMylParam

Returns: SalNumber.

Sends a message to all child items of a form window, dialog box, table window, or MDI window.

ParameterTypeDescription

nMsg

nMywParam

nMylParam

Returns: SalBoolean.

Changes a table window cell's text color.

ParameterTypeDescription

color

discardable

Returns: SalBoolean.

Changes a table window cell's text color.

ParameterTypeDescription

color

Returns: SalBoolean.

Sets or clears a table window column's flags.

ParameterTypeDescription

flags

set

Returns: SalBoolean.

Moves a table window column to a new position.

ParameterTypeDescription

position

Returns: SalBoolean.

Sets the title of a table window column.

ParameterTypeDescription

title

Returns: SalBoolean.

Sets a table window column's display width.

ParameterTypeDescription

width

Returns: SalBoolean.

Defines a named popup menu that displays automatically when a window receives SAM_ContextMenu.

ParameterTypeDescription

sMenuName

nFlags

Returns: SalBoolean.

Defines a named popup menu that displays automatically when a window receives SAM_ContextMenu.

ParameterTypeDescription

menuType

flags

Returns: SalBoolean.

Sets a window's cursor.

ParameterTypeDescription

resource

type

Returns: SalBoolean.

Sets a window's cursor.

ParameterTypeDescription

resourceId

type

Returns: SalBoolean.

Sets a window's cursor from a string variable.

ParameterTypeDescription

blob

type

Returns: SalBoolean.

Sets an application-defined cursor for the specified window. Use this function to set the cursor from an image stored in a file.

ParameterTypeDescription

file

type

Returns: SalBoolean.

Sets a limit on the number of characters that a user can enter into a data field, multi line text field, or table window column.

ParameterTypeDescription

length

Returns: SalBoolean.

Sets the focus to a specified window.

Returns: SalWindowHandle.

Sets a window's font, font size, and font enhancements.

ParameterTypeDescription

name

size

enhancement

Returns: SalBoolean.

Sets the picture format of a data field or table window column.

ParameterTypeDescription

sPicture

Returns: SalBoolean.

Sets a data field's or table window column's format.

ParameterTypeDescription

nFormat

Returns: SalBoolean.

Sets the input mask of a data field or table window column.

ParameterTypeDescription

sMask

Returns: SalBoolean.

Sets the text of the associated label control.

ParameterTypeDescription

sText

Returns: SalBoolean.

Redraws entries in a list box or combo box, or prevents them from being redrawn.

ParameterTypeDescription

redraw

Returns: SalBoolean.

Selects or deselects a combo box or single-selection list box entry.

ParameterTypeDescription

index

Returns: SalBoolean.

Selects or deselects a combo box or multiple-selection list box entry.

ParameterTypeDescription

index

select

Returns: SalBoolean.

Finds and selects a combo box or single-selection list box entry.

ParameterTypeDescription

indexStart

text

Returns: SalNumber.

Sets tabs in a list box.

ParameterTypeDescription

tabStops

Returns: SalBoolean.

Moves a window to a new position (x, y) on the X and Y axes.

ParameterTypeDescription

x

y

Returns: SalBoolean.

Sets or clears the field edit flag for an editable data field, combo box, multi line text field, table window column, or picture.

ParameterTypeDescription

bSet

Returns: SalBoolean.

Sets the value of a named property.

ParameterTypeDescription

name

value

length

Returns: SalBoolean.

Resizes a window.

ParameterTypeDescription

width

height

Returns: SalBoolean.

Sets the text of a window.

ParameterTypeDescription

text

Returns: SalBoolean.

Copies a string to a data field or table window column. After copying the string to the field, formats the string.

ParameterTypeDescription

sValue

bFormat

Returns: SalBoolean.

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.

ParameterTypeDescription

idEvent

elapseMilliSec

Returns: SalBoolean.

Sets a window's color.

ParameterTypeDescription

colorIndex

color

Returns: SalBoolean.

Makes a window visible.

Returns: SalBoolean.

Makes a window and its associated label visible. A label is the label control that immediately precedes the window in the outline.

Returns: SalBoolean.

Sorts the column and shows the sort glyph.

ParameterTypeDescription

flags

Adds the values of the cells in the rows that match the specified flags.

ParameterTypeDescription

flagsOn

flagsOff

Returns: Decimal. Sum

Creates pop-up menus at runtime.

ParameterTypeDescription

menuName

flags

x

y

Returns: SalBoolean.

Creates pop-up menus at runtime.

ParameterTypeDescription

menuType

flags

x

y

Returns: SalBoolean.

Forces the update of a window.

Returns: SalBoolean.

Validates and formats a data field's or table window column's contents.

Returns: SalBoolean.

Validates and formats a data field's or table window column's contents.

ParameterTypeDescription

validate

Returns: SalBoolean.

Starts the Windows help system.

ParameterTypeDescription

file

command

numData

strData

Returns: SalBoolean.

Processes messages for this control.

Events

SalMessageHandler Message Actions

WindowActionsEventHandler Window Actions

Implements

NameDescription

All SAL controls implement this interface.

SAL Editable controls implement this interface

SAL List controls implement this interface.

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

Last updated