Thanks to Stefan and others. We were all pretty much on the same wave length.
I hooked Dave Shelly up with the MS program that get's you get tons of Bill's software for $299 to $399 This link will take you to a Microsoft site where you can get SQL 2000 2000 advanced server XP Professional Office XP professional Visio Exchange server and much more for $299 per year. It is one of the best investments I ever made. <http://www.microsoft.com:80/partner/businessresources/salesresources/action pack/> He is hopefully going to redo his Rbase app so it works with SQL and then maybe he will make it shareware. Until then I am mucking along with one Ben sent much like others. I type in the SQL statemenent and it executes and gives me results. Works fine for now. Dan on 5/2/02 5:42 PM, Stefan Gonick at [EMAIL PROTECTED] wrote: > Here's a simple TAF that does what you want. Just change the datasource. > > Stefan > > At 07:00 PM 4/29/2002 -0400, you wrote: >> 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 > > ======================================================== > Database WebWorks: Dynamic web sites through database integration > http://www.DatabaseWebWorks.com -- 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
