AppendPkFromId Method

Member of ISSqlWhereBuilder
Appends a Primary Key to the SQL Where clause based upon the Id of a Foreign table.

Use where a Global collection is NOT available.

Syntax

ISSqlWhereBuilder.AppendPkFromId(fieldName, foreignTableName, foreignTableId)

Parameters

NameTypeOptionalByRefDescription
fieldName String The name of the field in the current table including the table name, e.g. AccountTransaction.TaxPeriodPk.
foreignTableName String The Foreign table.
foreignTableId String The Foreign table's Id.
Member of:
ISSqlWhereBuilder
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0