Announcement

Collapse
No announcement yet.

NEST Grid Tables Error

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

  • NEST Grid Tables Error

    Okay, so I am attempting to nest a grid.

    I have a grid displaying table pm_companies, within this grid I would like to nest table pm_tenants to match up with each company. So I have this syntax

    SELECT
    Company,
    Tenant,
    Address,
    City,
    `Zip Code`,
    Phone
    FROM
    pm_tenants
    WHERE Company = `[Company]`

    and I get this error when I test it out...
    Error
    Error while accessing the database:
    Unknown column 'CA Gold Properties' in 'where clause'
    select count(*) from pm_tenants where Company = `CA Gold Properties`

    So I attempted to set the `[Company]` as `[glob_Company]` and I get a no global defined error. I have tried everything I know. Help please.

  • #2
    It could be a wrong quote, it looks the left upper quote in stead of '
    Also you can try to set it between double quotes "
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      That was it. Wrong Quotes. Thank you, never even thought of that.

      Comment

      Working...
      X