SetKeyFields

For a given table, this function will contain the list of keys to be used in the internal Where clause when updating a table.

Group: Embedded Procedure Object

Syntax:   [bValue] = emProc.SetKeyFields(ParamArray)

bValue         (Boolean) Optional – returns the success or failure of the command

ParamArray  (param array of Variants) the name of each key for the table in quotes and separated by a comma

Example:

Dim emCUSTOMERS As New EmbeddedProc

emCUSTOMERS.Name = "CUSTOMERS"

emCUSTOMERS.DataSource = "RFSample"

emCUSTOMERS.Param("CUSTID") = 1001

emCUSTOMERS.Param("HOSTID") = "A1"

emCUSTOMERS.Param("NAME") = "Microsoft"

emCUSTOMERS.SetKeyFields("CUSTID", "HOSTID")

emCUSTOMERS.ExecuteMethod("update")