Make a Dynamic Database ( Use Alter Table Command from SQL in DELPHI )
Posted on 2001-07-03
I wana make a dynamic DataBase in my program. that means the structure of DataBase( Fields ) can be chnge with User.
This Change Can Make by Some Packages Like DataBase Desktop in Delphi , but I want the User Can Do It In my Program.
For Solving This Problem I used SQL Components, and Do somthing Like This :
Querry1.SQL.Text := 'ALTER TABLE Country ADD column Products char(40)'; //
but it makes Error!
if you Use This Command ('ALTER TABLE') please Help me and if think another way is better please tell me.