Best Of
Re: Record insert stops after first error - and GETLASTERRORTEXT
Any time you want to trap the error from a piece of code, log it can continue you need to place the code in its own codeunit. The GETLASTERROR only functions for code run from the OnRun trigger.
bbrown
1
Re: Insert(true) vs Insert() - Using TRUE what's the difference and use cases
Don't think of performance, because having incomplete transactions is a WAY bigger problem than having to wait half a second for a shipment to post. You can fix performance issues in other ways. Whether you run the triggers or not has nothing to do with whether you are in a standard or custom table.
OnValidate triggers are used for getting related data into other fields. The decision to validate or not is when you want to take care of those in your code yourself. For instance, you can validate a City field and that pulls in post code and such. If you are setting those fields yourself, there is no need for calling the validation trigger.
Same as Insert(true) or Modify(true). Those triggers do things and the only reason why you would NOT run them is when you are doing those things in your own code.
You'll get different opinions here though, I've had very heated discussions about this topic. Some ppl will vehemently say to NEVER run triggers, where I say you should absolutely run them as much as possible. For instance, validating the Quantity on the Sales Line will calculate amounts and discounts and such. If you don't validate, you will have to program that calculation yourself.
My approach is to first do a task manually, and then do it in code. Creating a new Sales Order for instance. You open the page with a blank record, and as soon as you leave the No field, it inserts the order with a new number from the number series. That's the first 4 lines in the code you posted. Validate the Customer and the Location pulls in all sorts of important information. That's just three more lines of code. In 6-7 lines of code, you have a complete sales order, all you need to do is add some lines. I don't see any reason why anyone would ever program all of that.
Here's a good tip: turn on the debugger and do things in BC. Step through the code to get a feel for what it does.
OnValidate triggers are used for getting related data into other fields. The decision to validate or not is when you want to take care of those in your code yourself. For instance, you can validate a City field and that pulls in post code and such. If you are setting those fields yourself, there is no need for calling the validation trigger.
Same as Insert(true) or Modify(true). Those triggers do things and the only reason why you would NOT run them is when you are doing those things in your own code.
You'll get different opinions here though, I've had very heated discussions about this topic. Some ppl will vehemently say to NEVER run triggers, where I say you should absolutely run them as much as possible. For instance, validating the Quantity on the Sales Line will calculate amounts and discounts and such. If you don't validate, you will have to program that calculation yourself.
My approach is to first do a task manually, and then do it in code. Creating a new Sales Order for instance. You open the page with a blank record, and as soon as you leave the No field, it inserts the order with a new number from the number series. That's the first 4 lines in the code you posted. Validate the Customer and the Location pulls in all sorts of important information. That's just three more lines of code. In 6-7 lines of code, you have a complete sales order, all you need to do is add some lines. I don't see any reason why anyone would ever program all of that.
Here's a good tip: turn on the debugger and do things in BC. Step through the code to get a feel for what it does.
DenSter
3
Re: Flowing Custom field from Sales Documents to Value Entries
I'd have to say I disagree with this approach. Flow the custom values to the "Value Entries" as they are being created. No need to retrieve records that are already available in the posting process. Also, as a good general rule, avoid interacting with a table differently from how the base system does. "Value Entry" records are only ever inserted. They are never modified or deleted. So your code should never either. Among other things, this can help avoid deadlocks.
"Value Entries" are created from "Item Journal Lines". Which in turn are created from the document lines. Follow this logic and the available events to bring your fields to these tables.
"Value Entries" are created from "Item Journal Lines". Which in turn are created from the document lines. Follow this logic and the available events to bring your fields to these tables.
bbrown
2
Re: Performance - Insert to temporary table
Well it is hard to say since we dont know how that data is populated.
when you say a temporary table is it a record with TEMPORARY=yes right? make sure that is enabled, lol.
I would suggest to debug it and see what is doing after insert etc.
when you say a temporary table is it a record with TEMPORARY=yes right? make sure that is enabled, lol.
I would suggest to debug it and see what is doing after insert etc.
txeriff
1
Re: sort in RecordRef
Could you maybe think of a way to define these things in some kind of settings?
I made a tool some time ago with which you can find anything in Navision. You can setup relation, conditions, filters and even keys. But these "search rules" are predefines.
Sample:
Search from "sales line", if "type = item", for "item", field "search description" where "BOM = yes" with key "search description".
So as you can see, in my tool, the key is pre-set or pre-defined.
I think you sould do something like that. Or you could make something that looks-up the best key there is and activated it.
BTW, here is another way to set a key:
Keyname is something like: "field1,field2,field3"
Here's a little functions that I made which generates keynames:
Good luck!
I made a tool some time ago with which you can find anything in Navision. You can setup relation, conditions, filters and even keys. But these "search rules" are predefines.
Sample:
Search from "sales line", if "type = item", for "item", field "search description" where "BOM = yes" with key "search description".
So as you can see, in my tool, the key is pre-set or pre-defined.
I think you sould do something like that. Or you could make something that looks-up the best key there is and activated it.
BTW, here is another way to set a key:
recref.setview(strsubno('SORTING(%1)',keyname));
Keyname is something like: "field1,field2,field3"
Here's a little functions that I made which generates keynames:
GetKeyName(recno : Integer;keyno : Integer) KeyString : Text[250]
IF (recno = 0) OR (keyno = 0) THEN
EXIT
recref.open(recno);
keyref := recref.keyindex(keyno);
IF NOT keyref.ACTIVE THEN
EXIT;
NumOfKeyFields := keyref.FIELDCOUNT;
FOR i := 1 to NumOfKeyFields DO BEGIN
fieldref := keyref.FIELDINDEX(i);
keystring := STRSUBSTNO('%1%2%3',keystring,separator,fieldref.NAME);
separator := ',';
END;
Good luck!
eromein
1
Re: How to Change Caption Style
have you had a look at captionclass check fields like global or shortcut dimensions on the several pages
Re: How to get special folders paths?
Just a quick update on this one after 11 years to make it work on RTC-based clients without Automation Security warning on RTC:
To do this, have a variable defined as DotNet variable and RunOnClient=true parameter setup:
Name DataType Subtype Length
Environment DotNet System.Environment.'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
And if you would like to access i.e. Local AppData folder for any file saving operation, get the path string without "\" at the end:
Folder := Environment.GetEnvironmentVariable('localappdata') + '\';
To do this, have a variable defined as DotNet variable and RunOnClient=true parameter setup:
Name DataType Subtype Length
Environment DotNet System.Environment.'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'
And if you would like to access i.e. Local AppData folder for any file saving operation, get the path string without "\" at the end:
Folder := Environment.GetEnvironmentVariable('localappdata') + '\';
gycsiak
1
Re: How to get the option value of a Option var?
FORMAT(fieldname,0,2)
This should return the numeric value of the option instead of the option text.
This should return the numeric value of the option instead of the option text.
Re: NAV Client Freezes on click of Apply Entries Button on Payment Journal
Hello fazlehasan,
that have probably something to do with the PersonalizationStore.xml. Close NAV, delete the PersonalizationStore.xml and try it again.
The file can be cound at
that have probably something to do with the PersonalizationStore.xml. Close NAV, delete the PersonalizationStore.xml and try it again.
The file can be cound at
%appdata%\Microsoft\Microsoft Dynamics NAV
Aluan
1
Re: Using DotNet System.IO.Path in 2009 R2 Classic Client?
You cannot work with .NET in the Classic Client.
But here the way to get the assembly name for a .NET class of the standard framework:
- Search in the MSDN for the class you want to use (http://msdn.microsoft.com/en-us/library ... .file.aspx)
- Select the Framework Version you want to use (.NET 2 .. 4.5)
- Look for the Assembly, in this case: mscorlib (in mscorlib.dll)
- Search in the list of assemblies in NAV for the given name
But here the way to get the assembly name for a .NET class of the standard framework:
- Search in the MSDN for the class you want to use (http://msdn.microsoft.com/en-us/library ... .file.aspx)
- Select the Framework Version you want to use (.NET 2 .. 4.5)
- Look for the Assembly, in this case: mscorlib (in mscorlib.dll)
- Search in the list of assemblies in NAV for the given name
SiSt
1