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
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE TAF SYSTEM "tango.dtd" >
<TAF Version="0x02000002">
<Comments />
<!--Main program-->
<Program>
<ActionRef Ref="If_SQL_Form">
<ActionRef Ref="Branch_SQL_Form1" />
</ActionRef>
<ActionRef Ref="Elseif_Execute_SQL">
<ActionRef Ref="Direct_DBMS" />
<ActionRef Ref="Branch_SQL_Form" />
</ActionRef>
<ActionRef Ref="Return" />
<ActionRef Ref="Group_SQL_Form">
<ActionRef Ref="Results" />
</ActionRef>
</Program>
<!--Program actions-->
<Actions>
<IfAction ID="If_SQL_Form" Sig="if ">
<Expression><![CDATA[(!LEN('<@ARG _function>'))]]></Expression>
<ExpressionInfo>
<ExpLeft><![CDATA[<@ARG _function>]]></ExpLeft>
<ExpRight />
<Operator>iemp</Operator>
</ExpressionInfo>
</IfAction>
<BranchAction ID="Branch_SQL_Form1" Sig="bran">
<ActionName>Group_SQL_Form</ActionName>
</BranchAction>
<ElseIfAction ID="Elseif_Execute_SQL" Sig="elif" Expanded="True">
<Expression><![CDATA[('<@ARG _function>'='sql')]]></Expression>
<ExpressionInfo>
<ExpLeft><![CDATA[<@ARG _function>]]></ExpLeft>
<ExpRight>sql</ExpRight>
<Operator>iseq</Operator>
</ExpressionInfo>
</ElseIfAction>
<DirectDBMSAction DSID="Real-Estate-Connection.com"
DeploymentDSID="Real-Estate-Connection.com.1" ID="Direct_DBMS" Sig="cust">
<Custom><![CDATA[<@ARG SQL encoding=none>]]></Custom>
<ResultsOutput Ref="Direct_DBMS.Results" />
</DirectDBMSAction>
<BranchAction ID="Branch_SQL_Form" Sig="bran">
<ActionName>Group_SQL_Form</ActionName>
</BranchAction>
<ReturnAction ID="Return" Sig="stop" />
<GroupAction ID="Group_SQL_Form" Sig="grop" />
<ResultAction ID="Results" Sig="null">
<ResultsOutput Ref="Results.Results" />
</ResultAction>
</Actions>
<!--Data sources-->
<DataSources>
<DataSource ID="Real-Estate-Connection.com">
<DSType>ODBC</DSType>
<DSN>Real-Estate-Connection.com</DSN>
<DBMS />
<Host>Real-Estate-Connection.com</Host>
<Database />
<UserInfo Encrypted="True">
<UserName />
<Password />
</UserInfo>
</DataSource>
<DataSource ID="Real-Estate-Connection.com.1">
<DSType>ODBC</DSType>
<DSN>Real-Estate-Connection.com</DSN>
<DBMS />
<Host>Real-Estate-Connection.com</Host>
<Database />
<UserInfo Encrypted="True">
<UserName>%DD%FE%ED%86%9A%12%C9T</UserName>
<Password>%26%92y%7B%FF%A0%D2%83</Password>
</UserInfo>
</DataSource>
</DataSources>
<!--Output blocks-->
<Outputs>
<Output ID="Direct_DBMS.Results" Type="HTML"><![CDATA[<@assign
local$SQL_Results @@local$ResultSet>
]]></Output>
<Output ID="Results.Results" Type="HTML"><![CDATA[<center>
<P>
<BR>
<BR>
<FORM METHOD=POST ACTION="<@CGI><@APPFILE>?_function=sql&<@UserReferenceArgument>">
<TABLE BORDER=2 cellspacing=2 cellpadding=12>
<TR ALIGN=CENTER VALIGN=MIDDLE bgcolor=darkgray>
<TD>
<B><FONT SIZE=+1 face="Geneva, Arial, Helvetica">Execute SQL</FONT></B>
</TD>
</TR>
<TR ALIGN=CENTER VALIGN=MIDDLE BGCOLOR=gainsboro>
<TD>
<table border=0>
<tr valign=middle>
<td align=right>
<FONT SIZE=2 face="Geneva, Arial, Helvetica">
<b>SQL: </b>
</font>
</td>
<td>
<TEXTAREA ROWS=10 COLS=60 WRAP=VIRTUAL NAME="SQL"></TEXTAREA>
</td>
</tr>
</table>
</TD></TR></TABLE>
<P>
<INPUT TYPE=HIDDEN NAME="IE_BUG" VALUE=" ">
<INPUT TYPE=SUBMIT NAME="Submit" VALUE="Submit">
<INPUT TYPE=RESET VALUE=Reset>
</FORM>
@@local$SQL_Results]]></Output>
</Outputs>
</TAF>
