In the classic version we could run tables straight from the object designer and the object designer was always included in the client. In the Role Tailored Client (RTC) however we don’t have an object designer. Instead it is located in the developement environment. But sometimes you need to run a table but you don’t have access to the development environment (end user computer, ClickOnce and so on..).
So what to do then?
In the pre RTC versions of Dynamics NAV it was really simple to run/view objects from the client. Nowadays when we are using RTC it is not quite that simple since by standard we don’t have object designer in RTC (Role Tailored Client). At least yet 🙂
But there is a trick that you can use to achieve this. You need to create a page on the table object. After that add a button that runs the current record. Microsoft described this a couple of years ago in a blog post (How to start any object in Role Tailored Client)
But how about tables and querys?
The last couple of years I have started to use an new trick to make my everyday life with Dynamics NAV easier.
Usually I have the problems like this:
For me the solution became to make a page on the virtual table field (How to: Create a Page to View a Virtual Table).This is real handy when you have an addon table with 355 fields were the captions don’t really match the field names.
Earlier today I wrote a blog post XMLPort: Export from temporary tables. The principle is the same when you want to import to a temporary table. Instead of calling a function in XMLPort before you call the export that inserts values into the temporary table you do the opposite, call a function after the import has completed that copies all the temporary data to your temporary record parameter.  Read the rest of this entry »
You can export data from tables to XML by using XMLPorts. But you can also use XMLPorts to export data from temporary tables.
The principle is to set the Temporary property on the table line and then create a function in XMLPort that inserts all the data into the temporary record.
Tips and news for AL programmers
Dynamics 365 Business Central
Thoughts about Dynamics 365 Business Central, Git, Azure DevOps, PowerShell, Automated Testing, Visual Studio Code...and maybe some other stuff
MVP & MCT Microsoft Dynamics 365 Business Central, Powershell, Azure, SQL Server
DevOps starts with culture!
Reflections from the ERP field
Reflections from the ERP field
Reflections from the ERP field
Learn something new... - then Teach someone!
Reflections from the ERP field
Micosoft Dynamics NAV Performance Testing & Optimization
Reflections from the ERP field
Design Patterns, Performance, Clean Code
Ideas in the cloud
Reflections from the ERP field
Reflections from the ERP field
- Sharing my experience in the Dynamics NAV world
Reflections from the ERP field
Its Really Fun to Work with Microsoft Dynamics Nav / D365 Business Central
NAVfreak 