BUG: Autocomplete with sc_concat not work

Scriptcase 8 Bugs
#1

When to an Autocomplete Text or an Autocomplete Number field with the Lookup Query for example:


SELECT tblcountryid, sc_concat(de,' ', code)
FROM tblcountry

then the Autocomplete function does not work. SC 8.1.039

Please fix.

Best regards
Steve

#2

then the Autocomplete function does not work. SC 8.1.039

Works perfectly for me. Can you explain under wich situation is not working for you?

#3

I have two tables. One with the countries…

CREATE TABLE IF NOT EXISTS `tblcountry` (
  `tblcountryid` int(11) NOT NULL AUTO_INCREMENT,
  `code` char(2) CHARACTER SET utf8 NOT NULL,
  `en` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `de` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  UNIQUE KEY `tblcountryid` (`tblcountryid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

And one with locations (plants):

CREATE TABLE IF NOT EXISTS `tblplant` (
  `tblplantid` int(11) NOT NULL AUTO_INCREMENT,
  `tblcountryid` int(11) NOT NULL,
  `plantname` varchar(255) NOT NULL,
  `plantidnr` varchar(255) NOT NULL,
  PRIMARY KEY (`tblplantid`),
  KEY `tblcountryid` (`tblcountryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Whe i make a form on tblplants with a number autocomplete field on tblcountryid to tblcountry with this lookup statement:

SELECT tblcountryid, sc_concat(de,' ', code)
FROM tblcountry

then the autcomplete not work. With this lookup

SELECT tblcountryid,de
FROM tblcountry

it works perfect!

#4

True, is not working for me either with your tables

#5

Hi
okay, i just reported the bug to bug@scriptcase.net

Best regards
Steve

#6

Hello,

This problem has been reported to our development team.

@Artur_Oliveira told you that if you remove the ‘COLLATE utf8_unicode_ci’ of the columns ‘en’ and ‘de’ will work.

Thank you!