Creating tables in mssql from ado????

[Transmitter319]

Hi All,

Sorry to ask this question but after some google and trying some code from different places I could not get it to work...

I have mssql express 2005 installed on another box on my network. Ive made a database and called it Essex from within mssql express 2005.

I dropped some dbgo components on a page and connected to the database on the another pc.

What I need to do once I have my program running is to be able to create a table when a user clicks on a button in my program...

And add some values...
i.e
table.tablename := 'dbo.Artists';
table.fielddefs.add('Name', ftString, 64, false);

etc... etc

I only have an example in BDE but I want to use dbgo but havnt been able to track one down....

when users unassign my button I will need to delete the table as well.....

Thanks for any help

Glen

 

[Transmitter319]

Please Ignore above. Ive managed to get it all to work.
Thanks for looking

Glen