# SalFormTableWindow

Namespace: **PPJ.Runtime.Windows**

Assembly: **PPJ.Web.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://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)SalFormTableWindow()

Constructs a SalFormWindow object.

## Properties

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)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://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)AllowRowSizing

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

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)AllowSorting

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

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)Columns

[SalTableColumnCollection](https://docs.wisej.com/extensions/ppj.web.49/controls/saltablewindow/ppj.runtime.windows.saltablecolumncollection.md): Returns the collection of columns.

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)DisableSplitGrid

[Boolean](https://docs.microsoft.com/en-us/dotnet/api/system.boolean): Prevents the split grid from getting the focus while allowing for he horizontal scroll and column resizing. (Default: `False`)

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)Item(id)

[SalTableColumn](https://docs.wisej.com/extensions/ppj.web.49/controls/saltablewindow/ppj.runtime.windows.saltablecolumn.md): Returns the table column object with the specified column ID. The ID is 1-based.

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)Item(name)

[SalTableColumn](https://docs.wisej.com/extensions/ppj.web.49/controls/saltablewindow/ppj.runtime.windows.saltablecolumn.md): Returns the table column object with the specified name.

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)LinesPerRow

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

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)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://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)RowSizingStyle

[RowsSizingStyle](https://docs.wisej.com/extensions/ppj.web.49/controls/saltablewindow/ppj.runtime.windows.rowssizingstyle.md): Keeps all rows of the same height. (Default: `FreeSize`)

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)TableWindow

[SalTableWindow](https://docs.wisej.com/extensions/ppj.web.49/controls/saltablewindow/saltablewindow/README.md): Returns the internal table window control.

## Methods

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)AnyRows(nFlagsOn, nFlagsOff)

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

| Parameter     | Type                                                                                     | Description |
| ------------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nFlagsOn**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nFlagsOff** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)BeginUpdate()

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

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)ClearSelection()

Deselects all rows of a table window.

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)ColumnAverage(nColumnID, nFlagsOn, nFlagsOff)

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

| Parameter     | Type                                                                                     | Description |
| ------------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nColumnID** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nFlagsOn**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nFlagsOff** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)ColumnSum(nColumnID, nFlagsOn, nFlagsOff)

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

| Parameter     | Type                                                                                     | Description |
| ------------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nColumnID** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nFlagsOn**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nFlagsOff** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)CopyRows(nFlagsOn, nFlagsOff)

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

| Parameter     | Type                                                                                     | Description |
| ------------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nFlagsOn**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nFlagsOff** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)CreateColumn(nColumnPos, nDispWidth, nMaxChars, sTitle)

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

| Parameter      | Type                                                                                     | Description |
| -------------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nColumnPos** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nDispWidth** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nMaxChars**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **sTitle**     | [SalString](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salstring.md) |             |

**Returns:** [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)CreateColumnEx(nColumnPos, nDispWidth, sTitle, nMaxChars, nDatatype)

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 |
| -------------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nColumnPos** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nDispWidth** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **sTitle**     | [SalString](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salstring.md) |             |
| **nMaxChars**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nDatatype**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)DefineRowHeader(sTitle, nWidth, nFlags, column)

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

| Parameter  | Type                                                                                     | Description |
| ---------- | ---------------------------------------------------------------------------------------- | ----------- |
| **sTitle** | [SalString](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salstring.md) |             |
| **nWidth** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nFlags** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **column** | [Control](https://docs.wisej.com/api?q=wisej.web.control)                                |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)DefineSplitWindow(nRowsLowerHalf, bDragAdjust)

Splits a table window horizontally.

| Parameter          | Type                                                                                       | Description |
| ------------------ | ------------------------------------------------------------------------------------------ | ----------- |
| **nRowsLowerHalf** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)   |             |
| **bDragAdjust**    | [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)DeleteRow(nRow, nFlag)

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

| Parameter | Type                                                                                     | Description |
| --------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nRow**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nFlag** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)DeleteSelected(hSql)

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

| Parameter | Type                                                                                             | Description |
| --------- | ------------------------------------------------------------------------------------------------ | ----------- |
| **hSql**  | [SalSqlHandle](https://docs.wisej.com/extensions/ppj.web.49/sql/ppj.runtime.sql.salsqlhandle.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)DeleteSelected(hSql, errorHandler)

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

| Parameter        | Type                                                                                                           | Description |
| ---------------- | -------------------------------------------------------------------------------------------------------------- | ----------- |
| **hSql**         | [SalSqlHandle](https://docs.wisej.com/extensions/ppj.web.49/sql/ppj.runtime.sql.salsqlhandle.md)               |             |
| **errorHandler** | [WhenSqlErrorHandler](https://web-api.iceteagroup.com/ppj.web.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)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://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)DoDeletes(hSql, nFlagsOn)

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

| Parameter    | Type                                                                                             | Description |
| ------------ | ------------------------------------------------------------------------------------------------ | ----------- |
| **hSql**     | [SalSqlHandle](https://docs.wisej.com/extensions/ppj.web.49/sql/ppj.runtime.sql.salsqlhandle.md) |             |
| **nFlagsOn** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)         |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)DoDeletes(hSql, nFlagsOn, errorHandler)

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

| Parameter        | Type                                                                                                           | Description |
| ---------------- | -------------------------------------------------------------------------------------------------------------- | ----------- |
| **hSql**         | [SalSqlHandle](https://docs.wisej.com/extensions/ppj.web.49/sql/ppj.runtime.sql.salsqlhandle.md)               |             |
| **nFlagsOn**     | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)                       |             |
| **errorHandler** | [WhenSqlErrorHandler](https://web-api.iceteagroup.com/ppj.web.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)DoInserts(hSql, bClearFlags)

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://docs.wisej.com/extensions/ppj.web.49/sql/ppj.runtime.sql.salsqlhandle.md) |             |
| **bClearFlags** | [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md)       |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)DoInserts(hSql, bClearFlags, 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://docs.wisej.com/extensions/ppj.web.49/sql/ppj.runtime.sql.salsqlhandle.md)               |             |
| **bClearFlags**  | [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md)                     |             |
| **errorHandler** | [WhenSqlErrorHandler](https://web-api.iceteagroup.com/ppj.web.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)DoUpdates(hSql, bClearFlags)

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

| Parameter       | Type                                                                                             | Description |
| --------------- | ------------------------------------------------------------------------------------------------ | ----------- |
| **hSql**        | [SalSqlHandle](https://docs.wisej.com/extensions/ppj.web.49/sql/ppj.runtime.sql.salsqlhandle.md) |             |
| **bClearFlags** | [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md)       |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)DoUpdates(hSql, bClearFlags, errorHandler)

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

| Parameter        | Type                                                                                                           | Description |
| ---------------- | -------------------------------------------------------------------------------------------------------------- | ----------- |
| **hSql**         | [SalSqlHandle](https://docs.wisej.com/extensions/ppj.web.49/sql/ppj.runtime.sql.salsqlhandle.md)               |             |
| **bClearFlags**  | [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md)                     |             |
| **errorHandler** | [WhenSqlErrorHandler](https://web-api.iceteagroup.com/ppj.web.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)EndUpdate()

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

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)FetchRow(nRow)

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 |
| --------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nRow**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)FindNextRow(nRow, nFlagsOn, nFlagsOff)

| Parameter     | Type                                                                                                  | Description |
| ------------- | ----------------------------------------------------------------------------------------------------- | ----------- |
| **nRow**      | [SalNumber&](https://web-api.iceteagroup.com/ppj.web.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **nFlagsOn**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)              |             |
| **nFlagsOff** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)              |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)FindPrevRow(nRow, nFlagsOn, nFlagsOff)

| Parameter     | Type                                                                                                  | Description |
| ------------- | ----------------------------------------------------------------------------------------------------- | ----------- |
| **nRow**      | [SalNumber&](https://web-api.iceteagroup.com/ppj.web.49/forms/ppj.runtime.windows.salformtablewindow) |             |
| **nFlagsOn**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)              |             |
| **nFlagsOff** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)              |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)GetColumnText(nColumnID, sText)

| Parameter     | Type                                                                                                  | Description |
| ------------- | ----------------------------------------------------------------------------------------------------- | ----------- |
| **nColumnID** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)              |             |
| **sText**     | [SalString&](https://web-api.iceteagroup.com/ppj.web.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)GetColumnText(nColumnID)

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

| Parameter     | Type                                                                                     | Description |
| ------------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nColumnID** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalString](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salstring.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)GetColumnWindow(nCol, nFlags)

Gets the handle of a table window column.

| Parameter  | Type                                                                                     | Description |
| ---------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nCol**   | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nFlags** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalWindowHandle](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salwindowhandle.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)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://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)GetLinesPerRow(nLines)

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

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)GetLinesPerRow()

Retrieves the height of a row in lines.

**Returns:** [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)GetLockedColumns()

Retrieves the number of locked table window columns.

**Returns:** [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)GetRowFlags(nRow, nFlags)

Queries a row's flags.

| Parameter  | Type                                                                                     | Description |
| ---------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nRow**   | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nFlags** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)GetTableFlags(nFlags)

Tests the state of a table window's flags.

| Parameter  | Type                                                                                     | Description |
| ---------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nFlags** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)InsertRow(nRow)

Inserts a new blank row into a table window.

| Parameter | Type                                                                                     | Description |
| --------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nRow**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)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://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)KillFocusRow()

Turns off the table window's focus frame.

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)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://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)Populate(hSql, sSelect, nMethod)

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://docs.wisej.com/extensions/ppj.web.49/sql/ppj.runtime.sql.salsqlhandle.md) |             |
| **sSelect** | [SalString](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salstring.md)         |             |
| **nMethod** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)         |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)Populate(hSql, sSelect, nMethod, 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://docs.wisej.com/extensions/ppj.web.49/sql/ppj.runtime.sql.salsqlhandle.md)               |             |
| **sSelect**      | [SalString](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salstring.md)                       |             |
| **nMethod**      | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)                       |             |
| **errorHandler** | [WhenSqlErrorHandler](https://web-api.iceteagroup.com/ppj.web.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)Populate(hSql, sSelect)

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://docs.wisej.com/extensions/ppj.web.49/sql/ppj.runtime.sql.salsqlhandle.md) |             |
| **sSelect** | [SalString](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salstring.md)         |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)Populate(hSql, sSelect, 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://docs.wisej.com/extensions/ppj.web.49/sql/ppj.runtime.sql.salsqlhandle.md)               |             |
| **sSelect**      | [SalString](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salstring.md)                       |             |
| **errorHandler** | [WhenSqlErrorHandler](https://web-api.iceteagroup.com/ppj.web.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)QueryFocusCell(nRow, hWndCol)

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

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)QueryRowHeader(sTitle, nMaxTitle, nWidth, nFlags, hWndCol)

| Parameter     | Type                                                                                                        | Description |
| ------------- | ----------------------------------------------------------------------------------------------------------- | ----------- |
| **sTitle**    | [SalString&](https://web-api.iceteagroup.com/ppj.web.49/forms/ppj.runtime.windows.salformtablewindow)       |             |
| **nMaxTitle** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)                    |             |
| **nWidth**    | [SalNumber&](https://web-api.iceteagroup.com/ppj.web.49/forms/ppj.runtime.windows.salformtablewindow)       |             |
| **nFlags**    | [SalNumber&](https://web-api.iceteagroup.com/ppj.web.49/forms/ppj.runtime.windows.salformtablewindow)       |             |
| **hWndCol**   | [SalWindowHandle&](https://web-api.iceteagroup.com/ppj.web.49/forms/ppj.runtime.windows.salformtablewindow) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)QueryScroll(nPosition, nMinRange, nMaxRange)

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

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)QuerySplitWindow(nRowsLowerHalf, bDragAdjust)

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

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)QueryVisibleRange(nMinRange, nMaxRange)

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

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)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://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)ScrollRow(nRow, column, nFlags)

Scrolls a table window to the specified row and column.

| Parameter  | Type                                                                                     | Description |
| ---------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nRow**   | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **column** | [Control](https://docs.wisej.com/api?q=wisej.web.control)                                |             |
| **nFlags** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)ScrollRow(nRow, column)

Scrolls a table window to the specified row and column.

| Parameter  | Type                                                                                     | Description |
| ---------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nRow**   | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **column** | [Control](https://docs.wisej.com/api?q=wisej.web.control)                                |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)SetColumnText(nColumnID, sText)

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

| Parameter     | Type                                                                                     | Description |
| ------------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nColumnID** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **sText**     | [SalString](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salstring.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)SetContextRow(nRow)

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 |
| --------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nRow**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)SetFlagsAnyRows(nFlags, bSet, nFlagsOn, nFlagsOff)

Sets or clears row flags.

| Parameter     | Type                                                                                       | Description |
| ------------- | ------------------------------------------------------------------------------------------ | ----------- |
| **nFlags**    | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)   |             |
| **bSet**      | [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md) |             |
| **nFlagsOn**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)   |             |
| **nFlagsOff** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)   |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)SetFocusCell(nRow, column)

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 |
| ---------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nRow**   | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **column** | [Control](https://docs.wisej.com/api?q=wisej.web.control)                                |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)SetFocusRow(nRow)

Sets a table window's focus frame row.

| Parameter | Type                                                                                     | Description |
| --------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nRow**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)SetLinesPerRow(nLines)

Sets the height of a row in lines.

| Parameter  | Type                                                                                     | Description |
| ---------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nLines** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)SetLockedColumns(nLockedColumns)

Sets the number of locked table window columns.

| Parameter          | Type                                                                                     | Description |
| ------------------ | ---------------------------------------------------------------------------------------- | ----------- |
| **nLockedColumns** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)SetRange(nMin, nMax)

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

| Parameter | Type                                                                                     | Description |
| --------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nMin**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nMax**  | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)SetRow(nRowPos)

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

| Parameter   | Type                                                                                     | Description |
| ----------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nRowPos** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)SetRowFlags(nRow, nFlags, bSet)

Sets or clears a table window row's flags.

| Parameter  | Type                                                                                       | Description |
| ---------- | ------------------------------------------------------------------------------------------ | ----------- |
| **nRow**   | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)   |             |
| **nFlags** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)   |             |
| **bSet**   | [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)SetTableFlags(nFlags, bSet)

Sets or clears a table window's flags.

| Parameter  | Type                                                                                       | Description |
| ---------- | ------------------------------------------------------------------------------------------ | ----------- |
| **nFlags** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md)   |             |
| **bSet**   | [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

### ![](https://620403885-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrwxBtXkZ9hhQWYdbGhAV%2Fuploads%2FCKg4odMPj9bBKavXG5j4%2Finstance.png?alt=media\&token=2ac4a01b-785e-4197-b802-d5aae2250f90)SortRows(nColumnID, nOrder)

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

| Parameter     | Type                                                                                     | Description |
| ------------- | ---------------------------------------------------------------------------------------- | ----------- |
| **nColumnID** | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |
| **nOrder**    | [SalNumber](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salnumber.md) |             |

**Returns:** [SalBoolean](https://docs.wisej.com/extensions/ppj.web.49/types/ppj.runtime.salboolean.md).

## Implements

| Name                                                                                                    | Description                                                                        |
| ------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------- |
| [ISalWindow](https://docs.wisej.com/extensions/ppj.web.49/interfaces/ppj.runtime.windows.isalwindow.md) | All Sal windows (Child windows, Forms, Dialogs and MDIs) implement this interface. |