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 SkipVought 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: *

  • Users: JimboNWUK
  • Order by date
  1. JimboNWUK

    VBScript Manual!?

    Oh-oh. I screwed up.... my hotmail addy is jim_ollerhead@hotmail.com sorry!
  2. JimboNWUK

    VBScript Manual!?

    I have an electronic copy of "VBscript in a nutshell" if you want it....it's in chm format (compiled html) email me at jim.ollerhead@hotmail.com with your addy and I will send it to you
  3. JimboNWUK

    Need SUM Formula

    Not sure what the exact SQLBase syntax is but I assume it is similar to Oracle: SELECT WORK_ORDER_ID, SUM(HOURS) FROM WORK_TABLE GROUP BY WORK_ORDER_ID would do it in Oracle assuming that WORK_ORDER_ID is repeated in the WORK_TABLE for each assembly. Jm.
  4. JimboNWUK

    Oracle sql

    I actual fact, if the columns are in the same table there is no need for a WHERE clause, just UPDATE TABLE SET COL1 = COL2 Jim
  5. JimboNWUK

    ORA-01555: snapshot too old - Problem with Rollback Segments?

    Well,Dave, I for one have copied and pasted your explanation into my personal 'Oracle Tips & Tricks' book! I've been an Oracle techo for over 18 years during which I have been an A/P, a trainer, dipped my toe into DBA-land, and currently am a systems support analyst and have never seen an...
  6. JimboNWUK

    Update Commit Loop Issue

    It is DEFINITELY the lack of a where clause that is your problem. Include ROWID in your select list and add WHERE ROWID=cursorname.ROWID in your update. In fact I would not even use a declared cursor here -- its's FAR easier to declare your statement at the top of the loop like so: DECLARE...

Part and Inventory Search

Back
Top