wwsql::SqlBuildUpdateStatementFromObject

This method builds a SQL UPDATE string to be sent to the backend application from a SCATTER NAME type object. The object must contain a key field in order for this method to work.
o.SqlBuildUpdateStatementFromObject(loData,lcTablename,lcPKField)     

Return Value

Update command as a string or ""

Parameters

loData
A SCATTER NAME type object that contains the fields that are to be updated. The keyfield must be included in this data block.

lcTableame
The name of the SQL table to be updated.

lcPKField
The name of the PK field that is used to find the record to update. Defaults to "PK". Must be an Integer field.



Remarks

The PK field MUST be an integer in order for this function to work.

See also:

Class wwsql


  Last Updated: 05/03/01 | © West Wind Technologies, 1996-2010