What up Tabi! If you're changing between tables the best way to do it (although there are some security issues) would be to write an actual transact sql script and use the sql action instead of a query/insert/update action and make the table a variable name in the script.
ie. if you have two identical tables that you want to use in different situations in your sql script you would have sql action with: select * from <@var request$tableName> as the script. To change Datasources completely you can populate the datasource portion of the sql/query/insert/update/delete query with variables. To do this, double-click on the datasource icon (the cylinder looking thing to the right of the icon representing the query type) in the editor and populate the fields with variables that represent the datasource name, database, username and password. This is kinda hard to explain without having my editor open, so if you still have problems contact me off list and I'll send you an example taf. Hope this helps! Cheers, Jonah Simpson On Sat, 26 Mar 2005 15:09:38 -0800, Roland Dumas <[EMAIL PROTECTED]> wrote: > IF you have a new datasource, including a change of brand of database, you > create that new dsn and then in the studio, you select all of your actions > in a taf, and then set the datasource to the new one. It does require, > however, that your tables and fields have the exact same names. > > If you're changing the table names, you **might** try opening a taf in a > text editor and doing a search/replace to find table names and change them, > but you're probably on thin ice. > > > On 3/26/05 2:51 PM, "Tabi Tubby" <[EMAIL PROTECTED]> wrote: > > > Hello there, > > How to change dsn, username/password, and tables from action in wi/tango > apps. > without having to copy or re-creating the whole application? > > What I mean by this is, once you create an wi/tango application then maybe > you > want to change the action's dsn, username,password, and tables in the apps > to use it for > a different database with different table names but the table structures > are the same. > > I'm not sure how to do it with the wi/tango dev studio but > I know how to do it manually with text editor (which i dont like to do). > > My wi/tango knowledge is average but i'm not a pro yet. > > Please help anybody when you got time. > > Thanks in advance. > > Tabi. > ________________________________ > Do you Yahoo!? > Make Yahoo! your home page > <http://us.rd.yahoo.com/my/navbar/sethp/*http://www.yahoo.com/r/hs > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > > > ----------------------------------------- > Roland Dumas > Roberts Information Services > 310 W. Bellevue Avenue > San Mateo CA 94402 > 650-347-1373 > 415-412-9300 (cell) > [EMAIL PROTECTED] > SMS: http://new.servqual.com/html/sms.tml > > ________________________________________________________________________ TO > UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
