Announcement

Collapse
No announcement yet.

Bug: Quick Search and Grid Lookup Method

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Bug: Quick Search and Grid Lookup Method

    Hi,

    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}
    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 ...

    Code:
    SELECT 
       Nachname
    FROM 
       Mitarbeiter 
    WHERE 
       MitarbeiterID = {MitarbeiterID}
    ... works fine.

    (SC 7.1.003)
    Best regards: - Reinhard -

    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

  • #2
    Forgotten: i use Quick Search Settings "All fields" and "contains".
    Best regards: - Reinhard -

    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

    Comment


    • #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

      Comment


      • #4
        Hi Bernhard,

        Originally posted by bartho View Post
        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.
        Best regards: - Reinhard -

        I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

        Comment


        • #5
          Missed that Reinhard. Sorry!

          regards,
          Bernhard Bernsmann

          Comment

          Working...
          X