Professional Web Applications Themes

Update and Select Statement - Microsoft SQL / MS SQL Server

Hi to all, I have VB application calling a SP. It works when: --return this to application SELECT * FROM tblVariance WHERE VarianceID = VarID --update table UPDATE tblVariance SET NetworkID=NetworkID WHERE VarianceID = VarID return 0 I would like to see update values: I placed the update statement first. It doesnt work: --update table UPDATE tblVariance SET NetworkID=NetworkID WHERE VarianceID = VarID --return this to application SELECT * FROM tblVariance WHERE VarianceID = VarID return 0 any ideas. thanks...

  1. #1

    Default Update and Select Statement

    Hi to all, I have VB application calling a SP.

    It works when:

    --return this to application
    SELECT *
    FROM tblVariance
    WHERE VarianceID = VarID

    --update table
    UPDATE tblVariance
    SET NetworkID=NetworkID
    WHERE VarianceID = VarID

    return 0

    I would like to see update values: I placed the update
    statement first. It doesnt work:

    --update table
    UPDATE tblVariance
    SET NetworkID=NetworkID
    WHERE VarianceID = VarID

    --return this to application
    SELECT *
    FROM tblVariance
    WHERE VarianceID = VarID

    return 0

    any ideas. thanks
    hngo01 Guest

  2. #2

    Default Re: Update and Select Statement

    Try adding SET NOCOUNT ON to the beginning of your proc. If this
    doesn't solve the problem, please specify details of your symptoms
    rather than say 'it doesnt work'

    --
    Hope this helps.

    Dan Guzman
    SQL Server MVP

    -----------------------
    SQL FAQ links (courtesy Neil Pike):

    [url]http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800[/url]
    [url]http://www.sqlserverfaq.com[/url]
    [url]http://www.mssqlserver.com/faq[/url]
    -----------------------

    "hngo01" <hngo01hotmail.com> wrote in message
    news:0b9501c3417d$6f1d6260$a501280aphx.gbl...
    > Hi to all, I have VB application calling a SP.
    >
    > It works when:
    >
    > --return this to application
    > SELECT *
    > FROM tblVariance
    > WHERE VarianceID = VarID
    >
    > --update table
    > UPDATE tblVariance
    > SET NetworkID=NetworkID
    > WHERE VarianceID = VarID
    >
    > return 0
    >
    > I would like to see update values: I placed the update
    > statement first. It doesnt work:
    >
    > --update table
    > UPDATE tblVariance
    > SET NetworkID=NetworkID
    > WHERE VarianceID = VarID
    >
    > --return this to application
    > SELECT *
    > FROM tblVariance
    > WHERE VarianceID = VarID
    >
    > return 0
    >
    > any ideas. thanks

    Dan Guzman Guest

Similar Threads

  1. Select-And-Update in one statement?
    By Ignoramus23298 in forum MySQL
    Replies: 1
    Last Post: May 19th, 07:02 PM
  2. SP with Select statement
    By Gerald in forum ASP Database
    Replies: 3
    Last Post: November 27th, 03:38 PM
  3. help with SELECT statement
    By Chris Hohmann in forum ASP
    Replies: 2
    Last Post: August 19th, 05:10 PM
  4. SELECT statement
    By Simon in forum Microsoft SQL / MS SQL Server
    Replies: 23
    Last Post: August 18th, 01:12 PM
  5. SQL select statement problem...
    By Greg in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 2nd, 07:15 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139