Re: SV: SV: SV: [development-axapta] SQL Server 2000: since some weeks DB-size grows

Title: Melding Mit freundlichen Grüßen / Best regards / Med venlig Hilsen Jesper J¢rgensenConsulting mailto: [EMAIL PROTECTED] Aston Business SolutionsGmbHKettelerstr. 3-11D-97222 Würzburg-RimparGermany Tel.+49-9365-8075-0Fax+49-9365-8075-300 Work with a Winner. Aston Business

Re: SV: [development-axapta] Regarding Labels

Title: Meddelelse Hi Mikael, try deleting the .ali (index file) for the label file, start the application on the Server in 2-tier mode. Then restart the AOS. /Jesper Original Message processed by Tobit InfoCenter

Re: [development-axapta] sum

As you need to return a real not a record. static real MyTotal(Date _dd, Code _cc) { MyTable myTable; ; return (select sum (realfield) from myTable where myTable.Date == _dd myTable.Code == _cc).realfield; } /Jesper Original Message Subject:

Re-2: [development-axapta] How to change the filegroups of all the indexes of all tables

Title: How to change the filegroups of all the indexes of all tables Hidden in the development menu you will find a form "SYSSQLSetup" Use this to change the settings for the filegroups. Then Axapta will also use the settings doing the synchronization. /Jesper

Re: [development-axapta] Label with special user

Hi, check that the two users are both starting in the same language. If so try this: 1. Shut down the AOS. 2. Delete the file ax122lang.ali 3. Start axapta client on server in 2 tier mode searche any label, Axapta should now recreate the file *.ali if not existing. 4. Start the AOS again.

Re-2: [development-axapta] Transactions with multiple forms

HI, It is no Problem having interaction before the transaction. I use the class RecordInsertList to avoid using temp tables. /Jesper Original Message Subject: RE: [development-axapta] Transactions with multiple forms (05-Feb-2004 12:06) From: [EMAIL PROTECTED] To: [EMAIL

Re: [development-axapta] Regarding AOS

Title: Meddelelse Hi. have you restarted your AOS after updating (and stopping)the Oracle server? /Jesper Original Message processed by Tobit InfoCenter Subject: [development-axapta] Regarding AOS

Re: [development-axapta] Re: 45 GB Datebase with SQL2000

The SP3a should only be used with Axapta 3.0 SP2. Check the release notes. /Jesper Original Message Subject: [development-axapta] Re: 45 GB Datebase with SQL2000 (03-Mrz-2004 17:05) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] I think they work still with SP2. To use SP3a

Re-2: [development-axapta] want to understand how to create a record in the table (SQL) by writ

Hi Girish, could you not use the a batch job? /Jesper Original Message processed by Tobit InfoCenter Subject: RE: [development-axapta] want to understand how to create a record in the

Re: [development-axapta] Startup Menu

the class is xinfo method runStartupMenu(). Original Message Subject: [development-axapta] Startup Menu (18-Mrz-2004 14:36) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi, Is there someone that knows which class is responsible for composing the startupmenu. I am

Re-2: [development-axapta] Sending Fax using COM

Title: Message You get a error form the faxserver that Axapta can not resolve to a errormessage. Check if you get an object of FaxDoc. /Jesper Original Message processed by Tobit InfoCenter Subject:

Re-2: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIA

HI, Do you have Axapta tables in the database? If so the Axapta tables should be user tables. If all your tables are system tables you need to change the properties of the table. If the ownership on the tables is wrong you can eigther use the allready mailed solution to fix it.

Re-2: [development-axapta] Moving code between layers

Hi Stefan, you need to clean up the system table SQLDictionary to avoid loosing data when moving objects to a lower ID. You need to create a class that scan the data dictionary in Axapta and match that to the SQLDictionary on name not on id as the standard. You can browse the SQLdictionary

Re: [development-axapta] Speedup my Insert Records Process

Hi Jay, take a look at the update_recordset statement. /Jesper Original Message Subject: [development-axapta] Speedup my Insert Records Process (22-Jun-2004 6:52) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi Guys, I am try to Update like 5000 or more records and

Re: [development-axapta] Error when Creating Document in CRM Quotation

Hi Akash, Take a look at the template in word. The statement tries to fetch the first table in the template. Does the template have a table (for quotation lines), and is it the the first table in the template? // Jesper Original Message Subject: [development-axapta] Error

Re: [development-axapta] Tmp-data in Grid

Hi Morten, cteate a datasource of the table you want to display. If the form is linked you must overwrite the linkActive method. In the Method you add datasource.tmpdata(YourTable). Not the cursor of the datasource points to the tmpData. Take a look at the form LedgerTransBase in standard

Re-2: [development-axapta] Error when Creating Document in CRM Quotation

Hi Akash, The COM Object ComTable in an object in Word (ActiveDocument.Tables). The COM object in Axapta expects to find a table in your template. If not it throws an error unknown. Axapta tries to output the quatation lines in a table. Take a look at the templete in

Re: [development-axapta] element and this

Hi, element would be the father object. This is the current control element. If you are in a datasource in a form, this would be the datasource, to address an mothod from the form, you need to address it using element. /Jesper Original Message Subject: [development-axapta]

[development-axapta] SQL case statements

Hi all. Does anybody know a possibility to the SQL case statements in queries? /Jesper Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group,

Re: [development-axapta] Catch SQL-Exceptions from CONNECTION Class

Hi Bodo, Take a look the ODBCConnection. I think Claudia Göries wrote an answer last week. The class conenction always creates an connection to the current Axapta database. /Jesper Original Message Subject: [development-axapta] Catch SQL-Exceptions from CONNECTION Class

Re: [development-axapta] Re: LabelId's from Enum Values

Hi Ben, you get the result correct, but you change the language temporay for the session. I have solved the problem in the following manner: add this method to the class SysDictEnum: LabelId Value2LabelLabel(int value) { #Properties SysDictEnum SysDictEnum; TreeNode treeNode; ; return

Re: [development-axapta] return sqlstatement to user

You get a resultset(Class) from a statement. You extract a string with the method getstring. /Jesper Original Message Subject: [development-axapta] return sqlstatement to user (12-Nov-2004 13:33) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Im using the command

Re: [development-axapta] Re: return sqlstatement to user

HI try this static void SQLStmt_Demo(Args _args) { Connection Connection; Statement Statement; ResultSet ResultSet; str myString; ; // Create a new connection to the Axapta database connection = new Connection(); // Create a statement for the new connection Statement =

AW: [development-axapta] Error when calling WINGDI method..!

Hi, You need a handle to the windows process id. The example below gets the ID of Axapta. DLL user = new DLL('USER32'); DLLFunction getActiveWindow = new DLLFunction(user,'GetActiveWindow'); WINGDI Absi; ; GetActiveWindow.returns(EXTTYPES::DWORD); Absi=new

AW: [development-axapta] Add dynalinks programatically

Hi Lars, try this Table_q.dataSourceNo(1).addDynalink(fieldNum(Table, Field), element.args().record(), fieldnum(callerTable, RelationField) ); Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen NMS - Entwicklung Axapta arvato systems Technologies

AW: [development-axapta] Select where with a filter

Hi, You need to use * in Aaapra. If you are selecting with wildcards you need to use the keyword like not ==. /Jesper Von: Padmaja Iyingar [mailto:[EMAIL PROTECTED] Gesendet: Montag, 14. März 2005 05:06 An: development-axapta@yahoogroups.com;

AW: [development-axapta] operation from combination of enum

Hi You can loop over an enum like this static void EnumTest(Args _args) { SysDictenum dictEnum; Counter counter; ; dictEnum = new SysDictEnum(EnumNum(ABC)); for (counter = 0; counter dictEnum.values(); counter++) { print dictEnum.index2Name(counter); } pause; }

[development-axapta] Fielproperties

Hi all. Can I set a field (in a primary index) to case insensitive from within Axapta? I need to build hold the components a as well as A in the index. My database is set to Latin1_genarel_CP1_CI_AS. /Jesper Mit freundlichen Grüßen / Best regards / Med venlig hilsen

AW: [development-axapta] Fielproperties

Hi Herbert, I know, but in the SQL Server I can set a single row to use a different collation. I an looking for a possibility to control this row property on the SQL server from Axapta. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen NMS -

AW: [development-axapta] Open a excelfile

HI, use SysExcelWorkbooks Open to open an existing file. Workbooks add will always add a new workbook to the existing instance of excel. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen NMS - Entwicklung Axapta arvato systems Technologies GmbH An der

AW: [development-axapta] Fielproperties

Hi Herbert We are working on a module to dynamically convert charters upon import or export from Axapta. You need to substitute an Germany ö to #246; and a Ö to #214; in a XML format (Other scenarios are EBCDICT, ASCII etc.). It would have been nice if I could just change the collation

AW: [development-axapta] Re: Formbuilddatasource - adding a datasource runtime to an already running form

HI Lars, Take a look at the form SysRecordInfo, The form generates a new form and uses FormBuildDatasource. I am having problems attaching a new data source to an existing form at runtime. You can add a new data source, but you can not attach a table to the data source. /Jesper

AW: [development-axapta] statement where not and not like

Hi Lars, Sorry but I need to correct you concerning the support of like in Axapta. Axapta does support like. Try this out. static void TestLike(Args _args) { InventTable it; ; while select it where !(it.ItemId like '1*') { info(it.ItemId); } } /Jesper

AW: [development-axapta] How to connect to Axapta Installations for Data-Exchange

Hi Herbert, You can programme the inter company using COM, or use the commerce gateway and BizTalk in Standard. If you want the full inter company you need to implement it using COM, sorry. /Jesper _ Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED]

AW: [development-axapta] Urgent : How to upload data to generate Sales orders

Hi Preety, You should use the class SalesAutoCreate, or create an extension of it to meet your demands. Cheers Jesper Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von Priyank Krishna Gesendet: Mittwoch, 19. Oktober 2005 17:43 An:

AW: [development-axapta] Creating a class from class name

Hi Try this XUtilIdElements::find(UtilElementType::Class, 'ABCBase').id; Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Entwicklung Axapta arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED]

AW: [development-axapta] Re: Determine if a module is included

U can use the configurationkey to determin is a function is active, if you want to query on the licensecode try this. static void Job2(Args _args) { Dictionary dictionary = new Dictionary(); SysConfig sysConfigTemp; select sysConfigTemp where sysConfigTemp.id ==

AW: [development-axapta] How to find the data type of the field

Hi Try this: static void Job1(Args _args) { SysDictTable dictTable; SysDictField dictField; SysDictType dictType; SysDictEnum dictEnum; str baseType; Counter fieldCounter; Counter arrayCounter; ; dictTable = new SysDictTable(TableNum(CustTable)); for (fieldCounter =

AW: [development-axapta] Update field with switch-case

Hi there I have solved it a bit different, but you would be able to construct your scenario based on my code. I got a XML document with the table name or an alias for the table as XML element, as child elements I got the fields and needs to create a record in Axapta based on this.

AW: [development-axapta] Excel API

Hi, You could use the COM class wrapper wizard to implement all objects from a COM application in Dynamics Ax. You need to review a couple of objects after wrapping them. The wizard has problems with polymorph objects. The automatic implementation of e.g. the Range and the selection object

AW: [development-axapta] Pass temporary table data from form to report

Hi, just to make sure you does not get a stack trace at runtime you should check if the Method exists on the caller object. Object fr ; Table tt; // fr = element.caller(); If (formHasMethod(fr,identifierstr(updateControls)) // formHasMethod is implemented in Global. tt =

AW: [development-axapta] Bad response time on the CUSTINVOICEJOUR form

Hi Try using the code profiler to identify the problem. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und

AW: [development-axapta] Select records dinamically on form

HI, I have crated a form (Quick and Dirty) in 4.0 SP2 based on CustTable that shows U how to do that. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311

AW: [development-axapta] Who locks the table?

In the online User Form U see the SPID for an Ax user. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED]

AW: [development-axapta] Using Two localizations in One Application

Hallo Trinadh, this can not work. You will have two applications with differences in the data model. You need a database for each application. The US version is part of the sys layer in 4.0. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD

AW: [development-axapta] Enum values in SQL database

Hi, I have made a solution for the problem. You need to extract the labels from the enums in the AOT. Goes something like this: public void run() { EDAViewWizardEnum viewWizardEnumTable; EDAViewWizardLanguage viewWizardLanguageTable; Dictionary

AW: [development-axapta] User Groups

Hi Ricardo, The User Groups are stored in UserGroupInfo. The User Groups for a specific user are stored in UserGroupList. Be aware that the access rights in AX can be setup depending on the domain of the company account. Mit freundlichen Grüßen / Best regards / Med venlig hilsen

AW: [development-axapta] How do I know which field is sorted at, and the sortorder in a grid?

Hi Tore, You need to add the menuitem to the form CustTable. Exportfile for AOT version 1.0 or later Formatversion: 1 ***Element: FTM ; Microsoft Dynamics MENUITEM : CustSort unloaded ;

AW: [development-axapta] Axapta Backup Data

HI, SQL Backup. The export from Ax only exports one company account. If you mess up the recid's you are not able to restore the export. If you need a company based restore you restore your database with a new db name. In the company accounts you can restore one company from an external

AW: [development-axapta] CryptoAPI in 4.0 not available

HI Morten, Use cryptoblob2binary and cryptoblob2str from Global. If you want to protect your data using the WinApi_Server Class (cryptUnProtectData and cryptProtectData), be aware that the crypt / decrypt from Windows use a checksum from the machine doing the crypt, you need this

AW: [development-axapta] How to select distinct records from a column

No, select distinct is not implemented in Ax. You can achieve the same with: Select Field1, Field2 from Table Group by Field1, Field2 Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager Von:

AW: [development-axapta] Newbie Question - Range Syntax

Hi Letron, first of all, use SysQuery::findOrCreateRange to get your range. Use Global:QueryRangeConcat to create your reange value. The syntax is xx1, xx2, xx3. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato

AW: [development-axapta] Problem with try catch

Try this catch(Exception::Error) { Info(Failed); } Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED]

AW: [development-axapta] Problem with simple report.

Hi Try using the AX Standard way of getting an query for inventory on hand. You will find that on the table InventDim. Query query; QueryRunqueryRun; inventDimParm inventDimParmCriteria; inventDimParm inventDimParmGroupby; InventDim

AW: [development-axapta] Importing data into Invent table.

HI, is your InventDim there? (InventItemLocation.InventDimId = InventDim::findOrCreate(inventDim)? Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh

AW: [development-axapta] Printing BarCode Vertically in Report. Urgent!!!

HI, Have fun. You can not print Vertical and horizontal on the same report within Ax. I solved the problem by writing on a plain text printer, sending the native printer codes to a barcode printer. Not a nice solution, but it worked. The best solution is to look for a barcode printing

AW: [development-axapta] List of tables which are Savedataprcompany == false

HI You are close to the result. You can't assume, that the counter has the same value as the table id... Try this. I have excluded the maps, views, tmptables, and the system tables as well. static void findGlobalTables(Args _args) { Dictionary Dictionary;

AW: [development-axapta] HOW TO SENT FILE SFTP?

HI, you need an .net SFTP component you can add within Dynamics Ax. (Or an API as OCX / DLL / Com+ prior to 4.0). There are several providers for SFTP components. One of them is Eldos SecureBlackBox.

AW: [development-axapta] Borders in Excel with x++

Hi, Using the excel COM object you can select an range. In the range you can return the collector Borders and from there the object border. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies

AW: [development-axapta] Re: Integration with Axapta

Hi, if you are post 4.0 you should take a look at the AIF components. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh

AW: [development-axapta] Run an EXE from AX 2009 - Code Example

HI Use the WinApi Class. WinApi::shellExecute('Notepad.exe'); Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh

AW: [development-axapta] How to call a form method from method of other form

HI, the class Global has a method formHasMethod, to avoid a stack trace at runtime you might want to check if the caller has the method before you executes it using object. Object cannot validate the existence of the method during compilation. Best regards Jesper Von:

AW: [development-axapta] Re: How to show a webpage in Ax 3.0

HI Take a look at the form DocuView. Microsoft uses an ActiveX control Microsoft Web Browser. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh

AW: [development-axapta] Select statement is easy but I have trouble making the QueryBuildDataSource

Hi, You are adding the join condition twice qHeader.addRange(fieldnum(ALPurchReqTable, PurchReqId)) .value(strfmt(' (%1.%2 == %3.%4) ', purchReqLine_ds.query().dataSourceNo(1).name(), fieldStr(ALPurchReqLine, PurchReqId), purchReqLine_ds.query().dataSourceNo(2).name(), fieldStr(ALPurchReqTable,

AW: [development-axapta] Hide Button Based on User Permissions

Hi, Load the macro #Admin Implement this Method in the class Global static boolean IsUserInGroup (UserGroupId _GroupId = '', UserId _userId = CurUserId()) { #Admin UserGroupList info; ; if (!prmisdefault(_groupId)) _groupId = #AdminUserGroup; return (select recid

AW: [development-axapta] Disabling warming for number of companies licence

Hi, yes. You have exceeded your license you are missing the license key for unlimited Company accounts. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh

RE: [development-axapta] Ax2009 and W2008

Hallo James, check the entries in the event log proir to your termination log entry. Jesper From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of James Flavell Sent: Dienstag, 3. November 2009 11:53 To: development-axapta@yahoogroups.com Subject:

AW: [development-axapta] Using Ledger Purchase Invoice AIF Service

Hi, You can take a look at the standard documents (AX 4.0 and 2009). Inventory Journals AxdProfitLossJournal Ledger Journals AxdCustPaymJournal. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH

AW: [development-axapta] How To manipulate InventTable between companies

HI Why do you not create a table collection containing your table. You can setup an Virtual company account containing your table collection. Attach your two companies to your virtual company account. Your solution shares the table to all company accounts in the installation. Mit freundlichen

AW: [development-axapta] Help - AIF

Hi, Hope this helps. Generally we prefer using the Biztalk, but it is always an budget issue. a) pros cons of using BizTalk v/s File adapter v/s MSMQ? The BizTalk server is often mistaken for being a batch engine, if you plan to use the Biztalk server like that, save your money and use

AW: [development-axapta] AIF outbound acknowledgments

Hi, I only know the Return Order Acknowledgement Document within Dynamics AX 2009. I guess that is not what you are looking for, as Dynamics AX 2009 sends this. The process you describe we never solve within Dynamics AX, we prefer using the Biztalk server for that. The process monitoring

AW: [development-axapta] Launching AX forms and creating records in the form through .Net

Hi, the short answer is no. The .net connector from ax does not support forms or reports. You would have to start the ax client to open the form. You need to modify ax to launch a form during startup. Or you can consider building a .net form and utilize the application integration framework

AW: [development-axapta] AX4.0 how to know batch process is running

Hi James, We are solving that problem for a customer at the moment. You could check if the batch user is logged on to the SQL server, only that will not give you the answer you are looking for. The user can be logged on, and the batch process has crashed, or the user is not logged on, but the

AW: [development-axapta] Inbound Create Purchase Order AIF service

Hi Jennifer, there is no standard service to create purchase orders. The service you found is the purchase requisition that requires a purchase order to work. You will need to create a new service to be able for create purchase orders. For a complete listing of the AX standard services please

AW: [development-axapta] Inbound Create Purchase Order AIF service

Hi Jennifer, yes I do – I did ☺. What version are you implementing? Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh

AW: [development-axapta] Vendor Invoice Journal from Business Connector

The number Sequence uses two sessions (two concurrent users?) to allocate a new number. Check the eventlogs on the server to see if you have problems with your license. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato

AW: [development-axapta] How to get the used Table id in Ax 2009

Hi, why do you want to do that? The table ID is used internally in Dynamics AX to link objects in the development environment. It is also used to synchronize the data dictionary from Dynamics AX on the SQL Server. If you change the ID a table synchronizing the database will give you problems.