david

I use dbExpress with Oracle 9i. Should be the same for 8.
example below.

dMod->ClientDataSet1->Active = false;
dMod->SQLDataSetCUST->CommandType = ctQuery;
dMod->SQLDataSetCUST->CommandText = "select AccountNum, Name, Contact,
Email \
from customer where AccountNum =
:AccountNum";

dMod->SQLDataSetCUST->Params->Items[0]->AsString = cmbAccountNum->Text;
dMod->ClientDataSet1->Active = true;
if (dMod->ClientDataSet1->RecordCount) {