July 22, 2021

QuickFix: Delete command button doesn't work as expected

Scenario: I've created a form with multiple data sources, one of the tab pages needs its own new, delete button. (Can not use design property). When adding command buttons for New and delete, New works fine but delete doesn't. 

Possible reason: There is a lot of commands which start with Delete, and probably you have chosen the 'Delete' command, while you need to choose 'Delete record' as this button spouse to delete a record (or multiple records). Try this.

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

June 21, 2021

[Solved] SECURITYROLEPRIVILEGERESOURCELICENSEMAP DB sync error

Hi Folks,

The other day I was getting errors while doing build and DB sync. This error is quite strange when looking at the details in the Error List pane. Below is the error message(s).

Error message:

         

 

 

If you succeed to get some details from this error message 😊, you will see the issue with SECURITYROLEPRIVILEGERESOURCELICENSEMAP while you won’t get anything in AOT with this name.





 

 





Let’s try the SQL then. Open the SSMS and select AxDB then searches for dbo. SECURITYROLEPRIVILEGERESOURCELICENSEMAP and right-click to see the design. You may get some additional fields here, ideally, there should be below seven fields, (you should be double sure if anyone else in your team added anything)

And delete any additional fields from here.

 



 





Save your changes and go back to Visual Studio and try to do build and DB synch. It should work.


Enjoy!!!

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta