Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating tables in mssql from ado????

Status
Not open for further replies.

Transmitter319

Technical User
Feb 22, 2011
20
GB


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
 
Please Ignore above. Ive managed to get it all to work.
Thanks for looking

Glen
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top