I genereated through code this statement
"SELECT Distinctrow HouseOwner.ID, House.Address, House.City, House.County, House.Country, House.Postcode, House.Description, House.Price, House.PriceCurrency, Images.ImageURL, PropertyStatus.StatusTitle FROM PropertyStatus INNER JOIN (((House INNER JOIN HouseOwner ON House.ID = HouseOwner.HouseID) INNER JOIN Images ON House.ID = Images.HouseID) inner join HouseType on House.HouseTypeID = HouseType.ID) ON PropertyStatus.ID = HouseOwner.PropertyStatusID WHERE Images.IsMain = True And (House.Address Like 's' or House.City Like 's' or House.County Like 's' or House.Country Like 's' or House.Postcode Like 's' or PropertyStatus.StatusTitle Like 's' or House.Description Like 's' or House.HouseSize Like 's' or HouseType.HouseTypeDesc Like 's') "
It works in access when i paste it in. but returns no results when in my code (but no errors). i'm using a jet 4 odbc connection
any ideas
"SELECT Distinctrow HouseOwner.ID, House.Address, House.City, House.County, House.Country, House.Postcode, House.Description, House.Price, House.PriceCurrency, Images.ImageURL, PropertyStatus.StatusTitle FROM PropertyStatus INNER JOIN (((House INNER JOIN HouseOwner ON House.ID = HouseOwner.HouseID) INNER JOIN Images ON House.ID = Images.HouseID) inner join HouseType on House.HouseTypeID = HouseType.ID) ON PropertyStatus.ID = HouseOwner.PropertyStatusID WHERE Images.IsMain = True And (House.Address Like 's' or House.City Like 's' or House.County Like 's' or House.Country Like 's' or House.Postcode Like 's' or PropertyStatus.StatusTitle Like 's' or House.Description Like 's' or House.HouseSize Like 's' or HouseType.HouseTypeDesc Like 's') "
It works in access when i paste it in. but returns no results when in my code (but no errors). i'm using a jet 4 odbc connection
any ideas