-
Select all fields in dataport
Hi How do you select all fields in a dataport?? is that possible?? or do I have to select each field manually? Thanks Paeren
-
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…
-
Temporary Table on SubForm (NAV <= 4.0x)
Hi guys, yes there is a nice property present starting with Nav 5.00. But a lot of customers are not going to upgrade their installations to this version anyway. So If you're looking for some kind of How To Use Temporary Tables on Forms or even SubForms you can visit following simple Blog posting showing this tricky…
-
Using Partitioned Tables in Nav
Partitioned tables/indexes is a new and exiting feature in SQL 2005 that is not used in Nav. Using partitioned tables in Nav can increase performance when working with BIG tables such as transaction history tables. With a partitioned table, you can define that all history from 2006 and back (inklusive) should be stored on…
-
Interact Wizard loses Comments
Not a Support request - this is a bug report. When using Interact Wizard (Form 5077), one has the opportunity to add comments directly, next to Description Field. These comments are not recorded due to a bug in Table 5077 (Segment Line), whereby comments are added to a LOCAL Temporary Table, in stead of a GLOBAL Temporary…
-
How to consume a webservice with XMLports and HTTP POST
I know the subject of consuming web services has been covered elsewhere in posts and documents. However, all of them seem to either use a simple string for the XML message or build it element by element. The problem is that the former is no good for large messages and the latter is a bit unwieldy, especially when we have…