Announcement

Collapse
No announcement yet.

[SOLVED]lookup in grid don't work !!!

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

  • [SOLVED]lookup in grid don't work !!!

    After the last update .26 I cant'n use lookup in grids, always obtain this error message

    Error
    Se produjo un error al acceder a la base de datos
    [Microsoft][Controlador ODBC Microsoft Access] Error de sintaxis (falta operador) en la expresión de consulta 'tipodoc = &nbsp'.
    SELECT nombre FROM tipos_doc WHERE tipodoc =   ORDER BY nombre

    Script: C:Program FilesNetMakev6wwwrootscriptcaseappconstructoragrid _informes_det_1grid_informes_det_1_lookup.class.ph p (49)

    the sql sentence is "select nombre from tipos_doc where tipodoc = {tipo} order by nombre"
    but now always tipo have only &nbsp ?????

    in other lookup, with proveedores tablle, the same error :
    SELECT nombre
    FROM proveedores
    WHERE id = {Proveedor}
    ORDER BY nombre

    the error is :
    Error
    Se produjo un error al acceder a la base de datos
    [Microsoft][Controlador ODBC Microsoft Access] Error de sintaxis (falta operador) en la expresión de consulta 'id = &nbsp'.
    SELECT nombre FROM proveedores WHERE id =   ORDER BY nombre

    Script: C:Program FilesNetMakev6wwwrootscriptcaseappconstructoragrid _informes_det_1grid_informes_det_1_lookup.class.ph p (49)

    please fix this bug I'am stoped !!!

    Thanks,
    Aquiles

  • #2
    Re: lookup in grid don't work !!!

    Hello aquiles,

    Have you tried to generate the application without the lookup and then set it again to see if the problem continues?

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      Re: lookup in grid don't work !!!

      the only solution was:

      make a view (a query in access) with all the fields filled by joins and make a grid application using this view as datasource

      Aquiles

      Comment


      • #4
        Re: lookup in grid don't work !!!

        In SC 6.026 with Mysql There was No Problem make a grid that lookup value from another table.

        See my attachment please.

        Suyono
        Attached Files

        Comment


        • #5
          Re: lookup in grid don't work !!!

          [quote author=suyonob link=topic=6571.msg16911#msg16911 date=1343138964]
          In SC 6.026 with Mysql There was No Problem make a grid that lookup value from another table.

          See my attachment please.

          Suyono
          [/quote]

          Hello,

          Was the lookup made on an existing field or a virtual field?

          regards,
          Bernhard Bernsmann

          Comment


          • #6
            Re: lookup in grid don't work !!!

            Existing Field Bernhard.

            Comment


            • #7
              Re: lookup in grid don't work !!!

              Hello,

              On the onScriptInit set some value to the field and you will be able to do a lookup regardless if it is a virtual or aan existing field.

              e.j.

              onScriptInit

              {myLookupField} = "something";

              regards,
              Bernhard Bernsmann

              Comment

              Working...
              X