HOW TO show BigText in a message window in C/AL

According to the MSDN documentation in the link BigText Data Type

"cannot be shown in a message window"

This example requires that you create the following variables:

Name DataType Subtype
varBigText BigText

It is true that you cannot insert the BigText in a message

MESSAGE(varBigText);

HOW TO show BigText in a message window in C/AL?

You can show the content of the variable easily using the FORMAT Function (Code, Text) to convert the BigText in a String.

MESSAGE(FORMAT(varBigText));

Did my HOW TO help you? Leave a reply.

HOW TO check and install Xamarin updates in Visual Studio

Probably a message has been shown to you in Visual Sutdio about a new version of Xamarin.

HOW TO check and install Xamarin updates in Visual Studio?

Navigate the Visual Studio menu Tools -> Options…
visual-studio-menu-tools-options

then Xamarin -> Other and click the link Check Now
options-xamarin-other-check-now

Did my HOW TO help you? Leave a reply.

Page contains several Actions with the same ID

Microsoft Dynamics NAV
—————————
Page {PageNo} {PageName} contains several Actions with the same ID {ActionID}. Redesign the page to remove duplicate Action IDs.
—————————
OK
—————————

contains several Actions with the same ID

Solution:
Delete lines for page in the error from the 2000000074 Profile Metadata system table.

Did my solution solve your problem? Leave a comment.

Adobe Flash Player has stopped potentially unsafe operation

Recently I did a training with materials offline using Adobe Flash.

Sources are usually in a compressed file or a CD/DVD drive, and when I ran the starting web page using Microsoft Internet Explorer I’ve received the following error message:

Adobe Flash Player Security

Adobe Flash Player has stopped a potentially unsafe operation.

The following local application on your computer or network:
{PATH}
is trying to communicate with this Internet-enabled location:
{PATH}

To let this application communicate with the Internet, click Settings.
You must restart the application after changing your settings.
OK Settings…

Adobe Flash Player has stopped potentially unsafe operation

Note:

  1. This error message appeared only using Microsoft Internet Explorer and NOT with Google Chrome.
  2. Unfortunately clicking the button Settings the error message disappears without show any configuration screen and to receive again the error I have to close the browser and re-open it.

Cause:
As the error message itself is saying, Adobe Flash player stopped the operation because a local file wants to communicate with an “Internet-enabled location” that in our case is local but it could be on internet and for this reason dangerous (“unsafe operation”).

Adobe Flash Player has stopped potentially unsafe operation

Solution:

  1. Access to the local Flash Player Settings Manager (click Start > Settings > Control Panel > Flash Player)
    Adobe Flash Player Settings Manager
  2. click the Advanced tab then on Trusted Location Settings
    Adobe Flash Player Settings Manager - Advanced
  3. click Add…
    Trusted Location Settings
  4. click Add File… to select the .sfw file or Add Folder… to select the folder or CD/DVD drive then Confirm
    Add Site
  5. Close the browser

Did my solution solve your problem? Leave a comment.

You do not have the following permissions on TableData

When we develop in Microsoft Dynamics NAV, we use a Developer License that has permissions to the standard objects different of the license of the final customer.

Using the customer’s license you may encounter error messages as follows:

You do not have the following permissions on TableData {TableName}: {Read/Insert/Modify/Delete}

An example could be running a Codeunit that modify a record in the standard table 6550 Whse. Item Tracking Line.
You do not have the following permissions on TableData

Considerations:
I’m pretty sure that most of you after will receive an error like this, first will search the table number of the one in the error message. Then you will realize that is in the range of the standard objects (e.g. 6550) and you will start thinking why this error didn’t happen during your tests.

Well, the answer is obvious if you think that probably you tested using the Developer license and that the Customer’s license has different permission to access to the standard objects.

Causes:
Create a new Page using the wizard of type List to show all the fields of the system table Permission Range.
Then run it with the Customer’s license and filter for the object in the error message (i.e. TableData 6550)
Permission Ranges
As you can see, this TableData in the Customer’s license has Insert/Modify/Delete permission as Indirect. This means that you CANNOT do those action directly in that table.

Note: Remind that if you are saving the license in the database or you upload a new license you must restart the instance service.

In the meantime you realized (maybe debugging) that the code that caused this error is in a Codeunit. Bingo!!!

You do not have the following permissions on TableData

Solution:
Open the Codeunit in design and assign in the Properties the correct Permissions to the tables
Permissions

Did my solution solve your problem? Leave a comment.

SQL Server upgrade from Express

To upgrade SQL Server from Express edition to a different edition of the same version follow the steps:

  1. Insert the SQL Server installation media of the new edition you want upgrade to. From the root folder, double-click Setup.exe.
  2. SQL Server Installation Center click Maintenance, and then select Edition Upgrade.

Did my HOW TO help you? Leave a reply.

HOW TO gain access to local drives in RDP

Often when you are connected to a computer in a Remote Desktop Connection (RDP) you need to have access to your local drives or local files.

HOW TO gain access to local drives in RDP?

  1. Click Start, point to All Programs (or Programs), point to Accessories, point to Communications, and then click Remote Desktop Connection.
    Remote Desktop Connection
  2. Click Show Options and then click the Local Resources tab.
  3. Click More under Local devices and resources.
    Remote Desktop Connection - Local Resources
  4. Select the check box next to Drives (you could select some drives clicking the plus sign to show detail data) then click OK.
    Remote Desktop Connection - Choose local devices and resources
  5. Click the General tab, Type the name of the Computer and the Username (with format Domain\Username) and then click Connect.
  6. Type your Password and then click OK.

Did my HOW TO help you? Leave a reply.