I would like to bind an ADODC data control to a control array. This way when I go to update a record or add a new one, everone will be happy🙂
Some background first...(simplified of course)...
I have a frame that holds a control array of text boxes called Talent(). There are five controls in the array.
I am filling the recordset which gets up to five records depending on how many acts were on the bill that day. This recordset sits in the ADODC and gets a new recordsource depending on which frame I am trying to display(other frames have ticket info etc, etc)...ergo I cannot bind at design-time.
I would like to bind the act field in each recordset to each consecutive control in the array. So in other words the first recordset("act"😉 binds to Talent(0) and so on.
The problem is that if I bind the ADODC to the control array all I get is the same value for all of the controls.
I'm thinking I will have to probably create an array that can update the recordset instead and do it by using code.
This of course would bind fine to a flexgrid or some such but I don't want the look of the grid. If I couldn't make the above work, could I bind the ADODC to a grid and extract the info into the text boxes?
Some background first...(simplified of course)...
I have a frame that holds a control array of text boxes called Talent(). There are five controls in the array.
I am filling the recordset which gets up to five records depending on how many acts were on the bill that day. This recordset sits in the ADODC and gets a new recordsource depending on which frame I am trying to display(other frames have ticket info etc, etc)...ergo I cannot bind at design-time.
I would like to bind the act field in each recordset to each consecutive control in the array. So in other words the first recordset("act"😉 binds to Talent(0) and so on.
The problem is that if I bind the ADODC to the control array all I get is the same value for all of the controls.
I'm thinking I will have to probably create an array that can update the recordset instead and do it by using code.
This of course would bind fine to a flexgrid or some such but I don't want the look of the grid. If I couldn't make the above work, could I bind the ADODC to a grid and extract the info into the text boxes?
