CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 how to update two db in the same time with 1 form

Print topic Send  topic

Author Message
ami
Posted: 01/04/2002, 2:02 AM

i have two db one in www.1serveur.com and the same in www.2serveur.com and i want so that when i update the first the second will be update automaticly in the same time all this with one form.
thanks
i am waiting for response.
Nicole
Posted: 01/04/2002, 3:04 AM

Ami,
the solution requires some manual coding in AfterInsert or/and AfterUpdate events. You should close connection to first db, open connection to second db, create custom query to insert/update record in table from second db, execute sql query, close connection to second db and open connection to first db again.
Nicole
Posted: 01/04/2002, 3:04 AM

Ami,
the solution requires some manual coding in AfterInsert or/and AfterUpdate events. You should close connection to first db, open connection to second db, create custom query to insert/update record in table from second db, execute sql query, close connection to second db and open connection to first db again.
Nicole
Posted: 01/04/2002, 3:04 AM

Ami,
the solution requires some manual coding in AfterInsert or/and AfterUpdate events. You should close connection to first db, open connection to second db, create custom query to insert/update record in table from second db, execute sql query, close connection to second db and open connection to first db again.
ami
Posted: 01/04/2002, 11:06 AM

please more details and what about the form

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.