🚀 go-pugleaf

You could create the vcl components on the fly, for example...

int RecordMax()
{
    int nWork;

    TQuery *qryTemp = new TQuery(this); // Create on the fly TQuery object
    qryTemp->SQL->Add(" SELECT MAX((LeftCaliper) nVar from 'calipers.db' ");
// Add a simple statement
    qryTemp->Open(); // Execute the statement (this is a return type query,
we expect one row)
    nWork = qryTemp->FieldByName("nVar")->AsInteger; // Use a temp variable
to get the value of highest record number
    qryTemp->Close(); // Close query, we have the value
    delete qryTemp; // Clean up!
    return nWork; // Reutrn control to calling function with max record
}
 hope this helps,

Regards Mark

"Ferran Barba" <reg@sifbm.com> wrote in message news:3d0fbf45_2@dnews...
> Hi,
>
> I'm new to BCB, coming from VB. I want to access (read, write, ...) an
> Access database WITHOUT using a form, like when using DAO/ADO objects in
VB.
> How can this be done?
>
> Thanks in advance.
>
> Ferran Barba
>
>
>