I get an error Undeclared identifier 'Text' at 32:37  which is

var
   Ccapacity, Ctare, Cdotdate: string;

begin
     Ccapacity := SQLExecute('SELECT ContainerCapacity FROM Containers WHERE id=' + IntToStr(FillAContainer.Containerid.dbItemID) );
     Ctare := SQLExecute('SELECT ContainerEmpty FROM Containers WHERE id=' + IntToStr(FillAContainer.Containerid.dbItemID) );
     Cdotdate := SQLExecute('SELECT DOTInspDate FROM Containers WHERE id=' + IntToStr(FillAContainer.Containerid.dbItemID) );

     FillAContainer.contcapacity.Text := Ccapacity;
     FillAContainer.prodTare.Text := Ctare;
     FillAContainer.dotinspDate.Text := Cdotdate;
end;

example:

procedure Form1_ComboBox1_OnChange (Sender: string);
var
    Value1, Value2, Value3: string;
begin
    Value1 := SQLExecute('SELECT field1 FROM table WHERE id=' + IntToStr(Form1.ComboBox1.dbItemID) );
    Value2 := SQLExecute('SELECT field2 FROM table WHERE id=' + IntToStr(Form1.ComboBox1.dbItemID) );
    Value3 := SQLExecute('SELECT field3 FROM table WHERE id=' + IntToStr(Form1.ComboBox1.dbItemID) );

    Form1.Edit1.Text := Value1;
    Form1.Edit2.Text := Value2;
    Form1.Edit3.Text := Value3;
end;

in my form I want to do an onchange on a combobox
it should run a sql query on that table to get the whole row from the database into an array, then write those to the correct fields in the form.

I can set a variable and do math on it and then put the results in the fields already so I really just need to figure out how to get the database row that matches the value seleced in the combobox so I can get the values that I need to manipulate into the script.