I have a need to be able to dynamically build a query in X++. I can do so and make it work. My question is:
Is there any way, using the Query classes, to get the entire result set in 1 buffer. I understand the:
While(queryRun.Next())
{
common = queryRun.get(tableName2Id('InventTable'));
}
but this just does it record by record. I am wanting the entire result table at once. Any ideas? I have been searching for a long time.
Thanks
*This post is locked for comments