% /* Connection Pooler */ var ConnectionCache = new ConnectionCache() /* server-side recordset */ var ClientsOntario = new Recordset("ClientsOntario", "MS Access 97 Database", "admin", "", "SELECT ClientsOntarioTbl.Société, ClientsOntarioTbl.Ville, ClientsOntarioTbl.CodePostal, ClientsOntarioTbl.Pays, ClientsOntarioTbl.Province, ClientsOntarioTbl.NuméroTél FROM ClientsOntarioTbl", "Société", true, 2, 3, 3, ""); ClientsOntario_BeforeOpen(); ClientsOntario.Open(); ClientsOntario.ProcessAction(); ClientsOntario.SetMessages("",""); /* server-side recordset */ var RCMaritimes = new Recordset("RCMaritimes", "MS Access 97 Database", "", "", "SELECT ClientsMaritimesTbl.Company, ClientsMaritimesTbl.City, ClientsMaritimesTbl.Province, ClientsMaritimesTbl.Country, ClientsMaritimesTbl.PostalCode, ClientsMaritimesTbl.Tel FROM ClientsMaritimesTbl", "Company", true, 2, 3, 3, ""); RCMaritimes_BeforeOpen(); RCMaritimes.Open(); RCMaritimes.ProcessAction(); RCMaritimes.SetMessages("",""); /* server-side recordset */ var ClientsPacific = new Recordset("ClientsPacific", "MS Access 97 Database", "", "", "SELECT ClientsPacificTbl.Company, ClientsPacificTbl.City, ClientsPacificTbl.Province, ClientsPacificTbl.Country, ClientsPacificTbl.PostalCode, ClientsPacificTbl.Tel FROM ClientsPacificTbl", "Company", true, 2, 3, 3, ""); ClientsPacific_BeforeOpen(); ClientsPacific.Open(); ClientsPacific.ProcessAction(); ClientsPacific.SetMessages("",""); /* server-side recordset */ var QcEastTbl = new Recordset("QcEastTbl", "MS Access 97 Database", "admin", "", "SELECT ClientsQuebecEstTbl.Company, ClientsQuebecEstTbl.City, ClientsQuebecEstTbl.Province, ClientsQuebecEstTbl.Country, ClientsQuebecEstTbl.PostalCode, ClientsQuebecEstTbl.Tel FROM ClientsQuebecEstTbl", "Company", true, 2, 3, 3, ""); QcEastTbl_BeforeOpen(); QcEastTbl.Open(); QcEastTbl.ProcessAction(); QcEastTbl.SetMessages("",""); /* server-side recordset */ var QcWestTbl = new Recordset("QcWestTbl", "MS Access 97 Database", "admin", "", "SELECT ClientsNordEstTbl.Company, ClientsNordEstTbl.City, ClientsNordEstTbl.Province, ClientsNordEstTbl.Country, ClientsNordEstTbl.PostalCode, ClientsNordEstTbl.Tel FROM ClientsNordEstTbl", "Company", true, 2, 3, 3, ""); QcWestTbl_BeforeOpen(); QcWestTbl.Open(); QcWestTbl.ProcessAction(); QcWestTbl.SetMessages("",""); /* server-side recordset */ var QcSouthETbl = new Recordset("QcSouthETbl", "MS Access 97 Database", "admin", "", "SELECT ClientsSudEstTbl.Company, ClientsSudEstTbl.City, ClientsSudEstTbl.Province, ClientsSudEstTbl.Country, ClientsSudEstTbl.PostalCode, ClientsSudEstTbl.Tel FROM ClientsSudEstTbl", "Company", true, 2, 3, 3, ""); QcSouthETbl_BeforeOpen(); QcSouthETbl.Open(); QcSouthETbl.ProcessAction(); QcSouthETbl.SetMessages("",""); /* server-side recordset */ var QcSouthWTbl = new Recordset("QcSouthWTbl", "MS Access 97 Database", "admin", "", "SELECT ClientsSudOuestTbl.Company, ClientsSudOuestTbl.City, ClientsSudOuestTbl.Province, ClientsSudOuestTbl.Country, ClientsSudOuestTbl.PostalCode, ClientsSudOuestTbl.Tel FROM ClientsSudOuestTbl", "Company", true, 2, 3, 3, ""); QcSouthWTbl_BeforeOpen(); QcSouthWTbl.Open(); QcSouthWTbl.ProcessAction(); QcSouthWTbl.SetMessages("",""); /* server-side recordset */ var MontrealTbl = new Recordset("MontrealTbl", "MS Access 97 Database", "admin", "", "SELECT ClientsMontrealTbl.Company, ClientsMontrealTbl.City, ClientsMontrealTbl.Province, ClientsMontrealTbl.PostalCode, ClientsMontrealTbl.Country, ClientsMontrealTbl.Tel FROM ClientsMontrealTbl", "Company", true, 2, 3, 3, ""); MontrealTbl_BeforeOpen(); MontrealTbl.Open(); MontrealTbl.ProcessAction(); MontrealTbl.SetMessages("",""); %> <% function ClientsOntario_BeforeOpen() { if (String(Request("NewCompany")) != "undefined") { ClientsOntario.AddBinding("Société", "NewCompany", "FRM") } if (String(Request("NewCity")) != "undefined") { ClientsOntario.AddBinding("Ville", "NewCity", "FRM") } if (String(Request("NewProv")) != "undefined") { ClientsOntario.AddBinding("Province", "NewProv", "FRM") } if (String(Request("NewCountry")) != "undefined") { ClientsOntario.AddBinding("Pays", "NewCountry", "FRM") } if (String(Request("NewPostalCode")) != "undefined") { ClientsOntario.AddBinding("CodePostal", "NewPostalCode", "FRM") } if (String(Request("NewTel")) != "undefined") { ClientsOntario.AddBinding("NuméroTél", "NewTel", "FRM") } if (String(Request("FormButton1")) != "undefined") { ClientsOntario.bPreserveInputState = true; ClientsOntario.SetAction("Insert"); } ClientsOntario.Open = DSNLessRecordsetOpen ClientsOntario.filename = "database/varidrape.mdb" } function RCMaritimes_BeforeOpen() { if (String(Request("NewCompany")) != "undefined") { RCMaritimes.AddBinding("Société", "NewCompany", "FRM") } if (String(Request("NewCity")) != "undefined") { RCMaritimes.AddBinding("Ville", "NewCity", "FRM") } if (String(Request("NewProv")) != "undefined") { RCMaritimes.AddBinding("Province", "NewProv", "FRM") } if (String(Request("NewCountry")) != "undefined") { RCMaritimes.AddBinding("Pays", "NewCountry", "FRM") } if (String(Request("NewPostalCode")) != "undefined") { RCMaritimes.AddBinding("CodePostal", "NewPostalCode", "FRM") } if (String(Request("NewTel")) != "undefined") { RCMaritimes.AddBinding("NuméroTél", "NewTel", "FRM") } if (String(Request("FormButton2")) != "undefined") { RCMaritimes.bPreserveInputState = true; RCMaritimes.SetAction("Insert"); } RCMaritimes.Open = DSNLessRecordsetOpen RCMaritimes.filename = "database/varidrape.mdb" } function ClientsPacific_BeforeOpen() { if (String(Request("FormButton8")) != "undefined") { ClientsPacific.bPreserveInputState = true; ClientsPacific.SetAction("Insert"); } } function QcEastTbl_BeforeOpen() { if (String(Request("FormButton3")) != "undefined") { QcEastTbl.bPreserveInputState = true; QcEastTbl.SetAction("Insert"); } } function QcWestTbl_BeforeOpen() { if (String(Request("FormButton4")) != "undefined") { QcWestTbl.bPreserveInputState = true; QcWestTbl.SetAction("Insert"); } } function QcSouthETbl_BeforeOpen() { if (String(Request("FormButton5")) != "undefined") { QcSouthETbl.bPreserveInputState = true; QcSouthETbl.SetAction("Insert"); } } function QcSouthWTbl_BeforeOpen() { if (String(Request("FormButton6")) != "undefined") { QcSouthWTbl.bPreserveInputState = true; QcSouthWTbl.SetAction("Insert"); } } function MontrealTbl_BeforeOpen() { if (String(Request("FormButton7")) != "undefined") { MontrealTbl.bPreserveInputState = true; MontrealTbl.SetAction("Insert"); } } %>