TOracleDataSet and Bind Variables

[heuserj]

I am trying to populate a grid using the results of a query. The query has a where clause with a bind variable:

where clientid = :submit

The variable submit is defined as a string using the variable editor.

I use a lookup box to display a list potential values for submit.

How do I assign the value fro the list box to the bind variable and query the TOracleDataSet?

Thanks for your help

 

[F.Hinlopen]

Is this what you're looking for?
if (ListBox1->ItemIndex != -1)
{
DataSet1->SetVariable("submit",
ListBox1->Items->Strings[
ListBox1->ItemIndex];
DataSet1->Open();
.
.

}

------------------
Frans