Devart Forums

I'm porting an ADOquery routine to UniQuery but am having difficulty with capturing field values from the dataset that is returned. Briefly, what I'm doing is running the query and setting a string variable = a field value:

UniQuery.SQL.Add('select * from customers');
UniQuery.Open;
UniQuery.First;
s := UniQuery.FieldValues['Name'];

The FieldValue property of the dataset is not recognized. Is there a workaround I can use? I can display the result in a DBGrid, but all I need is the value of the field.

s := UniQuery.FieldByName['Name'].AsString;
or
s := UniQuery.Fields[0].AsString;
etc.

Works like a charm.

There are a number of component members that aren't listed in the member list. Where can we find a complete list of available methods, properties, and events for each component including those that are inherited from components higher up in the hierarchy?

See the description of the TCustomConnection, TDataSet, and TField classes in the standard Delphi help.

Well, that brings me back to my original post. I had originally started with FieldValues as a property of TDataSet, but it is not available to me in the descendant TUniQuery. It appears that all of the members of TDataSet aren't inherited.

The FieldValues property is available in TUniQuery.