wwsql::SQLBuildInsertStatementFromObject

Creates a SQL INSERT string from a SCATTER NAME or EMPTY object.

o.SQLBuildInsertStatementFromObject(loData,lcTablename,loSQLRecord, llUseNamedParameters)

Return Value

String of the SQL INSERT statement or ""

Parameters

loData
SCATTER NAME type object that contains the field data to be inserted into the table.

lcTablename
The name of the table to insert to.

loSqlRecord
Optional - Instance of a record to compare to to determine which fields need to be updated.

llUseNamedParameters
Optional - defaults to .T. if not passed. When set uses Named parameters instead of SQL Literals (highly recommended).


See also:

Class wwsql

© West Wind Technologies, 2023 • Updated: 12/02/21
Comment or report problem with topic