Category: Database
Title: Create a table including an AutoInc field (ADO/MSSQL)
Date added: 15.03.2006
Hits: 7525

uses AdoDB;
var
  q: TAdoQuery;
  db: TAdoConnection;
begin
    q := TADOQuery.Create(nil);
    q.Connection := db;
    q.Close;
    q.SQL.Clear;
    q.SQL.Add('Create Table TABLENAME (ID COUNTER PRIMARY KEY, MYTEXT1 String, MYTEXT2 String);');
    q.Prepared := True;
    try
      q.ExecSQL;
    except
end;
    q.Free;
end;

1. How to select all Fields in a TDBGrid? (5217 Hits)

2. How to add field to table at runtime? (9998 Hits)

3. How to add a Row Number in your DBGrid? (9186 Hits)

4. How to get Rid Of the Annoying SQL Wait Cursor? (2962 Hits)

5. How to select a random data record? (3694 Hits)

For any problems or recommendations about Delphi Tricks site, please

feel free to contact us on that e-mail: support@delphitricks.com.
If you want to advertise on the site use that e-mail: advertise@delphitricks.com.

You can freely use or modify these Delphi source codes for non-commercial use. We are not responsible of any damages that can be caused by the utilisation of that source codes.