Bug: Quick Search and Grid Lookup Method

Scriptcase 7 Bugs
#1

Hi,

in a Grid Lookup Method (Automatic) i have the following sql statement (generated with “Create Select”):

SELECT 
   sc_concat(Nachname, ', ', Vorname) AS MitarbeiterName
FROM 
   Mitarbeiter 
WHERE 
   MitarbeiterID = {MitarbeiterID}

The use of Quick Search generated this error:

Call to a member function Execute() on a non-object in C:\Program Files (x86)\NetMake\v7\wwwroot\scriptcase\app\KIS\grid_wochenplan\grid_wochenplan.php on line 2022

I have check this line and found out, that use sc_concat() (or concat() from mysql) leads to this error.

An simple sql statement without sc_concat() like …

SELECT 
   Nachname
FROM 
   Mitarbeiter 
WHERE 
   MitarbeiterID = {MitarbeiterID}

… works fine.

(SC 7.1.003)

#2

Forgotten: i use Quick Search Settings “All fields” and “contains”.

#3

Hello,

Have you tried to use your DBMS concat function? Does the issue happens?

I have also reported the isuse to our bugs team.

regards,
Bernhard Bernsmann

#4

Hi Bernhard,

i wrote …

I have check this line and found out, that use sc_concat() (or concat() from mysql) leads to this error.

#5

Missed that Reinhard. Sorry!

regards,
Bernhard Bernsmann