Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bound Controls and a Stored Procedure w/one param 1

Status
Not open for further replies.

mpetre

Programmer
Jan 2, 2001
2
US
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.
 
did you ever figure this out? I'm having issues similar to yours and am having a difficult time finding documentation to help. thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top