Browse by Tags

• .NET Framework
• AIF
• AX2009
• C#
• How To
• Script
• Team Foundation Server
• Upgrade

Conflict error when list of fields is used in select during update transaction
14 October 09 10:32 AM | czdaxsup | 0 Comments   

If you use this code, you will get an error on the line 29. The error message is following: Cannot edit a record in Table1 (Table1). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record. Read More...

Filed under: X++

Error while calling Win API function on x64
13 October 09 08:47 AM | czdaxsup | 0 Comments   

When you are calling Win API function (or function from a native DLL) on x64 you get this error: An exception occurred when calling Function in Library name DLL library This happens only if the code calling the DLL function is running on server. The reason Read More...

Filed under: X++, AX2009

Rename object in TFS
10 September 09 03:23 PM | czdaxsup | 0 Comments   

You can get this error message while renaming object that is checked out from TFS. Unable to import Trying to import Table MFATable_test1 with ID 50003 ID already held by Table MFATable1 To rename the object you need to follow these steps: Right click Read More...

Filed under: X++, AX2009, Team Foundation Server

HOWTO: Print Word document from X++
08 September 09 10:42 AM | czdaxsup | 0 Comments   

You might need to print Word document directly from X++. Here’s a short sample how to do this: { str document = "C:\\test.doc"; COM wordApplication; COM wordDocuments; COM wordDoc; ; // Create instance of Word application wordApplication = new COM("Word.Application"); Read More...

Filed under: X++, How To

HOWTO: Dynamicaly load picture from base64 string into image on form in X++
28 May 09 09:49 AM | czdaxsup | 1 Comments   

You may want to load an image from base64 coded string. Then there is a code sample how to achieve it. First is needed to put an "Window" controll on the form with name ex. "imageWindow" and then modify "run()" method of Form. String then could be loaded Read More...

Filed under: X++, How To

Sending reports per e-mail from batch
22 May 09 11:03 AM | czdaxsup | 1 Comments   

I was facing an issue that no mails were arrived while sending invoices in PDF from a batch. Sending e-mails from a client worked fine. The reason is in enabled SMTP relaying on customer's mail server and in \Classes\RunbaseReportStd\serverSendMail method. Read More...

Filed under: X++, AX2009

How to execute an external process from a batch
23 April 09 10:56 AM | czdaxsup | 1 Comments   

You might need to execute an external process in a batch and you’re thinking about using WinApi::shellExecute() method. Unfortunately the whole WinApi class is set to run on client. Also the method WinApi::shellExecute() is marked as client method. That Read More...

Filed under: X++, How To

Blocked queries on any change in AOT
16 April 09 03:02 PM | czdaxsup | 1 Comments   

You may face a blocking issue on SQL Server each time you do any change in AOT. And you’re using database log. This is the problem. While using database log an insert trigger on SysDatabaseLog table is always dropped and recreated what is causing blocking Read More...

Filed under: X++

HOWTO: Using WinAPI FindFirstFile, FindNextNext in Batch Jobs.
13 March 09 02:56 PM | czdaxsup | 1 Comments   

In batch job is not posible to call WinAPI functions WINAPI::FindFirstFile(..) and WINAPI::FindNextFile(...) . This is limited only for code running on client. Sometimes is necesary have similar function for code running on server (or in batches). There Read More...

Filed under: X++, .NET Framework, How To, AX2009

Running direct SQL code using Connection class
13 March 09 02:49 PM | czdaxsup | 0 Comments   

Sometimes you need to use direct SQL code in your methods. The easiest way is to use Connection class. However you might run into the error “ Request for the permission of type 'SqlStatementExecutePermission' failed. ” This is because you’re using the Read More...

Filed under: X++

Calling external web services from AX
13 March 09 09:12 AM | czdaxsup | 1 Comments   

While calling external web service from AX you might experience following error: Object 'CLRObject' could not be created This is because web services must be called from code running on server. That why you need to set the class’s RunOn property to Server Read More...

Filed under: X++, AIF

HOWTO: Calling and using Com Connectror from VBS script.
03 February 09 03:06 PM | czdaxsup | 0 Comments   

For simple and fast testing of COM Connector you could use following VBS Script. Just copy code and paste it into file named <NAME>.vbs Dim oCom Dim sVers Dim sBuild Dim result Set oCom = CreateObject("AxaptaComConnector.Axapta3") oCom.Logon "", Read More...

Filed under: X++, How To, Script

Error during data migration while upgrading to AX 2009
02 February 09 11:17 AM | czdaxsup | 1 Comments   

When you're upgrading your existing AX 3.0 SP6 environment to AX 2009 you may run into following error: Object Server 01: The database reported (session 5 (Admin)): [Microsoft][SQL Native Client][SQL Server]The specified schema name "DOMAIN\COMPUTERNAME$" Read More...

Filed under: X++, Upgrade

HOWTO: Sending mail from AX using .NET Framework.
03 December 08 03:08 PM | czdaxsup | 0 Comments   

Sometimes happen that SysMailer class (using CDO) is not the right solution for sending mails with attachments. There is a little sample of X++ Job that is using System.Net.Mail namespace to achieve same. static void JobNETSendMail(Args _args) { System.Net.Mail.MailMessage Read More...

Filed under: X++, .NET Framework, How To

Casting .NET objects in X++
22 October 08 09:44 AM | czdaxsup | 0 Comments   

To cast any .NET object it is necessary to first assign the value you need to cast to an instance of CLRObject and then you can assing the instance of CLR object into an instance you need, like assinging System.Net.WebRequest instance into System.Net.HttpWebRequest Read More...

Filed under: X++, .NET Framework