Hi Dan, Not trying to beat a dead horse, but what you are trying to do sounds simple enough.
A file table.taf would have a single dbms (using the appropriate datasource) depending on what you are trying to do. Your sql syntax may vary... but in the RBase world: to create a table: create table mynewtable (mynewcol1 text 10, mynewcol2 text 20) or to delete a table: drop table mynewtable or to add a column: alter table mynewtable add mynewcol3 text 30 or to drop a column: alter table mynewtable drop mynewcol3 -----Original Message----- From: Dan Stein <[EMAIL PROTECTED]> To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> Date: Monday, April 29, 2002 4:25 PM Subject: Re: Witango-Talk: Added and changing SQL tables Thanks, I'll hang for a little while in case someone has developed a taf file that lets me add the table name and column, type etc and then add it based on that criteria. My problem is that the DB is remote and right now I can't access it till they give me a way in. Thought if I built the taf I would just be able to test the SQL here and then do it there. I guess I could build a taf where you enter the SQL in a text field and then the DBMS uses the ARG that is generated. I would have to figure out how to encode it so it arrives correctly but I guess something simple like that would work. Dan on 4/29/02 6:41 PM, Scott Cadillac at [EMAIL PROTECTED] wrote: > Hi Dan, > > You can use a Direct_DBMS Action and Transact-SQL to create and modify > Tables, Fields, Indexes, Triggers, etc... > > I don't have TAF for this, but check out the Query Analyzer that comes with > SQL-Server - it'll teach you and show you templates for doing exactly these > kinds of things. Also, when you are looking at the Design View of a Table in > Enterprise Manager, use the 'Generate SQL Script' button to show you how > Transact-SQL is used to build tables and such. > > Good Luck. Cheers.... > > > Scott Cadillac > http://xml-extra.net > [EMAIL PROTECTED] > > > ----- Original Message ----- > From: "Dan Stein" <[EMAIL PROTECTED]> > To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> > Sent: Monday, April 29, 2002 3:25 PM > Subject: Witango-Talk: Added and changing SQL tables > > >> Seems to me there should be away for me to use a Tango app to added or >> modify SQL tables. I'm using SQL 2000. Anyone have one written? >> >> Dan >> >> >> -- >> Dan Stein >> Digital Software Solutions >> 799 Evergreen Circle >> Telford PA 18969 >> 215-799-0192 >> 610-256-2843 >> Fax 413-410-9682 >> FMP,Tango, EDI,SQL 7 >> [EMAIL PROTECTED] >> www.dss-db.com >> >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body >> > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 215-799-0192 610-256-2843 Fax 413-410-9682 FMP,Tango, EDI,SQL 7 [EMAIL PROTECTED] www.dss-db.com ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
