RE: [Axapta-Knowledge-Village] SQLLiteral is giving wrong result

2007-10-04 Thread mit
Hi, the N' is because strings are UNICODE in Microsoft Dynamics 4.0. N' is the SQL notation for UNICODE strings. It is not a bug. It is by design. Regards EG Utility A/S Michael Troelsen _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of gopala

RE: [Axapta-Knowledge-Village] Running Axapta 4.0 from other application.

2007-06-30 Thread mit
Hi There is no way to do this in Axapta besides using old technology. You must create a Dynamic Data Exchange (DDE) server in Axapta. We have created a small server which can run some specific forms with parameters as input. DDE however is not going to be supported in future versions. It

RE: [Axapta-Knowledge-Village] Re: AX data management/archiving

2007-05-24 Thread mit
Hi, You could also leverage SQL 2005 partitioning. This way you can split a table by a date and move data/index to a slower set of disk. Only con is that you have to use Enterprise edition. http://www.microsoft.com/technet/prodtechnol/sql/2005/spdw.mspx Regards EG Utility Michael Troelsen

RE: [Axapta-Knowledge-Village] Converting Axapta Oracle DB to MSSQL 2005 using MSSQL Migration Assistant?

2006-03-31 Thread mit
Hi Contact [EMAIL PROTECTED] he has a whitepaper on how to migrate from Oracle Axapta to MS SQL2000 Axapta. Regards Michael -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of David Casas Sent: 30. marts 2006 22:10 To:

RE: [Axapta-Knowledge-Village] Out Of Memory Error

2005-07-23 Thread mit
Hi, You have a memory leak somewhere in you code. The only way to find out is to use the Windows Task manager or sysinternals process explorer and look at the column mem delta. Step thru your code and try to determine which statement is causing the memory leak. You can do this by comment out