Microsoft Dynamics AX (Archived)

Qbds or while select in table

(0) Share

Report

Posted on by @rp@n

Dear All,

Can you please let me know if i select table "LedgerTrans" like

1. While select ledgerTrans
where ... // put range

2. If i use QueryBuildDataSource to select LedgerTrans and pur Range

Then what actually happened in Particular table.
Please give me more shed on this.
Thanks!
Arpan Sen

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

André Arnaud de Cal... 299,373 Super User 2025 Season 2 on at

Like (0)

Report

RE: Qbds or while select in table

Hi Arpan,

There is no real difference in fetching the records. Both ways will be translated into SQL statements handled by the AX kernel.

It is a choice to use one of both methods.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

RE: Qbds or while select in table

Thanks Andre,

Was this reply helpful? Yes No
Martin Dráb 236,320 Most Valuable Professional on at

Like (0)

Report

RE: Qbds or while select in table

@rp@n, don't forget to mark the verified answer.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

RE: Qbds or while select in table

Hi Andre,

I know from some one that if i used qbds then it will only select those record based on the condition and if i select while select with condition then it will loop for whole table. So, qbds is much faster than while select.

Is't correct?

Thanks!

Arpan Sen

Was this reply helpful? Yes No
Verified answer

Martin Dráb 236,320 Most Valuable Professional on at

Like (1)

Report
RE: Qbds or while select in table

No, that's a nonsense. I think you confuse a while select with a condition:

while select table1 where table1.Field1 == 1

with a while select fetching all data without any condition and then ignoring some records in X++:

while select table1 { if (table1.Field1 == 1) ... }

If you compare the same queries, it will behave the same regardless if you use a select statement or the Query framework.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

RE: Qbds or while select in table

Thanks a lot Martin

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

RE: Qbds or while select in table

Hi Martin

I understand properly. Can you please let me know when we need to write qbds or while select in query. because both are behave same right?

Is there any specific reason to write qbds in code?

Please suggest me.

Thanks!

Arpan Sen

Was this reply helpful? Yes No
Verified answer

Martin Dráb 236,320 Most Valuable Professional on at

Like (0)

Report

RE: Qbds or while select in table

There are many reasons. For example, you want to work with an existing query, such as the one generated for form datasource. You want to generate a query dynamically based on business logic (select statemement is obviusly hard-coded and you can't change it as runtime). You want to create a base query and modify it at different places, You want to store the query in database for later use. And so on...

Was this reply helpful? Yes No

Community site session details

Qbds or while select in table

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Qbds or while select in table

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates