Hello friends. I´m from Spain and here i´m trying a project using c++ builder compiler , but i´ve a little problem using a tquery object. I mean:
We can supose we´ve got a table (created by Database Desktop) named simply "Men" with three fields: first field name "Number_Id" , Second field named , "First_Name" , and a third field named "Last_Name". Ok , but i can´t select only a field making the query.This is the problem. Making this:
Query1->SQL->Add("SELECT Men.Number_Id FROM Men.db");
I get this error Message: "Field 'First_Name' Not Found"
If The query is this:
Query1->SQL->Add("SELECT Men.Number_Id , First_Name FROM Men.db");
I get this error Message: "Field 'Last_Name' Not Found"
It´s the same if i don´t select Number_Id in the query.
If i select all in the query ,( i mean:"SELECT Men.Number_Id , First_Name , Last_Name , FROM Men.db" or is the same: "SELECT * FROM Men.db") is all right , all OK.
So...i can´t select only a field in the query. WHY?? . Any help please?