# SalFormTableWindow

Namespace: **PPJ.Runtime.Windows**

Assembly: **PPJ.Runtime.49** (4.9.0.0)

Top level table window implementation.

{% tabs %}
{% tab title="C#" %}

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

{% endtab %}

{% tab title="VB.NET" %}

```visual-basic
Public Class SalFormTableWindow
    Inherits SalForm
    Implements IEnumerable(Of SalTableRow), IEnumerable
```

{% endtab %}
{% endtabs %}

## Constructors

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)SalFormTableWindow()

Constructs a SalFormWindow object.

## Properties

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)AllowAutoEditing

[Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.boolean): Enables/Disables AutoEditing mode. When this mode is on, the grid automatically enters edit mode when a cell is selected. (Default: `False`)

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)AllowFiltering

[Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.boolean): Enables/Disables the excel-style filtering feature. (Default: `False`)

Set the property [UseNativeTypes](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) 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.

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)AllowRowSizing

[Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.boolean): Allow row sizing. (Default: `True`)

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)AllowSorting

[Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.boolean): Enables/Disables automatic sorting on table columns. (Default: `False`)

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)Columns

[SalTableColumnCollection](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow): Returns the collection of columns.

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)ExtendLastColumn

[Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.boolean): Enables/Disables the extension of the last column to fill the grid. (Default: `False`)

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)FocusRowStyle

[FocusRowStyle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow): Enables/Disables the focus frame around the current row. (Default: `Thick`)

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)Icon

[Icon](https://docs.microsoft.com/en-us/dotnet/api/system.drawing.icon): Overrides the default Image property.

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)Item(id)

[SalTableColumn](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow): Returns the table column object with the specified column ID. The ID is 1-based.

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)Item(name)

[SalTableColumn](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow): Returns the table column object with the specified name.

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)LinesPerRow

[Int32](https://docs.microsoft.com/en-us/dotnet/api/system.int32): Number of lines per row.

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)ReadOnly

[Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.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`)

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)RowSizingStyle

[RowsSizingStyle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow): Keeps all rows of the same height. (Default: `FreeSize`)

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)ShowCellLabels

[Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.boolean): Gets or sets whether the grid should display labels over cells whose contents are partially hidden. (Default: `False`)

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)ShowCursor

[Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.boolean): Enables/Disables the arrow icon on the current row. (Default: `False`)

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)ShowFocusRow

[Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.boolean): Enables/Disables the focus frame around the current row. (Default: `True`)

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)TableWindow

[SalTableWindow](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow): Returns the internal table window control.

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)Trimming

[StringTrimming](https://docs.microsoft.com/en-us/dotnet/api/system.drawing.stringtrimming): Defines how to trim the content that doesn't fit the width of the cell. (Default: `None`)

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)UseNativeTypes

[Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.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.

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)UseVisualStyles

[Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.boolean): Enables/Disabled drawing of columns and rows headers using the current visual style theme renderer. (Default: `False`)

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)VirtualMode

[Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.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`)

## Methods

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)AnyRows(nFlagsOn, nFlagsOff)

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

| Parameter     | Type                                                                                                         | Description |
| ------------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **nFlagsOn**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **nFlagsOff** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)ClearSelection()

Deselects all rows of a table window.

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)ColumnAverage(columnID, flagsOn, flagsOff)

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

| Parameter    | Type                                                                                                         | Description |
| ------------ | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **columnID** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flagsOn**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flagsOff** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)ColumnSum(columnID, flagsOn, flagsOff)

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

| Parameter    | Type                                                                                                         | Description |
| ------------ | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **columnID** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flagsOn**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flagsOff** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)CopyRows(flagsOn, flagsOff)

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

| Parameter    | Type                                                                                                         | Description |
| ------------ | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **flagsOn**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flagsOff** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)CreateColumn(columnPos, dispWidth, maxChars, title)

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

| Parameter     | Type                                                                                                         | Description |
| ------------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **columnPos** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **dispWidth** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **maxChars**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **title**     | [SalString](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)CreateColumnEx(columnPos, dispWidth, title, maxChars, datatype)

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** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **dispWidth** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **title**     | [SalString](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **maxChars**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **datatype**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)DefineRowHeader(title, width, flags, column)

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

| Parameter  | Type                                                                                                         | Description |
| ---------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **title**  | [SalString](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **width**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flags**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **column** | [Control](https://docs.microsoft.com/en-us/dotnet/api/system.windows.forms.control)                          |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)DefineSplitWindow(rowsLowerHalf, dragAdjust)

Splits a table window horizontally.

| Parameter         | Type                                                                                                          | Description |
| ----------------- | ------------------------------------------------------------------------------------------------------------- | ----------- |
| **rowsLowerHalf** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)  |             |
| **dragAdjust**    | [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)DeleteRow(row, flag)

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

| Parameter | Type                                                                                                         | Description |
| --------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **row**   | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flag**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)DeleteSelected(hSql)

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

| Parameter | Type                                                                                                            | Description |
| --------- | --------------------------------------------------------------------------------------------------------------- | ----------- |
| **hSql**  | [SalSqlHandle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)DeleteSelected(hSql, errorHandler)

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

| Parameter        | Type                                                                                                                   | Description |
| ---------------- | ---------------------------------------------------------------------------------------------------------------------- | ----------- |
| **hSql**         | [SalSqlHandle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)        |             |
| **errorHandler** | [WhenSqlErrorHandler](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)DestroyColumns()

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](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)DoDeletes(hSql, flagsOn)

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

| Parameter   | Type                                                                                                            | Description |
| ----------- | --------------------------------------------------------------------------------------------------------------- | ----------- |
| **hSql**    | [SalSqlHandle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flagsOn** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)    |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)DoDeletes(hSql, flagsOn, errorHandler)

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

| Parameter        | Type                                                                                                                   | Description |
| ---------------- | ---------------------------------------------------------------------------------------------------------------------- | ----------- |
| **hSql**         | [SalSqlHandle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)        |             |
| **flagsOn**      | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)           |             |
| **errorHandler** | [WhenSqlErrorHandler](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)DoInserts(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**       | [SalSqlHandle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **clearFlags** | [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)   |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)DoInserts(hSql, clearFlags, errorHandler)

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

| Parameter        | Type                                                                                                                   | Description |
| ---------------- | ---------------------------------------------------------------------------------------------------------------------- | ----------- |
| **hSql**         | [SalSqlHandle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)        |             |
| **clearFlags**   | [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)          |             |
| **errorHandler** | [WhenSqlErrorHandler](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)DoUpdates(hSql, clearFlags)

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

| Parameter      | Type                                                                                                            | Description |
| -------------- | --------------------------------------------------------------------------------------------------------------- | ----------- |
| **hSql**       | [SalSqlHandle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **clearFlags** | [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)   |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)DoUpdates(hSql, clearFlags, errorHandler)

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

| Parameter        | Type                                                                                                                   | Description |
| ---------------- | ---------------------------------------------------------------------------------------------------------------------- | ----------- |
| **hSql**         | [SalSqlHandle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)        |             |
| **clearFlags**   | [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)          |             |
| **errorHandler** | [WhenSqlErrorHandler](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)FetchRow(row)

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**   | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)FindNextRow(row, flagsOn, flagsOff)

| Parameter    | Type                                                                                                          | Description |
| ------------ | ------------------------------------------------------------------------------------------------------------- | ----------- |
| **row**      | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flagsOn**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)  |             |
| **flagsOff** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)  |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)FindPrevRow(row, flagsOn, flagsOff)

| Parameter    | Type                                                                                                          | Description |
| ------------ | ------------------------------------------------------------------------------------------------------------- | ----------- |
| **row**      | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flagsOn**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)  |             |
| **flagsOff** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)  |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)GetColumnText(columnID, text)

| Parameter    | Type                                                                                                          | Description |
| ------------ | ------------------------------------------------------------------------------------------------------------- | ----------- |
| **columnID** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)  |             |
| **text**     | [SalString&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)GetColumnText(columnID)

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

| Parameter    | Type                                                                                                         | Description |
| ------------ | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **columnID** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalString](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)GetColumnWindow(col, flags)

Gets the handle of a table window column.

| Parameter | Type                                                                                                         | Description |
| --------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **col**   | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flags** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalWindowHandle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)GetContextRow()

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](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)GetLinesPerRow(lines)

| Parameter | Type                                                                                                          | Description |
| --------- | ------------------------------------------------------------------------------------------------------------- | ----------- |
| **lines** | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)GetLinesPerRow()

Retrieves the height of a row in lines.

**Returns:** [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)GetLockedColumns()

Retrieves the number of locked table window columns.

**Returns:** [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)GetMergedRange(row, col, clip)

Overrides GetMergedRange to allow the SalTableWindow class to override the method.

| Parameter | Type                                                                  | Description |
| --------- | --------------------------------------------------------------------- | ----------- |
| **row**   | [Int32](https://docs.microsoft.com/en-us/dotnet/api/system.int32)     |             |
| **col**   | [Int32](https://docs.microsoft.com/en-us/dotnet/api/system.int32)     |             |
| **clip**  | [Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.boolean) |             |

**Returns:** [CellRange](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)GetRowFlags(row, flags)

Queries a row's flags.

| Parameter | Type                                                                                                         | Description |
| --------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **row**   | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flags** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)GetTableFlags(flags)

Tests the state of a table window's flags.

| Parameter | Type                                                                                                         | Description |
| --------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **flags** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)HitTest(x, y, row, col, flags)

| Parameter | Type                                                                                                                | Description |
| --------- | ------------------------------------------------------------------------------------------------------------------- | ----------- |
| **x**     | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)        |             |
| **y**     | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)        |             |
| **row**   | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)       |             |
| **col**   | [SalWindowHandle&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flags** | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)       |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)InsertRow(row)

Inserts a new blank row into a table window.

| Parameter | Type                                                                                                         | Description |
| --------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **row**   | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)KillCellEdit()

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](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)KillFocusRow()

Turns off the table window's focus frame.

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)PasteRows()

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](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)Populate(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**   | [SalSqlHandle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **select** | [SalString](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)    |             |
| **method** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)    |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)Populate(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**         | [SalSqlHandle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)        |             |
| **select**       | [SalString](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)           |             |
| **method**       | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)           |             |
| **errorHandler** | [WhenSqlErrorHandler](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)Populate(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**   | [SalSqlHandle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **select** | [SalString](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)    |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)Populate(hSql, select, 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**         | [SalSqlHandle](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)        |             |
| **select**       | [SalString](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)           |             |
| **errorHandler** | [WhenSqlErrorHandler](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)QueryFocusCell(row, col)

| Parameter | Type                                                                                                                | Description |
| --------- | ------------------------------------------------------------------------------------------------------------------- | ----------- |
| **row**   | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)       |             |
| **col**   | [SalWindowHandle&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)QueryRowHeader(title, maxTitle, width, flags, col)

| Parameter    | Type                                                                                                                | Description |
| ------------ | ------------------------------------------------------------------------------------------------------------------- | ----------- |
| **title**    | [SalString&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)       |             |
| **maxTitle** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)        |             |
| **width**    | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)       |             |
| **flags**    | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)       |             |
| **col**      | [SalWindowHandle&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)QueryScroll(position, minRange, maxRange)

| Parameter    | Type                                                                                                          | Description |
| ------------ | ------------------------------------------------------------------------------------------------------------- | ----------- |
| **position** | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **minRange** | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **maxRange** | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)QuerySplitWindow(rowsLowerHalf, dragAdjust)

| Parameter         | Type                                                                                                           | Description |
| ----------------- | -------------------------------------------------------------------------------------------------------------- | ----------- |
| **rowsLowerHalf** | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)  |             |
| **dragAdjust**    | [SalBoolean&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)QueryVisibleRange(minRange, maxRange)

| Parameter    | Type                                                                                                          | Description |
| ------------ | ------------------------------------------------------------------------------------------------------------- | ----------- |
| **minRange** | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **maxRange** | [SalNumber&](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)ResetTable()

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

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)ScrollRow(row, column, flags)

Scrolls a table window to the specified row and column.

| Parameter  | Type                                                                                                         | Description |
| ---------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **row**    | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **column** | [Control](https://docs.microsoft.com/en-us/dotnet/api/system.windows.forms.control)                          |             |
| **flags**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)ScrollRow(row, column)

Scrolls a table window to the specified row and column.

| Parameter  | Type                                                                                                         | Description |
| ---------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **row**    | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **column** | [Control](https://docs.microsoft.com/en-us/dotnet/api/system.windows.forms.control)                          |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)SetColumnText(columnID, text)

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

| Parameter    | Type                                                                                                         | Description |
| ------------ | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **columnID** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **text**     | [SalString](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)SetContextRow(row)

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**   | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)SetFlagsAnyRows(flags, set, flagsOn, flagsOff)

Sets or clears row flags.

| Parameter    | Type                                                                                                          | Description |
| ------------ | ------------------------------------------------------------------------------------------------------------- | ----------- |
| **flags**    | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)  |             |
| **set**      | [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **flagsOn**  | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)  |             |
| **flagsOff** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)  |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)SetFocusCell(row, column, editMin, editMax)

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**     | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **column**  | [Control](https://docs.microsoft.com/en-us/dotnet/api/system.windows.forms.control)                          |             |
| **editMin** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **editMax** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)SetFocusRow(row)

Sets a table window's focus frame row.

| Parameter | Type                                                                                                         | Description |
| --------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **row**   | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)SetLinesPerRow(lines)

Sets the height of a row in lines.

| Parameter | Type                                                                                                         | Description |
| --------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **lines** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)SetLockedColumns(lockedColumns)

Sets the number of locked table window columns.

| Parameter         | Type                                                                                                         | Description |
| ----------------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **lockedColumns** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)SetRange(min, max)

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

| Parameter | Type                                                                                                         | Description |
| --------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **min**   | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **max**   | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)SetRow(rowPos)

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

| Parameter  | Type                                                                                                         | Description |
| ---------- | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **rowPos** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)SetRowFlags(row, flags, set)

Sets or clears a table window row's flags.

| Parameter | Type                                                                                                          | Description |
| --------- | ------------------------------------------------------------------------------------------------------------- | ----------- |
| **row**   | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)  |             |
| **flags** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)  |             |
| **set**   | [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)SetTableFlags(flags, set)

Sets or clears a table window's flags.

| Parameter | Type                                                                                                          | Description |
| --------- | ------------------------------------------------------------------------------------------------------------- | ----------- |
| **flags** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow)  |             |
| **set**   | [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

### ![](https://299326270-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7qefdGDqaAibSgFIaGI0%2Fuploads%2Fgit-blob-2389c55cd19719a73a5ae98e1528c8dc8525cc35%2Finstance.png?alt=media)SortRows(columnID, order)

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

| Parameter    | Type                                                                                                         | Description |
| ------------ | ------------------------------------------------------------------------------------------------------------ | ----------- |
| **columnID** | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **order**    | [SalNumber](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow).

## Inherited By

| Name                                                                                                                          | Description                      |
| ----------------------------------------------------------------------------------------------------------------------------- | -------------------------------- |
| [SalQuickToolTipTableWindow](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) | Pushbutton with tool tip support |

## Implements

| Name                                                                                                          | Description                                                                        |
| ------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------- |
| [ISalWindow](https://desktop-api.iceteagroup.com/ppj.runtime.49/forms/ppj.runtime.windows.salformtablewindow) | All Sal windows (Child windows, Forms, Dialogs and MDIs) implement this interface. |