[SOLVED] Search Text field with autocomplete gives sql error

Scriptcase 9 Bugs
#1

Note: the following problem was not there in earlier version
problem description : in search module with grid if we begin with search and if in application sql we have some condition and the field type is text and autocomplete is turned on…
getting sql error where condition is added twice … e.g…Error
Error while accessing the database
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where (customerId > 100) where customerName = ‘’’ at line 1
select distinct customerName from customermaster order by customerName where (customerId > 100) where customerName = ‘’
This error is beside the field customerName in search module. if we turn off autocomplete, it works fine.

#2

The reported case was corrected in release 9.0.027. Version available for download and update.

#3

Thanks…its resolved