Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Location
    peshawar
    Posts
    7

    Unanswered: probelem in view

    hi every1
    i am using sql server,vb and crystal report ;i have made stored procedure and sending variable through vb and crystal report to that pro but i want to do the same with view i.e i wanna use view instead of stored pro ;but i am unable to declare variable over there plz help me out and write a code that how to declare a variable over there
    thanxxx

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How are you access the view?

    Like SELECT Collist FROM myView?

    Why not just do

    SELECT Collist FROM myView WHERE Col1 = 'your criteria'
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How do you call your view...

    What parameter do you want to pass
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    consider creating an inline function that accepts a parameter and call that in a query.
    like a view with parameters

    [Books Online] user defined functions

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •