SQL::Connection::InsertData()

Syntax

Rows_Added as N = <SQL::Connection>.InsertData( TableOwner as C, TableName as C, <ResultSet> as SQL::ResultSet [, EventScript as C [, ReplicateIdentity as L ]] )

Argument	Description
Rows_Added	The number of new rows added.
<SQL::Connection>	A SQL::Connection object.
TableOwner	The owner of the table.
TableName	The name of the table to receive the data.
<ResultSet>	A SQL::ResultSet object that contains transactions to apply.
EventScript	Optional. Default = "". An Xbasic Script implementing any of the following functions: UpdateBegin() UpdateProgress() UpdateEnd() In each case, the Context argument is the connection itself.
ReplicateIdentity	Optional. Default = .F.

Description

The InsertData() method adds new rows to a table in the currently connected database using a result set. Note: If ReplicateIdentity is set to .T., identity column values are included in the insert and must be supplied when the SQL is executed.

Supported By

Alpha Five Version 8 Enterprise Edition

Limitations

Desktop applications only.

Examples

Refer to SQL::Connection::BeginTransaction().