Peace to all:
Can someone please send an example of a 'Resettable Cursor' [1] in use?
I understand the use of scrolling, but ...
Wondering if the contents of a scrolling cursor can be modified during
processing between the WHILE sqlcode <> 100 THEN and ENDWHILE
statements.
I'm building time-series data for use in charting parallel data series,
and using a cursor to insert zero values for time periods with no data,
so that all the series align. When a year, say, is found to be missing,
I'd like to pop that missing year into the cursor's source table, then
have the cursor redefined "on the fly", so that the next
cursor-retrieved value may be evaluated relative to the newly inserted
value. Especially handy when there's a multi-year gap, when RELATIVE -n
would now have the right value to land upon.
Seems like the cursor needs to be reset for that to happen.
On the right track?
Ever grateful, Bruce
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
[email protected] | +011 (909) 238-9012 c | +011 (909) 912-8678 f
[1] As noted in From the Edge: "R:BASE Cursors Explained" (01/04/2021)
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/eme9daf667-df30-4b9b-bd6c-ce382dcc669e%40pathfinder.
