WARNING, WARNING, WARNING: Make a copy of ALL of your TAFs/TCFs before you begin, because if you do this incorrectly, you will no longer be able to open your TAFs/TCFs with the Developer Studio.
Having said that, if the column names are the same, and your datasource info is all that varies you can do something like this:
Create a NEW TAF using a select that calls the new database (database2) with the password and username. Save it. Open this new TAF with your text editor. COPY the whole XML segment from <datasource> to </datasource>. REPLACE the old database1 <datasource> section with this one.
Then do a global search and replace all instances of database1 to database2
On Mar 26, 2005, at 5:51 PM, Tabi Tubby 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
_______________________________________________________________________ _
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
