🚀 go-pugleaf

Hi!


First you have to place some object so you can access your database.
1 DataSource linked to the database
2 Table with the tabels you want to use.
1 SQLQuery compontent.

Code for running a SQL statement could be something like this:

    szSQLStatement = "SELECT SELECT LName, FName, Name FROM Person,
PersonHistory, Company
                                   WHERE Person.PersonID =
PersonHistory.PersonID AND ersonHistory.CompanyID = Company.CompanyID");
    Query->Close();
    Query->SQL->Clear();
    Query->SQL->Add(szSQLStatement);
    Query->Open();
    Query->First();

    while(!Query->IsEmpty())
    {
       //Do something with the fetched data.
       Query->Next();
    }




/Ola



Uros Obradovic wrote:

> Hi guys,
> I'm having with DBGrid, actually I would say I don't know how to do
> following.
>
> In DBGrid control, I have 4 Columns
> - Last Name
> - First Name
> - Company Name
>
> where Last Name and First Name are from one table, and Company Name from the
> other.
> Last Name and First Name columns are pointing to LName and FName fields in
> Person Table respectively,
> but Company Name is in the other table.
> I would like to use the following SQL statement and have the results in
> Company Name column.
>
> SELECT LName, FName, Name
> FROM Person, PersonHistory, Company
> WHERE Person.PersonID = PersonHistory.PersonID
> AND PersonHistory.CompanyID = Company.CompanyID
>
> How can I do that ?
> Hope you understand my question
>
> Thanks
> Uros