IAPI::SQLite_buildUpdateCommand

property SQLite_buildUpdateCommand.

Builds DML command for updating columns:

UPDATE <table> SET field1='val1', field2='Val2,…'fieldN='ValN') [WHERE <Clause>];

HRESULT SQLite_buildUpdateCommand(
 BSTR SQliteTable,
 long hStringFieldTable,
 long hStringValueTable,
 BSTR WhereClause,
 BSTR *pVal
);

Parameters

SQliteTable

[in] . SQL table name

hStringFieldTable

[in] . String table containing SQL field names, created by MallocStringTable().

hStringValueTable

[in] . String table containing values to update, created by MallocStringTable().

WhereClause

[in] . SQL clause WHERE which limits updating operation.

pVal

[out, retval] The returned value is a BSTR string formated as a SQL statement.

Return Values

S_OK

The operation was successfull.

E_POINTER

A NULL pointer was supplied as an argument.

E_UNEXPECTED

An unexpected error occoured.

See Also

IAPI