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
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.