Please correct me if I am making a wrong statement below: If a ADOQuery is Active, the SQL String in it will be running everytime. If a ADOQuery is Unactive, Type: ADOQuery,ExecSQL to will make the SQL String execute 'ONCE ONLY' If a ADOQuery is Unactive. ADOQuery.Active := True; will turn it on forever. (obviously) Please correct me if I have said anything wrong

If a ADOQuery is Active, the SQL String in it will be running everytime. Active -> Meaning the dataset is opened but not running, then sql command is sent once. If a ADOQuery is Unactive, Type: ADOQuery,ExecSQL to will make the SQL String execute 'ONCE ONLY' execsql function and open procedure are both send sql command once!! If a ADOQuery is Unactive. ADOQuery.Active := True; will turn it on forever. (obviously) set dataset active := true is the same to dataset.open !!

// the source of dataset.open from db unit
procedure TDataSet.Open;
begin
  Active := True;
end;

execsql is used to execute sql commands are 'update', 'insert', 'delete', open is used to get records from databse, the sql commands are 'select'. Both these two procedures are send the sql command once to DBMS. Execsql gets no records, just send sql command, but Open get records. --- DELPHI on-line help --- Call Open to set the Active property for the dataset to True. When Active is True, data can be populated with data. It can read data from a database or other source (such as a provider). Call ExecSQL to execute the SQL statement currently assigned to the SQL property. Use ExecSQL to execute queries that do not return a cursor to data (such as INSERT, UPDATE, DELETE, and CREATE TABLE). Note: For SELECT statements, call Open instead of ExecSQL or set the Active property to True.