RDTA.PickDP.Extensions.table Control

The table control represents a single table in a database. This control enumerates connection objects located on an MDI form and on local or SDI forms, allowing you to create SDI or just-in-time (non-persistent) MDI/SDI applications. The table control displays a list of all local and global connection controls found in the active project.

Public Constructors

New

Constructor.

Public Methods

close

Closes the table.

deleteItem

Deletes an item from the table.

FillCombo

Fills the specified combo boxes associated with this table.

FillListBox

Fills the specified list boxes associated with this table.

getConnection

Gets the connection Object to access to the database.

getDatabase

Gets the connDatabase Object that is accessed by the table.

getFieldNames

Returns the names of the fields in the table.

getItem

Gets an item from the table.

getNoExist

Gets the read status of the item being read.

getTable

Returns the connTable representing this table.

isConnected

Returns the connection status.

isLocked

Returns the locking status of the item being read.

isOpen

Returns whether the table is open or closed.

MemberwiseClone

Returns a copy of the current instance. For internal use only.

open

Opens the table. The table name to open is indicated by the TableName property. All bindings using the table must be established before the table is opened.

release

Releases locks of all items for the current table.

releaseId

Releases the lock for the current item.

setConnection

Sets the connection Object of the table.

setconnTable

Sets the connTable Object. Provides the ability to change data source (connTable) at runtime.

setItem

Writes an item to the table.

Public Properties

Name

Type

Description

Connection

RDTA.PickDP.Extensions.connection

Gets or sets the connection.

ConnectionName

String

Gets or sets the connection name.

IsLocalConnection

Boolean

When creating an MDI application, you can add a connection control to the MDI form or any SDI (child) form. This property:

  • returns True when the connector control used exists on the current SDI form.

  • returns False when the connector control used exists on the MDI form.

LockType

String

Gets or sets the lock type.

SubTableName

String

Gets or sets the subtable name (data section).

TableName

String

Gets or sets the table name.

Public Events

Name

Type

Description

onAfterDelete

Event

Event triggered after a delete.

onAfterOpen

Event

Event triggered after an open.

onAfterRead

Event

Event triggered after a read.

onAfterWrite

Event

Event triggered after a write.

onBeforeDelete

Event

Event triggered before a delete.

onBeforeOpen

Event

Event triggered before an open.

onBeforeRead

Event

Event triggered before a read.

onBeforeWrite

Event

Event triggered before a write

onRecordLocked

Event

Event triggered when attempting to read, write, or delete a locked record.

onRecordNotExist

Event

Event triggered when attempting to read a record that does not exist.

 

5