wwBusinessObject::execute

Executes a fully qualified raw SQL statement through the class. Can be used for any backend data command using either VFP syntax or SQLExec() style SQL commands.

o.Execute(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.


See also:

Class wwBusinessObject

© West Wind Technologies, 1996-2019 • Updated: 11/09/18
Comment or report problem with topic