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
|
|
|
|