How do I check if a record exists in X++?

Question

Answer 1

SSunny Vasty75 reputation · answered Aug 13, 2026

Use firstOnly and check RecId.

SalesTable salesTable;

select firstOnly RecId from salesTable
    where salesTable.SalesId == 'SO-000001';

if (salesTable.RecId)
{
    info('Record exists.');
}

If existence is all you care about, only select the field you actually need.

1 answer

Know the solution?