I have a stored procedure which pulls the cycle time data from the server and store it in a record set. I am wondering how to search for a Cycle Time based on the given step name.
This is a sample table column format: Step Name Cycle Time
Here is the part of the code that pulls the data and store it in a recordset.
Wondering how can I retrieve the Cycle Time for a given step name
Please Login or Register to view this content.
Thanks in advance, Anil
con.Open "DSN=BOOPS05;SRVR=BOOPS05;UID=ABC;password=xyz"
cmd.ActiveConnection = con
sql = "sel_CT_detail '" & Plant & "','" & Part & "'"
rs.Open sql, con, 2
This might not be the most efficient way to do this but couldn't you loop through the records and when the match is found return that record?
Please Login or Register to view this content.
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
Yes, I did it that way and it's working now. Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks