Method Community

 

MethodAPISelect_DataSetV2 and Entity Table

Last post 10-23-2015 10:25 AM by ITfromValor. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 10-23-2015 8:25 AM

    MethodAPISelect_DataSetV2 and Entity Table

    Hi. I am trying to get a field from the Entity table so I can insert the same info into another table, but the only info I can use to search the Entity table at that point is the BillAddressAddr1, not the RecordID. If I use MethodAPISelect_DataSetV2 and the RecordID, I get the info I need, but not when I use sSelectWhere = "BillAddressAddr1 =" + house_address; 

    I am not sure what I am doing wrong, and I would appreciate your help.


    sSelectFields = "HouseKind";
    sSelectFrom = tbl; // tbl = "Entity"
    sSelectWhere = "BillAddressAddr1 =" + house_address; // house_address is correct, I checked several times
    sSelectGroupBy = null;
    sSelectHaving = null;
    sSelectOrderBy = "RecordID DESC";

    //Call the MethodAPI to get the dataset
    sResult = wbsMethodAPI.MethodAPISelect_DataSetV2(sCompanyAccount, sUserName, sPassword, "", ref datResponse, sSelectFrom, sSelectFields, sSelectWhere, sSelectGroupBy, sSelectHaving, sSelectOrderBy);
    wbsMethodAPI = null;


  • 10-23-2015 9:16 AM In reply to

    Re: MethodAPISelect_DataSetV2 and Entity Table

    Try this add single quote as below

    sSelectWhere = "BillAddressAddr1 ='" + house_address + "'"; 

    Mark Crews
    Cloud Consultancy
    Principal and Developer


    • 2012 MethodCRM Partner of the Year

    • 2012 MethodCRM Community Excellence Award

    • 2011 MethodCRM Community Excellence Award


    Visit our website to find out about our training, support, and customization services.
    website: cloudconsultancyllc.com
    blog: cloudconsultancyllc.com/blog/
    ph: 434.326.1601
    e: support@cloudconsultancyllc.com

    What is Method?
  • 10-23-2015 10:25 AM In reply to

    Re: MethodAPISelect_DataSetV2 and Entity Table

    Seems to be working! Thank you!

Page 1 of 1 (3 items)