-
1
- #1
I'm having a bit of trouble implementing a particular application. Here's my situation:
I have a program with one main form that displays many data-bound textboxes and masked edit boxes. As the form initializes, I'll prompt the user for an account number which will then be passed as the only parameter to a stored procedure. The results of the stored procedure are what I'd like to populate my textfields with.
The ADO data control is user friendly, but I couldn't work out a way to bind the controls to a stored procedure that requires a parameter - especially since the controls are created before the parameter is known. I've been tinkering with the Data Environment, adding my stored procedure as a command, and binding to this...But even though the controls say they're bound, they don't populate with data. I can print out the fields in the recordset member of the Data Environment by querying them in the Immediate Window, but they simply won't update the (allegedly) bound textboxes.
I'm working in Visual Basic 6.0 SP4. Any advice would be much appreciated.
I have a program with one main form that displays many data-bound textboxes and masked edit boxes. As the form initializes, I'll prompt the user for an account number which will then be passed as the only parameter to a stored procedure. The results of the stored procedure are what I'd like to populate my textfields with.
The ADO data control is user friendly, but I couldn't work out a way to bind the controls to a stored procedure that requires a parameter - especially since the controls are created before the parameter is known. I've been tinkering with the Data Environment, adding my stored procedure as a command, and binding to this...But even though the controls say they're bound, they don't populate with data. I can print out the fields in the recordset member of the Data Environment by querying them in the Immediate Window, but they simply won't update the (allegedly) bound textboxes.
I'm working in Visual Basic 6.0 SP4. Any advice would be much appreciated.