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.

If an MDI is created with a child form, and a table with a DBDataBinder is created on the child form, the code to open the table is created automatically by PickDP. If the table and databinder are created directly on an SDI form, a manual table.open must be executed for the databinder to fill properly.

Public Constructors

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.

RDTA.PickDP.Extensions.table Control

Public Constructors

Public Methods

Public Properties

Public Events

Example