Announcements
Hi Friends,
queryRun.get(tablenum(xx)) return a single record or a recordset?
If I want a recordset, what should I do? Since I need to store it for later use.
Thanks,
*This post is locked for comments
It returns a single record. You get another record by calling queryRun.next().
You can either fetch records individually and store them somewhere, or you can simply save the query definition and run it later.
Thanks Maritn,
So, there is no recrodsetj/dataset in AX. If I want to store it, store it in Container?
The queryRun object does return a dataset in quite that way but you could iterate over it and store each returned record into a RecordLinkList object (msdn.microsoft.com/.../recordlinklist.aspx) if you want to pass the whole result set around...or you could just pass the query and re-execute it.
It depends. You can put it into a in-memory collection (RecordInsertList, List, etc.) if it's small enough, to a temporary table (in TempDB, in memory or on disk) or do anything else that makes sense in your particular scenario. Just be careful about not wasting resources, especially memory.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 21
Harisgillani 4
dekion 4
