-
How to limit Navision login session (Nav 4 SP3)
Hi, I would like to know, how to limit user login connections to the server? (Using NAV 4 SP3) If the user login sessions to the Database exceeds 3, how to close/logout programatically the last (4 th) user session. I tried the below code in the Codeunit1 - 'LogInStart' tblSession.RESET; tblSession.SETRANGE("My…
-
Code Coverage - exporting and filtering
When using Code Coverage, I would like to: a) filter out the lines have not been executed (i.e. the red lines) b) export the lines (actually, just the black lines) to a single text file. Does anyone konw how to do this? Thanks, Alastair
-
How to generate random code with limited range
Hi Nav Masters I have a problems, i need to generate 8 digit Code which each digit is random code consist of : number 2 to 9 (without 0 and 1) or A to Z or a to z Can we do this? How to do it in navision c/al code? Thanks in advance,
-
Display page no in format PageNo / TotalPage Simple trick
Hi All This small trick to print the total page number for the report. - Form ID 80000. - Report ID 80000 Copy of the vendor report. run the form and check the idea. :-k (Code has been updated check down) :wink:
-
Import JPG on Fly & Show In Navision
It's been discussed how to save your Item pictures on an outside drive and show them in Nav on the fly as BMP. This way you Database doesn't grow out of control when you have to import 10000 pics into BLOB fields. You can also have JPG pics on an outside drive and show them in Nav. To Test use Form 346 item Picture…
-
Change Log for records modified with a codeunit
1/ I made a codeunit to modify a record in a table with the function Record.MODIFY(TRUE); 2/ I added a setup in Chang Log setup to track al the modification in this table 3/ When I run the codeunit, nothing is added to the change log table, but when i change manually the record from the table, a change log is added. Any…
-
How can I find the standard printer from CAL
Hi I need to find the name of the standard printer. In the Printer system table I have a list of all installed printers but how do I know which one is standard? many thanks in advance!!!!
-
CuteFTP and NAS
Here are some tips on using CuteFTP and the Job Scheduler running under NAS. First, there's a reasonably good explanation of how to use CuteFTP here: http://www.revolution1210.com/article.asp?r0=3&r1=199 Next, I found that using this utility works absolutely fine when running from normal user credentials. I then tested…
-
Windows Server 2008 and Dynamics NAV 5.01 installation error
I have just installed a new Windows Server 2008 machine today, and am preparing it as a Terminal Server. I try to install Dynamics NAV 5.01 client, and am getting an the following error which causes the installation to rollback. Product: Microsoft Dynamics NAV 5.0 SP1 CSIDE Client -- Error 1935.An error occurred during the…
-
How to fix strangely behaving Option FlowFilters
So you have FlowFilters of the Option type and actually put them on a form instead of forcing the user to use the filter buttons on top of the screen. While FlowFilters of the Code type work perfectly, the strange stuff about Options is that if you type in the value, they work, but if you select it from the list, they…
-
Navision Team Development on SQL Server
One of the issues with working on server in Navision with other developers is that objects get overwritten. I've written a tool that prevents this from happening. This works on SQL 2005 only. It is written in .NET sql CLR. I've blogged out it in here http://mibuso.com/blogs/ara3n/2008/05/1 ... elopement/ Download the zip…
-
Dataport
At the time creating a new Dataport, there is a hotkeys can be used for to select all the fields of that table. Can anyone knows?
-
Automated Keystokes
Hi, I am looking for some sort of a list that contains all the keystrokes in NAV. By Keystrokes I mean automated e.g. By running the following code you automatically close NAV : CREATE(lvWinShell); lvWinShell.SendKeys('%{F4}'); % = Crtl I am looking for the "ALT" Keystroke particularly. Thank you in advance.
-
Single line, Make sure Directory Path ends with '\'
This is by no means a huge tip or trick, and it is quite bulky, but I think it's nifty. I use it all the time :mrgreen: DirPath := DELSTR(DirPath,STRLEN(DirPath),STRPOS(DirPath[STRLEN(DirPath)],'\'))+'\';
-
How to add new path to current system path
Hello gurus, How can I add a new path string to the current system path? Using Environ('Path') we can able to retrieve the current system path, but how to add new path string? Current System Path: Path = c:\windows;c:\windows\system32; I want to add this path c:\temp; New system path will be: Path :=…
-
WebServices in NAV 5.0 and less article...
I have found this VERY INTERESTING article: http://blogs.msdn.com/nav/archive/2008/ ... v-5-0.aspx You can find the source codes included and you can use it to create own webservice in NAV 5.0 and older...
-
Hai, Here some Tips to move on Navision Form.......
1. If u want to move from a Object Designer to Menu suite Desinger Use F12 button...... But Reverse use Ctrl+F12 2. If u want to Go Lookup's on the form (Don't use F6) Use Alt+Down Arrow 3. If u want move from Main form to Sub form and vice versa Use Ctrl+Down Arrow Please share knowledge with our Mibusonians............
-
Is there a shortcut key to switch between forms?
Hi guys. Maybe someone knows, if there is a way to switch between more open forms using shortcuts. I mean something like Alt+Tab to switch between applications. Thanx for help.
-
An editable field on a non-editable form
Today I 'discovered' a nice litte trick. Thought I'd share it with you. It was necessary to have an editable field on a non-editable form. In the OnAfterGetCurrRecord on the form there is the following code:CurrForm.EDITABLE(status = status::open); So if status is released the form is non-editable. But 1 field still has to…
-
Restoring backup error (NAV 4.0 sp3)
Hi everybody, have you ever met such problem: I am restoring the backup xxx.fbk (big one, 2 Gb) and when indicator reaches 100% there is an error: "File xxx.fbk was not found". Happens in both cases when I restore only application objects and the whole backup. What can be the problem about?
-
Able to tell if Record has been Modified without...
Is there any flag that gets turned on somewhere that tells you a record has been modified without having to go through each field checking the Field vs xRec.Field ?
-
Problem with window in window
Hi all! A whole different kind of question than the usuall Navision related question! Does anyone knows if there is a way to access the system meny within the main Navision window? The system meny is the menu under the small program icon in the top-left corner of any main program window. But there is also a system menu on…
-
Daylight Saving Time
In order to create and consume data to/from an interface we have to deliver/consume date and time and timezone. Format of the timezone is: "+nn:nn" which means hours and minutes relative from UTC. As far is I understand our timezone CET is normally UTC+1, but it is UTC+2 in daylight saving time period. Is there an easy why…
-
A little trick
I've found a little trick that some of you may find useful. It's not that novel, but does allow for some tricks. If for nothing else, it can provide some syntactic sugar. Dynamic Dispatch in Navision Taking Navision to the Max
-
Send TCP Port a command
Hi, I could not find an answer in the forum so I am hoping someone has come across it before. I have to send data to a scale through a TCP Port. I will be sending an IP address, port number, and then a command as text. Has anyone done this before? I am thinking it should be as simple as decalring some variable, and then…
-
Right click open multi version fdb without third application
Hey guys, I think this is a quite normal question for a person who always has to switch different clients between different version fdbs. I actually found a very easy way to handle it by just right clicking fdb without any third part application after I got some nasty ideas from the guys here, wish it would be helpful for…
-
Navision RSS Feeds
Hi, Here is a list of RSS feeds that I follow, it includes the Mibuso forum and more. It is attached as zip file. Just unzip, and import into reader of your choice. I personally use Google Reader http://reader.google.com But Outlook 2007 also provides ability to use RSS feeds. If you have any questions, reply to this…
-
How to Re-apply a Language Pack when deploying the Outlook..
How to Re-apply a Language Pack when deploying the Outlook Integration Update for Microsoft Dynamics NAV 5.0 The language module file helps you to save the existing text messages and captions, and propagate them to the Outlook Integration Update objects. How to apply the language module file to the C/AL objects provided…
-
Fast Indent/Unindent
this is really stupid, but... as you now, NAV 5.0 allow to ind/unind a lot of lines of code simply selecting them and pressing TAB or SHIFT + TAB. But if you are working in e.g. NAV 3.10 you can simply cut your code, paste it in an empty codeunit in NAV 5.0, ind/unind as you want, cut the code and re-paste in 3.10…
-
Restoring an SQL Database on an other Server or other domain
Often i hearing from customer or other programmers, they wonder why they can't connect to the restored database on new server. Only the database creater / restorer can connect. Reason: The database creater is the dbowner. But whats with the other users. So, the problem is, in the backup is also the user identification…