Best Of
Re: RDP password decryption / encryption from NAV2017
Why not play with the OS then rather than with NAV? The error/limitation comes form the OS and this is where it should get addressed.
You have no choice anyway' I'm afraid.
You have no choice anyway' I'm afraid.
Re: Is there a way to start an RDP connection from NAV2017?
No, I do not to put any code on pages, with the exception of code directly manipulating page properties. The code lives in a codeunit. But where it is located does not make any difference to whether it works, or not .
Just a note - the Process var should be marked as RunOnClient=Yes, as you do want to run the process on client machine, not on the server. You might also want to remove the Process.WaitForExit(); line
Just a note - the Process var should be marked as RunOnClient=Yes, as you do want to run the process on client machine, not on the server. You might also want to remove the Process.WaitForExit(); line
Re: Is there a way to start an RDP connection from NAV2017?
You can start mstsc.exe using the Process .NET var
//Process System.Diagnostics.Process.'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
Process := Process.Process;
Process.StartInfo.FileName := 'C:\Windows\System32\mstsc.exe'; //
//optional Process.StartInfo.Arguments := 'connection path + file (.RDP)';
Process.StartInfo.UseShellExecute := FALSE;
Process.StartInfo.RedirectStandardOutput := TRUE;
Process.Start();
Process.WaitForExit();
Re: SQL Express Limitation in a Multi-tenant Environment
Express is limited to 1GB of memory pr. instance.
Multitenant runs on same sql instance, so all nav instances has to share 1GB of memory.
That could be a problem.
Multitenant runs on same sql instance, so all nav instances has to share 1GB of memory.
That could be a problem.
Juhl
5
Re: How many records list page loads on open?
Not sure about Azure, but on prem NAV starts from retrieving 50 records and then adjusts itself dynamically. That's form perspective of retrieving data from SQL server.
This does not match the the count of firing the OnAfterGetRecord trigger, as NAV does not fire one SQL query per one OnAfterGetRecord call. It reads a batch of records into internal buffers/cache and then OnAfterGetRecord fetches the data from the cache one by one.
Lookup flowfields are quite light in terms of querying the server, you would not feel the difference.
What is better, in tems of performance, is more philosophical rather than practical discussion in this case imho. On one hand calculating lookup flowfield NAV will use query retieving just that required column, rather than retrieving all the columns as it happens when you use FIND, GET or anyting like this, on the other hand Factbox will retrieve only one full record.
If it was me, If I were to modify a standard NAV table then I'd prefer to modify custom FactBox page instead - unless users need, for example, export the timesheet into an Excel spreadsheet, or filter or search for specific Job Description.
This does not match the the count of firing the OnAfterGetRecord trigger, as NAV does not fire one SQL query per one OnAfterGetRecord call. It reads a batch of records into internal buffers/cache and then OnAfterGetRecord fetches the data from the cache one by one.
Lookup flowfields are quite light in terms of querying the server, you would not feel the difference.
What is better, in tems of performance, is more philosophical rather than practical discussion in this case imho. On one hand calculating lookup flowfield NAV will use query retieving just that required column, rather than retrieving all the columns as it happens when you use FIND, GET or anyting like this, on the other hand Factbox will retrieve only one full record.
If it was me, If I were to modify a standard NAV table then I'd prefer to modify custom FactBox page instead - unless users need, for example, export the timesheet into an Excel spreadsheet, or filter or search for specific Job Description.
Re: How to convert 'domain\FirstName.LastName' into 'FirstName LastName' using string functions - report
CONVERTSTR(
COPYSTR("Created By User", STRPOS("Created By User", '\')+1),
'.', ' ');
Re: yyy
Yes if you can code, use Aftership API https://docs.aftership.com/api/4/overview if you know Tracking Code then you can get Tracking Info and update your documents.
NoOneLt
5
Re: Refer to external assembly(dll) in extension
.NET assemblies are not supported in AL.
You'll have to move your external logic to REST services and access it that way.
You'll have to move your external logic to REST services and access it that way.
EvR
5
Re: DotNet-Variables always passed as Call-By-Reference parameter?
.net variables are always used byref.
NavNab
5
Re: NavUserPassword
You may need a DNS entry for pyramissrv.pyramisac.local domain (on your local DNS server serving your local domain), and on the top of that you may need a reverse DNS entry for the same IP/fqdn pair.