open more than one table

ok i saved the sproc but it does not work even when i open a new file and do the USE..GO...EXEC TEST. it says that it can't find it.

In QA, press F8 - opens an object browser on the left hand side.

Make sure that you have clicked for a NEW and empty QUERY window.

Find your table in the object browser - click the plus sign to open the branch - click the plus sign in front of STORED PROCEDURES.

You will see your procedure there. Sometimes QA has odd REFRESH requirements - but if you just get into QA, from EM, you should see your SPROC in the list.

Right-click on your SPROC - drag it into the QUERY WINDOW and let go of the cursor - choose EXECUTE from the little menu.

If all that works, you should be able to press F5 and run your SPROC.

ok that worked
great
now can i use SPROCE's to make my program run faster?

Quote:

---

Originally posted by szlamany
To answer your earlier question - this is how you would get the SPROC to execute from VB - using my GetAppEle_P example...

VB Code:

Dim objCmd As New ADODB.Command
Dim rsTemp As New ADODB.Recordset
 
    objCmd.CommandText = "GetAppEle_P"
    objCmd.CommandType = adCmdStoredProc
    
    objCmd.ActiveConnection = gCn
    Set rsTemp = objCmd.Execute

next lesson - SPROCS can have parameters

---

I posted this earlier - it's the ADO way to execute a SPROC and return a recordset.

Good luck...

so how would i display the results in the textboxes?
rstemp!field=textbox.text?

Well, I would think it would be more like:

text1.text=rstemp!fieldname

It's just a regular recordset though - it doesn't really know that it came from a SPROC and not an in-line SQL statement.

How do you take data from ADO RS's now and put them into things??

i use a simple display function, but if it the same as a normal rs then i wouldn't have to change that part of the code. i have some things to finish up here and then maybe i'll work on a SPROC for my app. thanx for all the help.