Sorting in QUICK?

[Kogan, Arthur]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_000_01BE7FC0.74FAE280
Content-Type: text/plain

Hi Charles.

I assume you are not using a relational database (as if you were, you would
not be asking this question). I have had a similar requirement. The way it
was achieved was as follows.

I had screen 1 prompting for selection values (in your case it does not look
like you need to prompt for anything). The screen then retrieved the
relevant records in a "while retrieving" loop and wrote the data into a
temporary indexed file, indexed in the required sorting order. Note: what I
mean by the "temporary" file is that a file defined in a dictionary was
created in this screen using "run command" code, and deleted on exit (or
another find). Once the temporary file was written, screen 2 was called
(which looked the same as screen 1). This screen had the temporary file
defined as primary and so displayed the info in the correct sorting
sequence.

Obviously this only works for "display" type screen, as "updating" would
need additional logic added to update the original files. Also the size (and
uniqueness, e.g. it should be created in the user's home directory) of the
temporary file should be taken into consideration.

Hope this gives you an idea.

Regards,

Arthur Kogan
Westpac Financial Services
Sydney, Australia 

> -----Original Message-----
> From:	Charles Lewis [SMTP:lewisc@swau.edu]
> Sent:	Saturday, 3 April 1999 3:37 AM
> To:	powerh-l@lists.swau.edu
> Subject:	Sorting in QUICK?
> 
> What I am trying to do may not be possible. Consider the following access
> statements:
> 
> file dorm-data primary occurs 16
>      access sequential
> select if date-in > 0 and date-out = 0
> file name-index reference occurs with dorm-data
>      access viaindex student-idnum using student-idnum of dorm-data
> 
> This will correctly display all current dorm students. However I would
> like
> to order this display sorted by NAME of NAME-INDEX (an index) or maybe
> even
> by GENDER of NAME-INDEX (not an index) by NAME of NAME-INDEX. Is there a
> way
> to do this in quick? If not, I may run a quiz report to disk, and pop the
> user into an editor...
> 
> chas
> 
> ====================================
> Charles Lewis
> Director of Administrative Computer Services
> Southwestern Adventist University
> PO Box 567
> Keene, TX 76059
> 
> Phone: (817) 645-3921 #220
> Fax: (817) 556-4744
> Email: lewisc@swau.edu
> ====================================
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.

------_=_NextPart_000_01BE7FC0.74FAE280
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IhcAAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAWAAAAUkU6IFNvcnRpbmcgaW4gUVVJQ0s/AKoGAQmAAQAh
AAAAQjdEN0E1ODFCMEVCRDIxMTg4NTYwMDAwODM2ODM1NjcA7QYBIIADAA4AAADPBwQABgAKAAAA
EgACAP4AAQWAAwAOAAAAzwcEAAYACQA7AAAAAgAmAQENgAQAAgAAAAIAAgABA5AGAHQMAAArAAAA
CwACAAEAAAADAC4AAAAAAEAAOQDQNJZGwH++AR4AcAABAAAAEgAAAFNvcnRpbmcgaW4gUVVJQ0s/
AAAAAgFxAAEAAAAbAAAAAb59MC2NqSJsfujfEdKeIAAA9rj6EQCjdXJAAAIBCRABAAAAmgcAAJYH
AAD/DAAATFpGdTbCnDcDAAoAcmNwZzEyNdIyAPszNgHoIAKkA+MJAgBjaArAc2V0MB4gBxMCgwBQ
EFZwcnHeMhFZDlAD1RFlfQqACMjsIDsJbw4wNRV/CmACgNkKgXVjAFALA2MAQQtgIm4OEDAzMwum
IEioaSBDEOFsB5AuCqKjCoQKgEkgYQQQdQeAHCB5CGAboBbgIG5v3QVAdQCQGTAboCAW4AtgzHRp
AiAHQCBkHZABoGsbsBwAKBuwIAaQHBN3mQSQZSwfBAhgbGQck5ZiHAAbsGsdAnRoBAAUIHEKUHMd
oikuIPsbkBDgdhwAEOAgMB1AAJDebQMQCsEW4CGAaRbgB4ATAjAiEFRoHAB3YXm/HtAFQCSQBCAA
0CFAZSJwryAwJQMEIAIQbAkAdxq+xyKiBPEJ4SAxIBKgA3C/BTAdAgIQBcAREBqQYx2i/CB2B0Ah
kR6QC4AcEgXA5mMeYiTRZG8HkRyiCQCkb2sr8GlrHARuCeC5IDB0byhlKQMAcHkhMX8ZMCIBJFIn
5SEwKCEW4HT/CIElki9xHVIlgABwBUAW4J0FoWQewQOgHUAidyFA1xqQL7YdASIr8nAuASWx/QNg
dBwAMGIeEjGhLTEdQD8z8CigBbAKwCSxM5BleP0loWYyMR+QNcYqcTBkI6O/J8EJER0CMWEEkCIQ
TjPhfjofQBDgBUAbkAeAA5Fi+ySwMGIiNSczEDZCHtAEIP8hMDmRHUA7YwEBC4A29B1A/mQN4B2j
NZElAifxHZA29schUSflHOQicnUDoAWg+m0DgWQzEAWgAQAfkDOCvwEAGpA+oinBNfAk0Sgt4y8c
sCRgBcA8wWQiAU9u/mM0BDUoO2MlAjPAJNAz8P5uH5An5RLQPiMHQBqQIDCeKDIRENAr8zA1c2Eb
8f8esSfmLpM/OCKiRD88iB6xvxKgB3A1gjOCOCA9YXMLUf55MDULgAIQNxYFoTExBUCfOCYRECGB
Q/Eay09iMtD5CGBzbDpCIVECIFHxH/BscmsmIgXAIk2VMxB0HHlwLuZBUQQgInVw/x4RMuMf9Szy
IrA9cB2lCQB+Zw3gVlItBFUTNAQFsGnfVzAd0jZCGrARUGxNYUhT3Gl6HoIzkUBQaVBSB5A2cx+Q
UKBnIhAk0XNovyADIJE+axwAHOAEkCcEIJ9cMBvxPXBPYgWweSk4kP8e8ErPLuFcNwGQLHADoDSz
3wWgAIEEgR2TGstIM1A0An8hUVcwInAEIBwjYWEBAGHxGstSZWcLEVtwGtoHELshMCrBS1cgAHAa
1FchofsKsFdQRljxQ/AHMQZSMtCvRAAQoBrjBrBkLOB5H5D+QRzgL+AHQAcwCuMbFgr0/yxQDzEY
wQFAKHEz8CmQEeRQMTYgLW4yT1jGTfFbUWFnZW4zGtZtRG0RgwsTbUZpLTE0NAFAcSxQMTgwAUAM
0HHTYmtowANhOgyDYhFAGlUgBkwH0CFRW1NNVFAmOhqQA/FjQAPgYXXyLgmAdV0a1XMABmACMLtz
ZwYQdAhwHhBqoTMRUDNMoQMgMTl4wHggOjPKNxFQTXY3VG9zZzVQ4R9RaC1sQCxQIbAasON1pnY4
dWJqKYF3CDg1gSpxUVVJQ0s/b9//cOpslAzQAcEYwRORE5IMAf9oBDmESKAhIDWQIPNNcS1A3wDA
JLAgVTVQBBBpAmBQoN8aQGHlMFMmRB0DY2nBaeX3IbA+kSPyc3NgGuk8VAWw7G0tNGNMpm+GoAhw
BCD7bgAa1CCLIoaUUCUdoAdAL4b1KWMe0lgiLSpxPiDfEUBBc42SCGAFQD2OEIhp3x3QB4CNwTXh
HVFmH2FD8v+KNQPwITCJCIrPKeAHMJBE/SGwdQEAAjCNwGpwG+Ac1f+UTF8hkg0a1EnDA/AmYE8m
/1HxTZUboJhSCHCQ4StSiTD/lDZZgWNwH1AicAXAG5Af9P8sUhrULTE4oyEkmSY4IiWhNToxTnlQ
RV8SnvItSfBOREVYWoI1tF8BBcCfg9EgkSWBZ+U6MUdFn9H+Up8+HKKgOJ7Pn9IiETvC/x9hHTEk
kZyXg6EhMypxI6H4Y2s/IiAe8ByhH5A5we8koUBCHUAjoXodUTVRBUD7g3IEAGtBVDVQM2AvcRrU
312yNKVCQVaBBbAurUAa2rcQ0WnlGtQ9rz+wTz0a1Jtz+xrURF6FXxJBZCMg/wMAavIdoCJxCFAo
oI7gQ0H7aX2O0WgfUCGwBJKzwKFx8x2gIbAgVQMAm5EAkFQAQRrUUE8gQm+QgDW0Njca1EsJ4R+B
VKAA0jcPQDU5GtpQXDAs4CE5UCg4MTdfADY0IDUtMzkyKFAjMjGB5kZheLuWFqA2Lew0N3HgGtRF
AMADEDlQ/3U9rt/BP7D8rnuPAcQfxS//xj/HT8eRafV8wATyIJA5UP4iG9DJJXqnMxAqcQeBb0Jv
IIAEcDpBg7JqMWEDcG//ez8a8reQycfJkUBQyc/K3P/MD3uOer91xDuiZhAz8CSRr0IDb3Akki0x
YiTQLtHTvWmBLtMWl4nR0juiYwkA/REQZB+QZ1E7wS1BhJCqU/cwYtHSH5RtauEggyLwyRYXOOAa
1BSRANzgAAADAP0/UgMAAB4AQhABAAAAKgAAADwwMDNmMDFiZTdkMmYkNmY0M2M1YzAkMDMwMDAw
MDRAc3dhdS5lZHU+AAAACwAAgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAeACCAGAAAA
AADAAAAAAAAARgAAAAAQhQAAAAAAAAMAI4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAB0EAAAHgAk
gAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAFAAAAOC4wMgAAAAADAA+ACCAGAAAAAADAAAAA
AAAARgAAAAABhQAAAAAAAAsAKYAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAMgAggBgAA
AAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADACuACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4A
OoAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeADuACCAGAAAAAADAAAAAAAAA
RgAAAAA3hQAAAQAAAAEAAAAAAAAAHgA8gAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAA
AAAAAAMAJgAAAAAAAwA2AAAAAAAeADFAAQAAAA8AAABLT0dBTkE0RENCNzgzOAAAAwAaQAAAAAAe
ADBAAQAAAA8AAABLT0dBTkE0RENCNzgzOAAAAwAZQAAAAAADAIAQ/////wIB+T8BAAAAYgAAAAAA
AADcp0DIwEIQGrS5CAArL+GCAQAAAAYAAAAvTz1XRVNUUEFDL09VPVdCQy9DTj1SRUNJUElFTlRT
L0NOPU1TTUFJTCBBRERSRVNTRVMvQ049S09HQU5BNERDQjc4MzgAAAAeAPg/AQAAAA4AAABLb2dh
biwgQXJ0aHVyAAAAHgA4QAEAAAAPAAAAS09HQU5BNERDQjc4MzgAAAIB+z8BAAAAYgAAAAAAAADc
p0DIwEIQGrS5CAArL+GCAQAAAAYAAAAvTz1XRVNUUEFDL09VPVdCQy9DTj1SRUNJUElFTlRTL0NO
PU1TTUFJTCBBRERSRVNTRVMvQ049S09HQU5BNERDQjc4MzgAAAAeAPo/AQAAAA4AAABLb2dhbiwg
QXJ0aHVyAAAAHgA5QAEAAAAPAAAAS09HQU5BNERDQjc4MzgAAEAABzBQhfwCvn++AUAACDCA4vp0
wH++AR4APQABAAAABQAAAFJFOiAAAAAAHgAdDgEAAAASAAAAU29ydGluZyBpbiBRVUlDSz8AAAAL
ACkAAAAAAAsAIwAAAAAAAwAGECSwTdYDAAcQcwgAAAMAEBAAAAAAAwAREAEAAAAeAAgQAQAAAGUA
AABISUNIQVJMRVNJQVNTVU1FWU9VQVJFTk9UVVNJTkdBUkVMQVRJT05BTERBVEFCQVNFKEFTSUZZ
T1VXRVJFLFlPVVdPVUxETk9UQkVBU0tJTkdUSElTUVVFU1RJT04pSUhBVkVIAAAAAB6F

------_=_NextPart_000_01BE7FC0.74FAE280--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.