VERSION(S):

E-Common 2.3.1 

SITUATION IDENTIFIED IN:

E Common 2.3.1

SITUATION DESCRIPTION:

In the EManager/ECommon/Addresses page select an address.
Now select the link "view BP by address" and select the "last page" button. Now select the "previous page" button and 
see this error occur:

Error: "EELibrary.DRecordset: Parameter error: Unable to execute the SQL query: " SELECT BP.NAME FROM BUSINESSPARTNERADDRESS
BPA INNER JOIN BUSINESSPARTNER BP ON BPA.BUSINESSPARTNERID = BP.BUSINESSPARTNERID WHERE ( BPA.ADDRESSID = 3 ) where 
(NAME < 'C1000 Amsterdam' or NAME is null) order by NAME DESC". ADO Error: 80040E14: [Microsoft][ODBC SQL Server Driver]
[SQL Server]Incorrect syntax near the keyword 'where'. Provider error 1: NativeError: 156. SQLState: 37000. Number: 80040E14.
Source: Microsoft OLE DB Provider for ODBC Drivers. 
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'where'.


SOLUTION DESCRIPTION:
This probles is fixed by an modified query.
The solution can be found on the Support FTP Site.

SOLUTION DESCRIPTION: The solution can be found on the Support FTP Site.

It contains 2 files.

1 - readme.txt: This solution description

2 - 231.3.120418.exe
       Copy this file to your local web server. Extract to a temp folder and run the install.exe. This installation program will execute the following tasks:
	-	Check on pre-requisites and dependencies
	- 	Detect the current configuration settings
	- 	Create a pre-install report for customizations
	- 	Install the Webapplication files
	- 	Install/register Com and MTS Components
	- 	Backup the customized files and copy these files in a sub folder of the E-Enterprise installation folder.
	- 	Create a log file for each installation task and place these files in a sub folder of the E-Enterprise installation folder.
	-	Update the Registry and Metabase after the installation


The extracted solution folder contains 1 file
-  web\e-common\manager\bpsbyaddress.asp
	
PATH TO SOLUTION:
ftp://ftp.support.baan.com/updates/E-Enterprise/E-Common/231/Sol_After_SP3/231.3.120418