Slow ZipCodeLookup

If you have lots of zipcodes in your Zipcode table, you will get the problem that when you click on the lookup button of your zipcode field and it happens that the content of the zipcode field is one of the last records in your table, you will have to wait and wait and wait...

Reason: in the form ZipCodeLookup, method "run", the standard system uses the function "findrecord". Findrecord will go through the table and compare each record with the one you search! This is the same as if you would go down the form clicking each record.

The sad thing is: there's not much you can do about it. The only thing I thound was to replace the findrecord method with a filter.

Advantage: the lookup will show up immediately.
Disadvantage: the lookup form will only show records that match the zipcode from the previous form. Here's what you have to change in the method:

if (zipCodeCurrent)
{
//zipCode_ds.findRecord(zipCodeCurrent); // Ori
// Replace original line above with next line
zipCode_ds.query().dataSourceTable(tableNum(ZipCode)).addRange(fieldNum(ZipCode, ZipCode)).value(zipcodecurrent.ZipCode+".."); zipCode_ds.executeQuery();
}

Give it a try! And tell me what you think about it!

Axapta 3.0 and SQL 2005

To one of the earlier posts, Bernard added a comment which I will put here, as it contains very good information about the topic:

Microsoft is currently planning to make a kernel change to Microsoft Axapta 3.0 SP4, so that the solution will be able to support the Microsoft SQL Server 2005 database. We expect that the kernel change will be available through a General Distribution Release (GDR) in January 2006. Please see the timeline below for details on Microsoft SQL Server 2005 support.

• January 2006: GDR release is planned to provide Microsoft SQL Server 2005 support for Microsoft Axapta 3.0 SP4. Microsoft Axapta 3.0 SP4 is not expected to support the new SQL Reporting Services and Report Builder

• March 2006: Planned release for Microsoft Axapta 3.0 SP5, with support for Microsoft SQL Server 2005. Microsoft Axapta 3.0 SP5 is not expected to support the new SQL Reporting Services and Report Builder

• June 2006: Planned release for Microsoft Dynamics AX in initial regions. Microsoft Dynamics AX is expected to support the Microsoft SQL Server 2005 database and SQL Reporting Services, including Report Builder

More information on the GDR kernel change will be announced as the release date draws closer.Microsoft Dynamics AX and SQL Server 2005 Aligned to Deliver Next Generation of Integrated Business Solutions

Integration with Microsoft SQL Server 2005 is key to delivering adaptable business solutions. Microsoft Dynamics AX, the next release of Microsoft Axapta, is being designed to take advantage of the business intelligence, data management, enhanced performance and high availability features of Microsoft SQL Server 2005.