Announcement

Collapse
No announcement yet.

Lookup bug

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

  • Lookup bug

    When i use a lookup for retrieve values and i use this SQL:

    SELECT TipoAtencion
    FROM tabla_tipoatencion
    WHERE ID = {TipoAtencion}
    ORDER BY TipoAtencion


    For ID = 2 (for example) tha correspond "Manuel" the grid show me:

    "2 Manuel"

    and not:

    "Manuel"

    Is this a bug?

    Thanks!

  • #2
    No, this is standard behaviour.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      As I can do to make it look just the description and not the ID?

      Comment


      • #4
        Usted debe agregarle el nombre del campo Nombre como segundo combre del campo:

        SELECT TipoAtencion, NombrePersona
        ...

        Comment

        Working...
        X