QueryBuildRange object not initialized

(1) Share

Report

Posted on by Jesús García

619

Hi, I got the following message when cleaning up and adding some ranges to a formdatasource

The code where this case occurs is as follows:

I have observed that if I comment the line clearRanges the error disappears and performs its function, since the purpose of this code is to enter a form and add to its datasource ranges. However, I find it strange that this error occurs, because I have done this same process many times before for other forms and I have not got this error.

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Suggested answer

Waed Ayyad 9,212 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

I noticed something on your code. Why you define fds and then use queryWHSWaveTable = fds.queryBuildDataSource();

You can use queryWHSWaveTable = FormRun.add(FormDatasourceStr(WHSWaveTableListPage, WHSWaveTable);

When you debug the code, did you sure t that this line fds= FormRun.add(FormDatasourceStr(WHSWaveTableListPage, WHSWaveTable); not null?

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Layan Jwei 8,280 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

What method are you using?

Was this reply helpful? Yes No
Jesús García 619 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello @Waed, thank you for the information you have provided. I'll tell you in parts:
1- I use FormDataSource to save the datasource that initially has the form and clean the ranges that it adds in a standard way and then add mine.
2- I have tried the FormRun.add method and when I launch it, the compiler informs me that this method does not exist in the FormRun.

Was this reply helpful? Yes No
Jesús García 619 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Lawan, its the clicked method from a Tile Button

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,212 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

You mean you need to get the current Query on your form DataSource?

You can add the following:

fds = YourDataSourceName_ds.Query().dataSourceTable(tablenum(YourTable));
Or
queryWHSWaveTable = YourDataSourceName_ds.Query().dataSourceTable(tablenum(YourTable));
Use one variable for QueryBuildDatasource fds or queryWHSWaveTable . No need for this line queryWHSWaveTable = fds.queryBuildDataSource();

Don't forget to continue the code based on the chosen variable.

Also see the following link:

https://learn.microsoft.com/en-us/previous-versions/dynamicsax-2012/developer/how-to-access-the-active-query-on-forms

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Jesús García 619 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Waed, I understand what you are showing me but my case is peculiar, let me explain:
I have a form with a certain amount of Tiles Button. These tiles button show a counter from a query that I launch by doing an override of the getData method. The Tile button allows you, when you click on it, to enter the form it refers to. Then, so that, when you enter the form, it filters the same as in the previously mentioned query, I make an override of the clicked method and call the form from the code (that's why I have the code shown above). And as I said, I have replicated this code in other Tiles button and it has not given me any kind of problem, it has worked correctly, but in this case it has not.

Was this reply helpful? Yes No
Verified answer

Waed Ayyad 9,212 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

1-I got your point, but I think you can do it in another way you can clear the ranges on the init of the form that will open when you click on the tile.

if(element.args()&& element.args().menuItemName() == menuitemdisplaystr(YoueMenuItemName)) { YourDataSource_ds.queryBuildDataSource() }

2- Try to change copy caller query property to No on the Display Menu Item, but you should make sure the menu item is only used only on this place.

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No