I just got some strange error using STRSUBSTNO:
The text ‘…’ in STRSUBSTNO parameter no. 1 is too long.
Surprise : Is the string I give already longer than 1024 chars? But shouldn’t I have got an error when assigning that value to my variable that I sent into STRSUBSTNO?????
I was wondering if STRSUBSTNO was still limited […]
Filed under: C/AL, NAVISION | Make a Comment »
As we all (should) know, SQL is based on sets and NAV works iterative with records.
Sometimes it is possible to do set based programming also in NAV.
I just found an example in which we can speed up something thinking in sets (1 record is also a set!) instead of iterative. The beautiful thing is: it […]
Filed under: C/AL, NAVISION, NAVISION-DB, PERFORMANCE, SQL | 3 Comments »
Lately I have very little time to write blogs or to be online in general. But I found some time anyway to write a new how-to. Took me over a month anyway to write it.
I have noticed too many times that a lot of people use record-variables in a completely wrong way.
The smaller errors just […]
Filed under: C/AL, NAVISION, NAVISION-DB, PERFORMANCE, SQL | 1 Comment »
Create a new blog and join in the fun!