I am implementing Project in vc++ 12 MFC. back-end is access database. I want to select all four columns values in one row into four variable.
My query is:
m_txt = "select CompanyName As m_CompanyName, Model As m_Model, OrderNo As m_OrderNo, StreetAddress As m_StreetAddress , Phone As m_Phone, Logo As lg1 from Companies
and I also want to get know how to specify where clause here as
m_txt = "select CompanyName As m_CompanyName, Model As m_Model, OrderNo As m_OrderNo, StreetAddress As m_StreetAddress , Phone As m_Phone, Logo As lg1 from Companies where CompanyName="+s1;
That's how we write query in MySql or Sql server, s1 is variable of string type but in vc++ at + sign it gives error.
please help,it is very urjent