How do you reference fields returned from a Sql query. In the Example below I want to set a variable equal to the feature_id field returned
from my query. If this is not predefined how do I reference it?


SQL = Format("select feature_id from app_feature_assoc where service_no_id = %s and feature_id in (1865,1869,1870,1871,1874,1911,", OPENARRAY(TVarRec,(s)));
OracleDataSet1->Close();
OracleDataSet1->SQL->Clear();
OracleDataSet1->SQL->Add(SQL);
OracleDataSet1->Open();

The SQL doesn't seem quite right, but you can access the field(s) by name. For example: