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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. skyleh

    FOREACH causing -201 SQL Syntax Error

    Never mind I found my problems. Thanks
  2. skyleh

    FOREACH causing -201 SQL Syntax Error

    Please excuse my ignorance. I am learning as I go. I am updating a program to combine like rows and I created a cusor and then want to loop back through and the rows back to the table after deleting the originals. My Foreach statment is getting this error. I commented eveything out and added...
  3. skyleh

    Combine Like rows

    Ok I am trying to make it harder than it is. I can do this.. SELECT Code, Sum(Percentage), Min(UniqueID) FROM myTable GROUP BY 1 Then delete the rows in myTable and do insert my results back into yourTable to make sure those rows are the only ones there. Thank you.
  4. skyleh

    Combine Like rows

    I need to modify a program and can't wrap my brain around how to do it. The program splits percentage spreads based on codes for a person. Sometimes the same code may show up twice and the program inserts two entries for the table for that code with two different percentages instead of...
  5. skyleh

    4GL INFORMIX Compare Column values

    Ok this may be a stupid question...so please excuse me as I am just back to programming and new to 4GL all together.. I need to modify a program and can't wrap my brain around how to do it. The program splits percentage spreads based on codes for a person. Sometimes the same code may show up...

Part and Inventory Search

Back
Top