I liked your observation that FINDSET can't collect records backwards and therefore you need a FINDLAST or FIND('+') and NEXT(-1). One thing that intrigued me was the result of this code : CLEAR(_cust); _cust.FIND('-'); MESSAGE(FORMAT(_cust.COUNT)); CLEAR(_cust); _cust.FINDFIRST(); MESSAGE(FORMAT(_cust.COUNT)); CLEAR(_cust); _cust.FINDSET(); MESSAGE(FORMAT(_cust.COUNT)); All 3 Find commands return same number (at least for NAV14 with SQL2017 backend). So I'm tempted to believe that the backend SQL mechanism is a cursor for all three and most likely for IsEmpty the backend might be a stored procedure with an IF Exists statement.
Hi Erik, These settings are so cool and we can maintain development protocol so easily which this. Thank you for the video! Although, my VScode doesn't recognize "al.codeAnalyzers" as a Configuration setting, do you know why? :(
Awesome video :) I've got a question though: Any way to grab a single rule out of a Cop? I want to use the affix rule from AppSourceCop while developing PTE. Do I have to activate the whole AppSourceCop and deactivate every rule I don't want to use?!
Hi Erik - You are putting your "Hgd" ID in the end of the name - can this ID be anywhere in e.g. the table name - some danish instruktor told me that the registrated ID schould be in the start . was this what role AA0215 ment before you changed it? PS - super video du laver :-)
Again very helpful for me, thanks Erik
Great video, you managed to cover all points regarding code analyzers
I liked your observation that FINDSET can't collect records backwards and therefore you need a FINDLAST or FIND('+') and NEXT(-1).
One thing that intrigued me was the result of this code :
CLEAR(_cust);
_cust.FIND('-');
MESSAGE(FORMAT(_cust.COUNT));
CLEAR(_cust);
_cust.FINDFIRST();
MESSAGE(FORMAT(_cust.COUNT));
CLEAR(_cust);
_cust.FINDSET();
MESSAGE(FORMAT(_cust.COUNT));
All 3 Find commands return same number (at least for NAV14 with SQL2017 backend). So I'm tempted to believe that the backend SQL mechanism is a cursor for all three and most likely for IsEmpty the backend might be a stored procedure with an IF Exists statement.
Try without the FIND* - Count do not require the records to be found.
Great Video and well done with the balance of live part/off-cam part!
Great video. I'm starting the process of having my app published so this will be helpful. Looking forward to the next video! Thanks a lot!
Hi Erik,
These settings are so cool and we can maintain development protocol so easily which this. Thank you for the video!
Although, my VScode doesn't recognize "al.codeAnalyzers" as a Configuration setting, do you know why? :(
Awesome video :) I've got a question though: Any way to grab a single rule out of a Cop? I want to use the affix rule from AppSourceCop while developing PTE. Do I have to activate the whole AppSourceCop and deactivate every rule I don't want to use?!
Yeah, that seems to be the only option right now...
please make one vedio how to make progress bar using AL
Hi Erik - You are putting your "Hgd" ID in the end of the name - can this ID be anywhere in e.g. the table name - some danish instruktor told me that the registrated ID schould be in the start . was this what role AA0215 ment before you changed it?
PS - super video du laver :-)
It can be either, I always use postfix to make searching easier.