-
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…
-
Google Custom Navision Search Engine
Hi All, I have created a custom search engine which searches Navision Sites. http://www.google.com/coop/cse?cx=01462 ... ln7zuzbgnw I currently have 5 sites. If there are any other Navision sites that you want listed, just reply to this thread and I will add it to the custom Search Engine. The sites currently searched are:…
-
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;…
-
About simple parsing a text file with objects
Hi All, Below you can find some C/AL code for fast parsing text file with NAV objects. OBJECT Table 50000 C/AL Code{ OBJECT-PROPERTIES { Date=28-11-07; Time=09:47:38; Modified=Yes; Version List=Research; } PROPERTIES { } FIELDS { { 1 ; ;Line No. ;Integer } { 2 ; ;Line Text ;Text250 } { 3 ; ;Nesting ;Integer } { 4 ; ;Line…
-
Using ADO & Stored Procedures in C/SIDE
Source: my blog For a better edited version of this text I advice you to go to my blog. :wink: Recently, I had to do a small project. A client of us wanted to see the global inventory of all its companies. Furthermore, the companies were also spread over multiple databases. They wanted quick answers on questions like "What…
-
Shortcut key menusuit
Does anybody know the Shortcut key to go to the menusuit (navigation pane)? When you are in the menusuit you can use e.g. CTRL 1 to go to Financial Management and run an object. But when you want to return from the object back to Financial Mgt in the menusuit, CTRL 1 doesn't work.
-
Com Port with mscomm32.ocx
Need help with reading data (Barcodescanner) from a com port. I'm using the mscomm32.ocx. (Navision 370) Example: //init MSComm.CommPort(4); //COM4 MSComm.Settings('9600,N,8,1'); //Parameter MSComm.InputLen(0); //Sofort senden MSComm.InBufferCount(0); //Init MSComm.InputMode(0); //Textmode MSComm.PortOpen(TRUE); //öffnen…
-
How to retrieve network path from mapped drive path
Hello, using the CommonDialog control, I allow a user to select a file. Then I place that path and filename into a field of a table. Once the path is stored in the table, other users should be able to click a button on the form and open the designated file. The problem is that the path may be a mapped drive path and other…
-
Job Queue blog example
Hello. Saw this great blog, that is a great example on how modify Navision to queue any processes that cause locking. http://blogs.msdn.com/microsoft_dynamic ... v-5-0.aspx
-
Lazy Programming: What text-based object files are good for
Source: my blog Last week, I had to do a considerably small change in one of our "Tools". Considerably ... I had to add 4 options to an option field ... and I had to put it in between other option values. First reaction: I don't like that. Second reaction: let's put it at the end to avoid problems (which cascade in other…
-
copy fieldfilters from 1 table to another
This topic I create as a remark to my post http://www.mibuso.com/forum/viewtopic.php?p=106339#106339. I wanted to copy filters field by field from one table to another table. So I thought to use recordreference and field reference to do it so to avoid 1 line of code per field to be copied. These are the globals I need. All…
-
Store multiple company logo in one company
Originally discussed on this post: http://www.mibuso.com/forum/viewtopic.php?t=22153 Basically, on the company setup, create a new record and use the standard Navision form to upload you into the BLOB field. This will eliminate any need for modification (other than the reports)! :D
-
Date field not under 1753 in Native
Source: My Blog. Thanks to Kine's comment, I was able to create a somewhat workable solution. It's quite simple. Just add following code at the beginning of the MakeDateText-function in Codeunit 1: //*** Waldo BEGINIF EVALUATE(Date,DateText) THEN BEGIN IF Date < 01011753D THEN BEGIN DateText := ''; MESSAGE('Your Error…
-
G/L description to contain same text as Invoice Line
I have a client that wants the following customization: - When the user posts an Invoice he inputs a particular description in the Invoice line. - When the invoice is posted and the user goes to 'Navigate' and chooses to see G/L entries, in the description field there is something like 'Invoice SIV07000010'. - This client…
-
How to edit the Windows installer package (.MSI)
FYI - One of components supplied with the Windows SDK is "Ocra" - which allows the editing of the package (Has to be installed after SDK is loaded) URL to SDK installtion is below - http://www.microsoft.com/downloads/deta ... QhJQ%3d%3d
-
Debugger: Ctrl+F2
If you hit Ctrl+F2 in debugging mode, you can see that the line of code that is running is marked by a little blue square. What does it mean? I'm sure it's useful for something, but I don't find nothing on the Help... :-k
-
Stupid Trick
It's not very useful, but only to let you know (if you do not already know it)... If you copy a text constant (the whole line) and you paste it in the c/al globals (variables tab), it will be pasted instead in the text constants tab.
-
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…
-
Copying Error and Message Box
Hello Saw this in North American Monthly news. It's a great tip. Whenever you get an Error. Just Press Ctrl + C, and Navision copies the error to clipboard. You can then paste it notepad or an email and send the error. There a lot of times where you get errors in navision and then you have to find the record that is not…
-
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…
-
How simply to do "try-except" in NAV
Hi I propose simple method for catch an errors in NAV. Need such Automation: VBScript Automation 'Microsoft Script Control 1.0'.ScriptControl Example: IF NOT ISCLEAR(VBScript) THEN CLEAR(VBScript); CREATE(VBScript); VBScript.Language := 'VBScript'; Source := STRSUBSTNO('' + 'Function TryExceptMethod' + '%1%1' + ' On Error…
-
Get full domain userid
How to get full domain name and login ? If the login information is DOMAIN\john, the USERID field only return the value of "john" instead of full login information "DOMAIN\john". I need this function because I created a user authorization table which consist of windows login user (the customer use windows authentication),…
-
Autobackup from Navision Client (not NAS)
If you need to create an backup (*.fbk) from the Navision client automaticly, for example at 10:00pm you can use following form / the functions in this form. Note, that this is an example for working with WSH. OBJECT Form 59003 Checklist Make Navision Backup{ OBJECT-PROPERTIES { Date=12.10.07; Time=16:46:29; Modified=Yes;…
-
error in the database struture. The error(1190 in module 19)
When i want to take a backup from dynamics NAV, this error appaers: "There is an error in the database struture. The error (1190 in module 19) may have been caused by the computer or a program. Table: Item Compny: Key Fields: No." Please advice
-
Opening a Folder - Common Dialog (Simple Solution)
I searched the forum for a solution to open a folder from a path in a database field. There was a couple of answer's saying it was not possible or messy. If anyone is interested here is a workaround, using a field called "Document folder". txt: CommonDialogMgmt.OpenFile(Name,"Document Folder"+'.',1,'',0); Excel:…
-
Navision Client freezes when maximum input field is exceeded
I had the problem with several windows installations and Navision Financial Client 2.60 that the client freezes (hangs) when the maximum length of an input field is exceeded by the user. Normally, the client should just beep and do nothing. On my systems, the client freezed and could be unlocked only after waiting for some…
-
Barcode Font problem
I have tried to find a solution for this on the forum without success. My apologies in advance if I missed something. My problem is, some clients show a barcode correctly and others show the code *123456*, for example, as if the font is being ignored. I have installed the font Code39 on all clients. Can anyone advise me…