Hi,
in a Grid Lookup Method (Automatic) i have the following sql statement (generated with "Create Select"):
The use of Quick Search generated this error:
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 ...
... works fine.
(SC 7.1.003)
in a Grid Lookup Method (Automatic) i have the following sql statement (generated with "Create Select"):
Code:
SELECT sc_concat(Nachname, ', ', Vorname) AS MitarbeiterName FROM Mitarbeiter WHERE MitarbeiterID = {MitarbeiterID}
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
An simple sql statement without sc_concat() like ...
Code:
SELECT Nachname FROM Mitarbeiter WHERE MitarbeiterID = {MitarbeiterID}
(SC 7.1.003)
Comment