L
Leo
I am having a problem with a relatively complex form I built for our quality
department. The form saves 10 calls to identically formatted tables: Due to
HR constraints, the fields are being saved more as data arrays housing a
single audit unit (with 10 units equaling a complete audit object) than as
normalized tables. This causes quite a few ADO calls to
Open.CurrentConnection, which I am sure is at the root of this.
Is there any way I can call the Open.CurrentConnection just once per form? I
have an idea to open a connection onCurrent, closing it onUnload.
Will this cause any issues with auditors moving from one audit object to
another?
department. The form saves 10 calls to identically formatted tables: Due to
HR constraints, the fields are being saved more as data arrays housing a
single audit unit (with 10 units equaling a complete audit object) than as
normalized tables. This causes quite a few ADO calls to
Open.CurrentConnection, which I am sure is at the root of this.
Is there any way I can call the Open.CurrentConnection just once per form? I
have an idea to open a connection onCurrent, closing it onUnload.
Will this cause any issues with auditors moving from one audit object to
another?