wwBusinessObject::ExecuteNonQuery
wwBusinessObject::ExecuteNonQuery
Executes a fully qualified raw SQL statement through the class that doesn't return a cursor. Can be used for backend commands like INSERT, Update or stored procedure calls etc.
o.ExecuteNonQuery(lcSQL)
Return Value
Record count or 0. Check .lError for any hard errors.
Parameters
lcSQL
Raw SQL command to be executed by the data engine. This can be any command the backend will understand. For VFP data this means any VFP command that can be macro'd. For SQL Server any Transact SQL command.
Remarks
You can pass multi-line SQL statements without ; at the end of each line and this method will flatten the SQL statement to a single line when executing against the FoxPro data engine. This is useful for creating SQL Commands as strings in
TEXT/ENDTEXTblocks.
See also:
Class wwBusinessObject
Comment or report problem with topic