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 bkrike 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 davidgoulet

  1. davidgoulet

    Inserted records from cursor are doubling up

    I'm are trying to insert invoice record in a table. Where the invoice has more than one line, I'm trying to write each line to a separate page in my journal table. Unfortunately page one need to be ' ', and the next page '001'.. '002', etc. I'm using an If statement to do this, but what is...
  2. davidgoulet

    Trigger with Cursor - performance issue

    TO kutty007 Tried you cursor, but get the following error when checking syntax - could figure out what the problem was. Error 8155: No column was specified for column 5 of '#T'. THANKS
  3. davidgoulet

    Trigger with Cursor - performance issue

    To: arrowhouse Multiple users are adding order lines all the time. Yes, there are many lines on each order. Tried you suggestion about adding redundant join - no improvement. Tried you second suggestion, but application returns an error message when I add second detail order line. No it...
  4. davidgoulet

    Trigger with Cursor - performance issue

    To: SwampBoogie Tried you suggestion, but application returns an error message when I add second detail order line.
  5. davidgoulet

    Trigger with Cursor - performance issue

    I am having a performance problem using a cursor. Looking for an alternative method, that I can understand. I have two tables: 1. On order header table (opheadm) and and order detail table (opdetm). I am trying to set the delivery method on the order header tables, based on the total weight...
See more

Part and Inventory Search

Back
Top