引言: Then what's the different between ADODataset and ADOQuery? both need SQL syntex to work

引言: What is mean by 要回傳 result set ? can u give me an example?

begin
  ADOQuery1.Connection := ADOConnection1;
  ADOQuery1.Close;
  ADOQuery1.SQL.Text ;= 'Select * From TableA';
  ADOQuery1.Open;
end;

begin
  ADOQuery1.Connection := ADOConnection1;
  ADOQuery1.Close;
  ADOQuery1.SQL.Text ;= 'Delete From TableA';
  ADOQuery1.ExecSQL;
end;

引言: may be i am not very clever. I still don't understand

這麼說好了, 只要是 SQL 是 Select 開頭的 它就會回傳所 Select 的資料 這結果可以資料感知元件(像是 TDBGrid, TDBEdit等)來顯示 若 SQL 是 Insert/Update/Delete 開頭的話 它就不會回傳資料 咦？好像還是講得跟之前一樣! --- 每個人都是一本書

引言: yes, i understand now. thnx do u know anywhere I can find all the 'coding' for SQL? any site, or online tutorial that teach u all the basic coding. like insert, delete all.. etc?