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;