X++:
Query query = new Query();
QueryRun queryRun;
QueryBuildDataSource qbds;
;
qbds = query.addDataSource(tableNum(RContractTable));
qbds.addRange(fieldNum(RContractTable, RContractAccount)).value(PayRequestTable.RContractAccount);
queryRun = new QueryRun(query);
if (queryRun.next())
{
info("true");
}
else if (!queryRun.next())
{
info("false");
}