Results 1 to 3 of 3

Thread: exec sql

  1. #1
    Join Date
    Feb 2006

    Unanswered: exec sql

    I need help understanding the syntax of the "exec sql" statement.

    i am looking at code that build an sql string such as

    sql="exec SOMETHING Session("id")"

    or something like that.

    then, there is


    My question is the "SOMETHING" in the sql what? I know it is user defined (object or variable or such), but what exactly is it? i look through the rest of the code and don;'t see SOMETHING defined elsewhere.

    i am not sure if i am asking the question right. i don't understand what the SOMETHING is doing, or why it is there.

    in particular, the code i am examining is

    sql="exec SurveyDelete "&"'" & Session("StudentID") & " ' "

    i understand the this statement will delete a record, but how does it handle "SurveyDelete", how does it know what the is when it is not defined anywhere else in the code?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 17
    I would wager that SurveyDelete is the name of a stored procedure in the database. Have a look there.

  3. #3
    Join Date
    Feb 2006
    i bet your right. thanks.

Posting Permissions

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