Method Community

Method:CRM

 

Method Community » Method:Classic » Method:Classic General Q&A » SQL Error with Customer Grid

SQL Error with Customer Grid

Last post 01-20-2015 1:00 PM by BLCPA. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 01-16-2015 11:34 PM

    • BLCPA
    • Top 500 Contributor
    • Joined on 01-05-2015
    • Posts 7

    SQL Error with Customer Grid

    Reply Contact

    I am creating a screen based on the Customer table and have a grid.  I want to have multiple fields in a single column, so am trying to use a SQL override.  I copied the same code that is in the Contact List:

    '<b>' + ISNULL(viewContacts.AssignedTo,'') + '</b><br />' + '<i>'  + ISNULL(viewContacts.SpecialType,'') + '</i><br />' + ISNULL(viewContacts.Title,'')

    I made the following modifications:

    '<b>' + ISNULL(viewCustomer.FullName,'') + '</b><br />' + '<i>'  + ISNULL(viewCustomer.AssignedTo,'') + '</i><br />' 


    Seems like the code is identical.  I have verified the table and field names are accurate.  However, when I publish and load the page, I get an "Error Generating Grid" message.


    Can you tell me where I am going wrong on this?

  • 01-19-2015 12:29 PM In reply to

    Re: SQL Error with Customer Grid

    Answer
    Reply Contact

    Hi BLCPA,

    Try replacing the full viewTable.FieldName with just the FieldName. I was able to get it to function this way.

    Let me know if that helps.

    - Justin

    Justin Henderiks
    Technical Sales Specialist
    Method Integration Inc.
    Toll Free: 1.888.925.6238
    Local and overseas: 416.847.0400
    Fax: 416.640.6027
    E-mail: j.henderiks@method.me

  • 01-20-2015 1:00 PM In reply to

    • BLCPA
    • Top 500 Contributor
    • Joined on 01-05-2015
    • Posts 7

    Re: SQL Error with Customer Grid

    Reply Contact

    Great, thank you Justin.  This worked!
Page 1 of 1 (3 items)