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?