Database bound Charts


Q: How can I plot values from many fields of a single table record ?


In TeeChart 3.0, you should do this manually (using a Chart or DBChart or QRChart ):

DELPHI CODE : 

Series1.Clear;
Series1.Add( MyField1.AsFloat, '', clRed );
Series1.Add( MyField2.AsFloat, '', clBlue );
Series1.Add( MyField3.AsFloat, '', clGreen );

CBUILDER CODE : 

Series1->Clear();
Series1->Add( MyField1->AsFloat, "", clRed );
Series1->Add( MyField2->AsFloat, "", clBlue );
Series1->Add( MyField3->AsFloat, "", clGreen );

In TeeChart 4.0 , you can do this at design-time or run-time, setting this properties (using a DBChart or QRChart ):

DELPHI CODE : 

Series1.YValues.ValueSource:='MyField1;MyField2;MyField3' ; 
{separating fields with semicolon ";" }
Series1.DataSource:=Table1;

CBUILDER CODE : 

Series1->YValues->ValueSource="MyField1;MyField2;MyField3"; 
// separating fields with semicolon ";"
 Series1->DataSource=Table1;

Q: How can I use a calculated Field as Series points labels ?


TeeChart shows calculated fields at design or run-time in the editor dialog.Programatically at run-time, you should do this:

DELPHI CODE : 

Series1.XLabelsSource := 'MyCalcFieldName';

CBUILDER CODE : 

Series1.XLabelsSource := MyField.FieldName;

or

DELPHI CODE : 

Series1.XLabelsSource := MyField.FieldName;

CBUILDER CODE : 

Series1->XLabelsSource := MyField->FieldName;

(The field name as string, not the field object)


Q: How do I hide unwanted datasets from datamodules?

Answer provided by Mark Munte.

Create datamodules with:

DELPHI CODE : 

TdataModule.Create(nil);

CBUILDER CODE : 

new TDataModule(NULL);