-
GDPDU Export - Solving DTD Problem with Export for IDEA
When exporting data with the German GDPdU Interface you may encounter problems that the system will have problems to create the index.xml. The Reasons seems to be a problem with the filename of the needed DTD, which is originally provided as "GDPdU-01-08-2002.dtd". After renaming the file to "gdpdu.dtd" everything worked.…
-
Not To-do :)
this is a silly thing that can anger you when it happens... open a form or report designer, click the toolbox to open it,close it, open it,close it...you'll note that everytime it opens, it appears a bit nearer to the top of the screen...and surprise! it overcomes the top,too!in this way you won't be able to close it!!!and…
-
New Menusuite
Is it possible for us to create a new menusuite for each company in the same database in version 4?
-
Pass parameter to report / Setrange two dataitems in report?
Scenario:- Report: Sales Order Data Items: Sales Header, Sales Line In my Sales Order form, when I click Print Sales Order, above report will be previewed and printed. This is the coding i use to just pass the Sales Order No. to my report.SalesHeader.SETRANGE("No.","No.");REPORT.RUN(REPORT::"Sales…
-
MAPI + Terminal Server + exchange = Not supported
I would like to bring the following kb under youre attention http://support.microsoft.com/kb/266418 So if youre are ever tempted, in a 2 user setup for example, to use a small business server (this has exchange installed on it)and install terminal services (to be able to work form home) . Then when you add the magic…
-
SQL server returns . as . not _ !
Hi, ran into a strange "problem" today. Ever since I started writing c# code against SQL server Navision databases I've had to replace . with _ such as "No." would be "No_". Then today while installing at a client all off a sudden the SQL Server doesnt want the "No_" but gladly accepts "No." !!!! Is there a setting on the…
-
NAV Brainfuck
Hi All HYPERLINK(Execute('++++[>+++.... where am I? :roll: OBJECT Codeunit 60000 Brainfuck Interpreter{ OBJECT-PROPERTIES { Date=18-06-08; Time=[ 2:23:56 ]; Modified=Yes; Version List=; } PROPERTIES { OnRun=BEGIN CASE STRMENU('1. hello,2. i/o,3. reverse,4. mibuso,5. my birthday') OF 1: MESSAGE(Execute(Text001)); 2:…
-
Free Tutorial for Beginners or Intermediate Woldwide Version
Hi Guys. This is not aimed at the guru's out there but the new Developer, who might be struggling, with C/AL Code like we all were once. I have been working all weekend on getting my new website up and runing, while looking for something to put on it, I decided to do a free tutorial as a test. It is a G/L Account tutorial…
-
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…
-
Simple crypt functions
Hi All Simple crypt method base on key and ... cards :D :D OBJECT Codeunit 70000 Crypto Cards{ OBJECT-PROPERTIES { Date=12-06-08; Time=[ 1:48:12 ]; Modified=Yes; Version List=; } PROPERTIES { OnRun=BEGIN Code('c:\cards.key','c:\file.txt','c:\file.___'); Decode('c:\cards.key','c:\file.___','c:\file2.txt'); END; } CODE { VAR…
-
Retrieving Eventlog messages in Navision ?
Has anyone found an easy way to retrieve messages from the Windows Eventlog (Application log) in to Navision ? I was thinking of using an existing Windows automation or a freeware/shareware component but I can't find out which one to use. What I want is to make a codeunit able to import all Windows application log entries…
-
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:
-
Debug Tip on Call Stack
Some people may not know this. So I suggested adding it in here. When you are debugging, you see the call stack, usually at the bottom of the screen. You can double click on second or third line and debug window will point to the code on where it was called from so you can see all the from the begging of the call stack and…
-
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!!!!
-
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
-
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 :=…
-
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…
-
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...
-
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.
-
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............
-
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…
-
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…
-
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 ?
-
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?
-
Error in Navision 360 fieldref
I have discovered an error when using fieldref’s in a 360 database. Observe the following code: l_RecordRef.OPEN(DATABASE::TestCountry); l_RecordRef.INIT; l_FieldRef := l_RecordRef.FIELD(1); l_FieldRef.VALUE := 'dk'; l_FieldRef := l_RecordRef.FIELD(2); l_FieldRef.VALUE := 'Denmark'; l_RecordRef.INSERT; l_RecordRef.INIT;…
-
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…
-
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…
-
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…
-
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…