Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by vonehle

  1. vonehle

    DataReader Not returning rows

    Good for you, because I was wrong anyway. Lucky for me, your code tipped me off on how to fix something I was working on. So, thank you!
  2. vonehle

    SelectedValue coming up blank in listbox

    Nevermind. I needed SelectedItem instead.
  3. vonehle

    DataReader Not returning rows

    I'm pretty new to this too, but I think your problem is that the myReader.read() comes after the .HasRows. It will always not have rows before the read starts.
  4. vonehle

    SelectedValue coming up blank in listbox

    When I run my program, it fills up the listbox properly, but when I try getting the SelectedValue, it comes back empty. I tested it by having a msgbox pop up with just the SelectedValue. Can someone tell me why the value wouldn't work? Public Class frmCourseList Public strStudents As...
  5. vonehle

    Perhaps I have a Logic Error?

    You're the man, GHolden. Just a silly misplaced parenthesis. Thanks for your help!
  6. vonehle

    Perhaps I have a Logic Error?

    Price field is MONEY. I just tried changing it to FLOAT, but it didn't help.
  7. vonehle

    Perhaps I have a Logic Error?

    Tried it. Both price columns have the same value.
  8. vonehle

    Perhaps I have a Logic Error?

    The first three are $39.95, 35.95, 37.50 After executing, table Books and table BookPriceIncrease_ByMajor still have the same values they had before executing.
  9. vonehle

    Perhaps I have a Logic Error?

    By adding yours directly beneath the CREATE PROCEDURE block, I get the correct @MajorID returned, but the calculation still doens't happen.
  10. vonehle

    Perhaps I have a Logic Error?

    I like that little joke, GHolden. Do I have your permission to use that too? DROP TABLE BookPriceIncrease_ByMajor SELECT Majors.MajorID, Majors.Description, Books.BookID, Books.Title, Books.AuthorName, Books.pub_id, Books.BooksOnHand, Books.Price INTO BookPriceIncrease_ByMajor FROM...
  11. vonehle

    Perhaps I have a Logic Error?

    bborissov, cfstarlight, I've tried your suggestion, but the calculations are still not being done. I do not get any errors during execution, but none of the prices ever get changed, no matter how many times I execute it. I'm wondering if the calculation is even taking place.
  12. vonehle

    Query Help

    I believe you'll want a SELECT INTO statement to accomplish this. I'm pretty sure most people on this forum prefer you to post the code you've tried. Partly because if this is homework, they'd like to know you've tried it yourself, and not just trying to get others to do your homework for...
  13. vonehle

    Perhaps I have a Logic Error?

    As is, this code executes with no errors; however, it doesn't seem to be performing the calculation. I think this may be because the line SET @MajorID = MajorID is in the wrong place. Anytime I try to move it though, I get an error Msg 102, Level 15 State 1 Line 2. For the life of me, I can't...
  14. vonehle

    Creating new Table, filling it with data from other tables

    I'm not sure I understand how I could use the UPDATE because the SET would be different every time. Isn't SET static? Thanks for your help. I'm going to read up on the JOIN stuff again.
  15. vonehle

    Creating new Table, filling it with data from other tables

    I'm having trouble figuring out how to fill a table with data from 3 other tables. Here's a simple example... CREATE TABLE dbo.Transcripts( StudentID int, First_Name CHAR(20), Last_Name CHAR(20), Semester int, ClassID CHAR(5), Title CHAR(50), Grade int, Credits int, GPA...
See more

Part and Inventory Search

Back
Top