AppendComparisonStringWithPk Method

Member of ISSqlWhereBuilder
Append a Range to the SQL Where clause where the Range does not apply to a field in the current table but a field in another table where the main table just holds the primary key.

<example> <para> If you wanted to compare the CreateUser on the Client table and the Client table only holds the primary key field of the User you would do something like this: </para> <para> AppendComparisonStringWithPk("Client.UserPk", "User", "UserId", "Pk", "=", "Admin") </para> </example>

Syntax

ISSqlWhereBuilder.AppendComparisonStringWithPk(pkFieldName, remoteTableName, remoteFieldName, remotePkFieldName, operator, value)

Parameters

NameTypeOptionalByRefDescription
pkFieldName String The name of the Pk field in the current table including the table name, e.g. Client.CreatedUserPk.
remoteTableName String The table in which the Range field exists, e.g. User.
remoteFieldName String The field name to compare to in the remote table i.e. the Id field, NOT the Pk field, e.g. UserId.
remotePkFieldName String The name of the Pk field in the remote table, e.g. Pk.
operator String
value String The Range.
Member of:
ISSqlWhereBuilder
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0