Bug: Quick Search and Grid Lookup Method

[RHS]

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_w ochenplan\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)

[RHS]

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

[bartho]

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

[RHS]

Hi Bernhard,

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

i wrote ...

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

[bartho]

Missed that Reinhard. Sorry!

regards,
Bernhard Bernsmann