Adding a field to a table at runtime

[Ronin441]

I know how to create a table at runtime by setting up FieldDefs and IndexDefs and calling CreateTable; but how can I add fields and indeces to an already existing table? -- Doug Burbidge mailto:doug@ultrazone.com

http://home.iprimus.com.au/dougburbidge/

 

[LucieLastic]

hi

You could build the Query in the SQL property of a TQuery at runtime(or design time) and call MyQry.ExecSQL.

lou

 

[Ronin441]

/me goes away and reads about TQuery for an hour
/me goes away and reads SQL language reference for an hour

Very cool! Problem solved in one line of code:

MyDatabase.Execute('ALTER TABLE ' + TableName + ' ADD myfield1 VARCHAR(8), ADD myfield2 VARCHAR(8);', nil, False, nil);

OK, so it took me two hours to write that one line of code, but it's still cool. -- Doug Burbidge mailto:doug@ultrazone.com

http://home.iprimus.com.au/dougburbidge/