[Download-List] How To Retrieve The Record Number For A Multivalued Field

[Keith Wiggans]

We are using the query below to retrieve student registration records
expanded by status.

SELECT STUDENT.ACAD.CRED WITH STC.ACAD.LEVEL = 'UG' REQUIRE.SELECT
> DOWNLOAD STUDENT.ACAD.CRED \
> @ID \
> *BY.EXP.DSND* STC.STATUS STC.STATUS \
> STC.STATUS.DATE \
> STC.STATUS.TIME \
> STC.TERM \


Is there a way to extract the record number for the row, and the sequence
number for the status?
For example, Keith added, dropped and added a course. Is there a numeric
sequence that corresponds with each Add, Drop, Add entry, and how do we
access it?
Sincerely,

*Keith Wiggans **Systems Engineer* *zogotech *Toll-free: 888.221.6372 x
814 | Austin: 214.774.4780 x 814 | Fax: 512-469-6306
Email: kwiggans at zogotech.com | Web: zogotech.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20140423/8219edf8/attachment.html>