MS SQL Tables - all fields are selected, regardless of actual field selection

Hi,

When creating or updating an MS SQL data source, it seems that all fields within a selected table are being selected even when only a few fields are actually ticked on.
Initially, it looks like only the selected fields are checked on, but if you go back and look again, you find that all fields are checked.
Or if you try to create CRUD pages, you find that all fields are included.

It works correctly within MS SQL Views, but not MS SQL Tables.
I’m using 1.33.6.
I think it used to work a few versions ago, but I’m not certain.

Thanks,
John Semmens

Hi John,

When you create MS SQL data source all tables are initially selected:

when you edit the data source, Radzen will load all previously saved data and if you've not unchecked some of the tables they will be loaded as checked again.

If you uncheck some of the tables however and save on the next load you will see only previously checked:

Best Regards,
Vladimir

Hi John,

You are right! Unchecked table fields are always restored while the same for views will work correctly. We will provide fix for this early next week!

Best Regards,
Vladimir

Thanks Vladimir.

Best regards,
John Semmens

Hi John,

We’ve just released Radzen 1.33.7 with fix for this issue included.

Best Regards,
Vladimir

Thanks Vladimir.
Best regards,
John