how to write a select query using a procedure name instead of a view name

  • i have written a select query using a view name which i pass to crystal reports through the crystal report control in vb 6. it works perfectly. it is as follows :

    "Select * from vRptListofMembers"

    vRptListOfMembers is the name of my view

     

    i now want to use a stored procedure named pListOfMembers instead of the view. so how should i word my select query ?

    thank you in advance for your help

     

     

  • Hi Janice,

    try this: "exec pListOfMembers".

    You don't select from a procedure in the same way that you can from a view. With procedures, you just execute them.

    Hope that helps,

  • thanks karl

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply