Best Of
Lookup - Best Way and The Difference
I tried to created 4 methods to lookup table by using C/AL in the Control. All are have the same result (lookup the table, get the value, and put it to field or variable). What is the best way? are they any difference among this 4 methods?
"Test Lookup" is new field in Customer table.
In the form, pull "Test Lookup" and overwrite standard lookup :
"Test Lookup" - Onlookup (VAR Text : Text[1024];) : Boolean
//Method 1
CLEAR(CustForm);
CustTable.SETRANGE("No.",'10000','50000');
CustForm.SETTABLEVIEW(CustTable);
CustForm.SETRECORD(CustTable);
CustForm.LOOKUPMODE(TRUE);
IF CustForm.RUNMODAL = ACTION::LookupOK THEN BEGIN
CustForm.GETRECORD(CustTable);
"Test Lookup" := CustTable."No.";
END;
//Method 2
CLEAR(CustForm);
CustTable.SETRANGE("No.",'10000','50000');
CustForm.SETTABLEVIEW(CustTable);
//CustForm.SETRECORD(CustTable); //REMOVE SETRECORD
CustForm.LOOKUPMODE(TRUE);
IF CustForm.RUNMODAL = ACTION::LookupOK THEN BEGIN
CustForm.GETRECORD(CustTable);
"Test Lookup" := CustTable."No.";
END;
//Method 3
CustTable.SETRANGE("No.",'10000','50000');
IF FORM.RUNMODAL(0,CustTable) = ACTION::LookupOK THEN
"Test Lookup" := CustTable."No.";
//Method 4
CustTable.SETRANGE("No.",'10000','50000');
IF FORM.RUNMODAL(0,CustTable) = ACTION::LookupOK THEN BEGIN
Text := CustTable."No.";
EXIT(TRUE);
END;
"Test Lookup" is new field in Customer table.
In the form, pull "Test Lookup" and overwrite standard lookup :
"Test Lookup" - Onlookup (VAR Text : Text[1024];) : Boolean
//Method 1
CLEAR(CustForm);
CustTable.SETRANGE("No.",'10000','50000');
CustForm.SETTABLEVIEW(CustTable);
CustForm.SETRECORD(CustTable);
CustForm.LOOKUPMODE(TRUE);
IF CustForm.RUNMODAL = ACTION::LookupOK THEN BEGIN
CustForm.GETRECORD(CustTable);
"Test Lookup" := CustTable."No.";
END;
//Method 2
CLEAR(CustForm);
CustTable.SETRANGE("No.",'10000','50000');
CustForm.SETTABLEVIEW(CustTable);
//CustForm.SETRECORD(CustTable); //REMOVE SETRECORD
CustForm.LOOKUPMODE(TRUE);
IF CustForm.RUNMODAL = ACTION::LookupOK THEN BEGIN
CustForm.GETRECORD(CustTable);
"Test Lookup" := CustTable."No.";
END;
//Method 3
CustTable.SETRANGE("No.",'10000','50000');
IF FORM.RUNMODAL(0,CustTable) = ACTION::LookupOK THEN
"Test Lookup" := CustTable."No.";
//Method 4
CustTable.SETRANGE("No.",'10000','50000');
IF FORM.RUNMODAL(0,CustTable) = ACTION::LookupOK THEN BEGIN
Text := CustTable."No.";
EXIT(TRUE);
END;
Angelo
1
Navison in real estate/land development
Hello
I am looking for information about implementing Navison in real estate/ land development companies.
Does anyone know where I could find info about such projects/developments/add-ons etc?
Thank you
I am looking for information about implementing Navison in real estate/ land development companies.
Does anyone know where I could find info about such projects/developments/add-ons etc?
Thank you
Razzai
1
Re: Navison in real estate/land development
Please find the addon in Microsoft Appsource:
https://appsource.microsoft.com/en-us/product/dynamics-365-for-operations/dynamic-netsoft.ed43ab95-b434-487c-a4be-223b08c22c1e?tab=Overview
https://appsource.microsoft.com/en-us/product/dynamics-365-for-operations/dynamic-netsoft.ed43ab95-b434-487c-a4be-223b08c22c1e?tab=Overview
Re: Find the specific "Sales Price" the used to validate "Unit Price" on Sales Order Lines
this should be your correct event:
[EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnUpdateUnitPriceByFieldOnAfterFindPrice', '', false, false)]
[EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnUpdateUnitPriceByFieldOnAfterFindPrice', '', false, false)]
Reporting/tracking data Storage Capacity Usage
Hello,
I have had a few Business Central clients report that they have checked their data Storage Capacity Usage in their admin center and discover that they are over capacity, which they had not anticipated.
There are data retention tools and procedures, which we have helped these clients with, but as far as I am aware, there is currently there is no automated notification of either growth or of exceeding capacity in BC or the admin center, nor any tools or reports to provide growth pace and trends, which they may extrapolate from. These would be very useful as they would allow customers to make better decisions regarding data retention policies for data they can remove as redundant and manage their license budget to buy more capacity for data they must retain.
I wanted to see if some did know of such tools or reporting.
I have searched the forum for previous posts on this but have not found anything. Apologies in advance if I have missed anything in my search.
Thank you
I have had a few Business Central clients report that they have checked their data Storage Capacity Usage in their admin center and discover that they are over capacity, which they had not anticipated.
There are data retention tools and procedures, which we have helped these clients with, but as far as I am aware, there is currently there is no automated notification of either growth or of exceeding capacity in BC or the admin center, nor any tools or reports to provide growth pace and trends, which they may extrapolate from. These would be very useful as they would allow customers to make better decisions regarding data retention policies for data they can remove as redundant and manage their license budget to buy more capacity for data they must retain.
I wanted to see if some did know of such tools or reporting.
I have searched the forum for previous posts on this but have not found anything. Apologies in advance if I have missed anything in my search.
Thank you
Re: Reporting/tracking data Storage Capacity Usage
RecRef.Open(8700);
RecRef.SetLoadFields(2, 8);
RecRef.field(2).SetFilter('<>%1&<>%2&<>%3', 2000000184, 2000000183, 2000000185);
RecRef.field(8).SetFilter('>=%1', 240);
FldRef := RecRef.field(8);
if FldRef.CalcSum() then
VariantValue := Round(FldRef.Value(), 0.01, '>') / 1000;
RecRef.Close();
Table Information is protected, so you need to use RecRef.
That calculates the used storage in megabytes.
Re: Manipulating RecordID
Paluxo wrote:MTC wrote:Sorry, but I'm not quite sure what exactly you are trying to do?
I was triing to convert a RecordID (one of the navision data types) into a string. My problema was that i could not create a recordId with valid data to do the tests. Its necessary to use a RecordRef to get a recordId
Exemple:
Customer.RESET;
IF Customer.FIND('-') THEN BEGIN
RecRef.GETTABLE(Customer);
RecID := RecRef.RECORDID;
END;
My problem is SOLVED thanks guys
Is the other way round possible?
I mean: when I have a recordID, how can I use this to get a record through a recordvariable (instead of a RecordRef)
is is as simple as the following code?
RecRef.get(RecID); RecRef.SETTABLE(Customer);
And do I need a find statement right after the settable?
Tested it myself, and yes it is that simple and you don't need a find statement right after teh settable line.
GoMaD
1
Re: Checking/Comparing for empty string filter
So, you set the filter to be empty and then expect the filter to distinguish an empty string from any other value. Isn't that unreasonable?
If you want to filter for a distinct value, you should always use SETRANGE. SETRANGE automatically quotes the value for you (or does behind the scenes what proper quoting would do).
If you can't, or don't want to use SETRANGE, you should use replacement placeholders. In your case this would be
So, in essence, GETFILTER returns '' because you SETFILTER ''. If you want to GETFILTER '''''''' (i.e. the filter expression
Check out the documentation on setting filter strings (ignore the section on the quick filter, unless you want to analyze how the system mangles your input by looking at the Filters section on the "About this page" page; take into account that you need to double all single quotes that are part of the filter string and surround the whole string with single quotes, in order to use it as a literal string in C/AL Code) and my analysis of how SETFILTER's parameters are treated.
If you want to filter for a distinct value, you should always use SETRANGE. SETRANGE automatically quotes the value for you (or does behind the scenes what proper quoting would do).
If you can't, or don't want to use SETRANGE, you should use replacement placeholders. In your case this would be
SETFILTER("Source Batch Name",'%1','')
. This is, however, tricky, as certain filter meta characters change the way values are folded into the filter string. In some cases, proper quoting applies, in other cases the same thing happens as if you used STRSUBST to create the filter string parameter, i.e.
SETFILTER(Field,STRSUBST('%1*','ABC'))
and in even other cases what looks like a placeholder is treated as literal value.So, in essence, GETFILTER returns '' because you SETFILTER ''. If you want to GETFILTER '''''''' (i.e. the filter expression
''), you need to set the filter accordingly.
Check out the documentation on setting filter strings (ignore the section on the quick filter, unless you want to analyze how the system mangles your input by looking at the Filters section on the "About this page" page; take into account that you need to double all single quotes that are part of the filter string and surround the whole string with single quotes, in order to use it as a literal string in C/AL Code) and my analysis of how SETFILTER's parameters are treated.
vaprog
1
Re: VS Code debugger in wrong place on standard code - BC v23
It's a bug in VSCode. Microsoft is working on fixing that
DenSter
2