Yep I know I can do all that cool stuff in the DB interface. Problem here is I don't have remote access nor do I want to drive 45 minutes to get it.
Until they can set that up I want to be able to do some stuff from here. The Rbase solution is really cool and if it was open or could be purchased and used for other database solutions I would add it and pay for it in a minute. I wonder if the Rbase people can tell us if when we buy it we can convert it to SQL 2000 MySQL etc. I'd love to secure this and then run it on at least this site. Dan I set up something quick and dirty like the one Ben sent me off list and it will do the trick for now. Dan on 4/29/02 8:05 PM, [Gauthier] at [EMAIL PROTECTED] wrote: > Hi, > > I will also add that the 'visual' environment of MSSQL is surely the most > complete, primary there is no need to use a taf to do this > maybe you are planing to use a such possiblity to embed some automation or > tasks in the taf (installation of the application with the database > creation, global database administration...), so let us know. > > Another tips: > You could also obtain the 'general SQL script' menu by selecting almost any > icon in the enterprise manager and rightclicking it (database, tables, > procedures...), if you generate a complete database script don't forget to > check the 'script indexes' 'script...' in the 'options' tab of the dialog > > Gauthier > > PS: thanks to Scott to not being as exhaustive as he is so I can add a > little something ;) > > ----- Original Message ----- > From: "Scott Cadillac" <[EMAIL PROTECTED]> > To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> > Sent: Tuesday, April 30, 2002 12:41 AM > Subject: Re: Witango-Talk: Added and changing SQL tables > > >> 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 > > > ______________________________________________________________________________ > ifrance.com, l'email gratuit le plus complet de l'Internet ! > vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... > http://www.ifrance.com/_reloc/email.emailif > > > ________________________________________________________________________ > 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
