Sorting in Quick
Kogan, Arthur
akogan@westpac.com.au
Thu, 6 May 1999 11:00:22 +1000
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_01BE975C.AC12EF40
Content-Type: text/plain
Hi Joseph.
Quick itself does not provide sort functionality. If you want to retrieve
records in a particular order, you need to have an index in that order and
retrieve the records via this index.
Relational databases provide further functionality, where the query can use
the database sort to retrieve the data in a particular order without having
a supporting index. Depending on the number of records, this can be time
consuming. The Quick syntax supporting this functionality is "ORDERBY"
clause on the "access" statement. I repeat, this relies on the added
functionality provided by the relational database and so is only available
if your PH application is using one.
If you are not using relational database and can not add the appropriate
index, there is a workaround to provide this functionality. Jeff has
described one way of doing it. Another way (that I have used) is similar,
but gets it all done within Quick.
Create a temporary file with the appropriate index. Retrieve the records
from your file based on your selection criteria. Write them to the temp
file. Use this temp file as the primary file to get the records in the
required order. Have your actual file as secondary. Display/Update fields
from the secondary file on your screen. After you have finished, delete the
temp file.
Regards,
Arthur Kogan
Westpac Financial Services
Sydney, Australia
> -----Original Message-----
> From: Jeff Hoffman [SMTP:J.Hoffman@cchs.usyd.edu.au]
> Sent: Thursday, 6 May 1999 7:17 AM
> To: powerh-l@lists.swau.edu
> Subject: Re: Sorting in Quick
>
> I am not familiar with Turbo image, but I do not think it is a relational
> data base.
>
> So, 1 way of doing it is the use quiz (or qtp) to generate a subfile
> sorted
> in the correct sequence, only requires key fields, then in quick use this
> as the primary file linking to your data base.
>
> Good luck.
>
> At 01:24 pm 5/05/99 -0400, Joseph Rosenblatt wrote:
> >I am running version 8.09 on MPE 5.5 using a TurboImage database.
> >
> >I need to sort the data appearing on a QUICK screen by date. I must be
> >reading the manual incorrectly because there is no index listing for SORT
> >(other than to define what sort means). SORT appears to be a QUIZ and QTP
> >command only. What am I missing? Is there a way to sort in QUICK?
> >= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> >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.
> >
> >
> +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
> +-+
> + Jeff Hoffman + e-mail:
> J.Hoffman@cchs.usyd.EDU.AU +
> + Director +
> +
> + WoniCon Pty Ltd + ,-_|\
> +
> + 21 Prices Circuit + voice: +61 2 9542 1527 / \
> +
> + Woronora NSW 2141 + fax: +61 2 9521 3979 \_,-._*
> +
> + AUSTRALIA + v
> +
> +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
> +-
> +
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> 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_01BE975C.AC12EF40
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+Ih4BAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAVAAAAUkU6IFNvcnRpbmcgaW4gUXVpY2sA6wYBCYABACEA
AAA1QUJEMzJDRDQ5MDNEMzExODg2QTAwMDA4MzY4MzU2NwDmBgEggAMADgAAAM8HBQAGAAsABgAd
AAQAEwEBBYADAA4AAADPBwUABgALAAAAFgAEAAYBAQ2ABAACAAAAAgACAAEDkAYAQA0AACsAAAAL
AAIAAQAAAAMALgAAAAAAQAA5APCtc9Fbl74BHgBwAAEAAAARAAAAU29ydGluZyBpbiBRdWljawAA
AAACAXEAAQAAABsAAAABvpc91/3g9LIhAwAR054kAAD2uPoRAAcDjRAAAgEJEAEAAABcCAAAWAgA
ANMQAABMWkZ184VYfAMACgByY3BnMTI10jIA+zM2AeggAqQD4wkCAGNoCsBzZXQwHiAHEwKDAFAQ
VnBycd4yEVkOUAPVEWV9CoAIyOwgOwlvDjA1FX8KYAKA2QqBdWMAUAsDYwBBC2Aibg4QMDMzC6Yg
SBBpIEpvERBwaC4nCqIKhAqAUXUN4GsgBGl0ERBsZiBkbxkHkW5vBUASoG92aQkBACBzCREgZnVu
OGN0aQIgB0Ab4HkulCBJHDB5CGAgdwBwUQVAdG8gFuB0CIF2Nx1AFuAFoWQEIAuAIGHnHNAKwB3w
Y3ULYAXAIFHVBJAsHsNuCeBkH1IQ4K8f8QORC4ABAHggknQQ4P8FQCGjIxEigB+XI+AgCB0Q3yDQ
I+AEACNEGrtSHBAkAO8eAxxAJAABoGEREAQgHOa/HbAAICVwBcAduyHwdynhhSVEcQpQcnkgYwOR
/nURECVTKIYdVB9qLJYgn38kNAPwI+AIYAVAItELgGfhLyFzdXBwCRExEia07CBEGoAJ8GQxEgIg
JVPsbnUG0CRhbxwwICUh8P8mYywSM9AfUAdxLAACIDFwNm0xER6AVCVxG4Rzef0CMGEjkDF5JmMd
uxvQBCAAIk9SREVSQlleIiwAC2AsUjM1IgDQY5UHkHM6MHMBkHRlB4D/AjAegR+BMrAkADS1FuAe
QPMHkTM1YWQBACKAOKwc5f0igGIr8CVkJ/8kgx1gOXL9AiBsK/Ai4AtwC2ACYB1A5waQHsIFwFBI
LyAxkB5A3ywQHfI5cixQMvRlGrsepf8KwDOBHLFE9ECPQZUsEhyi/z5BPfQxkANgEqAHMDvwI0Sv
NLIrMiaBLzB3BbBrCsC/CGAkoR9hHOY4Xx5xSgER/yLBBCABAATyM9AigEVRHwHfK/A0ERxQMeM8
QUEcoSniPVASKCPjPHAi0yxRZClfOXIAkDYwIWEh8GIwsWf3ESAggUmBbChhT9MwcS8B9xuDHoAa
ykMW4EqiJkE8APcxoQrAK/BmAxBVBEnfMiX/J9Ak/ziBA2FDdFfzKMJPsv9DdBwBBZBEcwUBO/AH
IR6A/ldd0iVSW4AfYSViV1JX4/0egFUsYyaBX4cvIGChJXH/SnEAwFfGH2FUESVbI7MgAt0rsGkW
4SGUHoBIIuJDg/kA0HR1KFFhFhEQNeEogA8r4DJxBAALUXkvVXD3KIEpgQiQbFsmJWJm11fk/1yn
BQAJ4VEBAYAkYR7SItPrV/ADAHMlcGQh8AEAQyD3XpRfeSccZwsRNKAaygcQcyPgQ6FLb28gC5Aa
01fFB5B0CrBjIEYLgABwfmMHMQZSHRA7YRrEBrBkuyJQKuFBLFAfsB4xYRrK/xrICzAeQA8xGMEB
QBzhO/BDHeAR5DE2IC13kk+tBRBncfEDIE07cWFUED93kxrGdqR2cQsTdqZpLRgxNDQBQB5AMTgw
twFADNB7M2Jx0ANhOgyDdmIRQE6jSDQQBFADkVuAU01UUDpKLn2lYkA7UGhzLixQc3Au6QmAdS46
cF0axXxgBmDvAjB8xzaQCHBzKIAq4XdwEk1QITE5gqAgNzqUMTcRUE2AN1RvfMeFMaB3BJBoLWxA
HkA/O8B/UAPgOnB/soA4dWLual1RfMcn0DoGADG3NsT/eT96SnX2E5ETkgwBRgQvIPtbgByiZoww
AxAHMDBENoD/CHAG4BvQAMBUEFO0PHAcUP8ck1VCG8JLpEeoGsQusyjC9xq7h9Ah8DFQDjlyJWIs
Uu1kYXpR0AWxcXGQUvBio+8iUFegVwMxcGJX8x1iCYD/GsRj1QWhICEFQBEQK7Ed0O+OIUJjZEUE
IGtzoGhlSzP/IzKUYhuxLFQEABrEYW9DIX8eQI9QOBMfcEODkQ8a00d+bwRwnZAYQFXQb4sFQDAw
MToyNBzQW4A1L6YwoiCCsS0we1AwIfB3GlQH8REQbgJgJAAFQHfXdqJ8wBrTPowTch3AAwCPMSEf
8BEARII4LjCCwJEzMU1QRaIQLjVE5bsvMI2DSY3yKHcatT6kl/8iVi1kJXEupEQBPMAFEDMEwS8w
UVVJQ0tq1UAC+2giPFJtc/E1UaSVVtEy4/8lYgOBZhILgJflQoEz0CwQ/yxVS4QcoCNFhSIxEgIQ
BcD6UznAVKSVlMAp0yPhI8H/H3ABAQuAT/Ej8h1jB4AAcf4pHoCzIqt1YKEfcDVhrFO6WiSDUX5Q
pJUFoG0Dgf9PskKAXkEj8owxrdEEATER/j8ekJxzK0FL4VAhqmZVYuWsgj+klT0gvV++b79/v8CP
wPOklYaRT1SHsCKWMf9PVISHOjAvAQeBeKI1UARw27uzAMBqIFEDcG+FH6Sz/lU2AcKYHcDDP8RM
xX/Gj3+En4WkOXJvIDvwUBFPpC3du5ViUOHLU3KRLsympJX/NpAmgctSOXI6UBphbMFwYf+3AzGg
rhFfFctSIfSt9ZYEz09UZRCpHBrEKy3XL9g//9lP2l/a5dbFfUzdP9213FA/eNAAwAMQh7B+j3+R
RUTwVS5BVd6w2/ZngJgSvwWx4i/eG+QP5R/hCFcCIJZpCFADoFA5UUx0IoAH58/jv+ndLC1ffFxq
XOYLMpKgUAUQO2EgvkNkgCFAVGHtL+kDdlCQMztgh7ArNpKgEtA5NZo0EtAxDkCDECAv7VM/6yPm
SQNgHKBXoO1STlN2V+1T7BA0kqDob4ygeGPu6OwRMzk3gsDwYV8x6uAuXyrmGuDgU1TgUkFMSUHt
X+h/+T/9+dd25gra3/yv/b/+z/9V/+uV65TA/wIvAz8ET8Gbwn//yO/En8q/hZvHnwcfyb8Jj/+F
qsyvzb/Oz8/f0OXRb9J/V9OP1J/VqH11cAAaIAMA/T9SAwAAHgBCEAEAAAA4AAAAPDMuMC41LjMy
LjE5OTkwNTA2MDcxNzIxLjAwOWE3NDMwQHBvcC5jY2hzLnVzeWQuZWR1LmF1PgALAACACCAGAAAA
AADAAAAAAAAARgAAAAADhQAAAAAAAAMAB4AIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAj
gAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAAHQQAAAeACSACCAGAAAAAADAAAAAAAAARgAAAABUhQAA
AQAAAAUAAAA4LjAyAAAAAAMAD4AIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwApgAggBgAA
AAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAAyACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMA
K4AIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgA6gAggBgAAAAAAwAAAAAAAAEYAAAAANoUA
AAEAAAABAAAAAAAAAB4AO4AIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeADyA
CCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAAwAmAAAAAAADADYAAAAAAB4AMUAB
AAAADwAAAEtPR0FOQTREQ0I3ODM4AAADABpAAAAAAB4AMEABAAAADwAAAEtPR0FOQTREQ0I3ODM4
AAADABlAAAAAAAMAgBD/////AgH5PwEAAABiAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAABgAA
AC9PPVdFU1RQQUMvT1U9V0JDL0NOPVJFQ0lQSUVOVFMvQ049TVNNQUlMIEFERFJFU1NFUy9DTj1L
T0dBTkE0RENCNzgzOAAAAB4A+D8BAAAADgAAAEtvZ2FuLCBBcnRodXIAAAAeADhAAQAAAA8AAABL
T0dBTkE0RENCNzgzOAAAAgH7PwEAAABiAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAABgAAAC9P
PVdFU1RQQUMvT1U9V0JDL0NOPVJFQ0lQSUVOVFMvQ049TVNNQUlMIEFERFJFU1NFUy9DTj1LT0dB
TkE0RENCNzgzOAAAAB4A+j8BAAAADgAAAEtvZ2FuLCBBcnRodXIAAAAeADlAAQAAAA8AAABLT0dB
TkE0RENCNzgzOAAAQAAHMMCAMeZZl74BQAAIMEDvEqxcl74BHgA9AAEAAAAFAAAAUkU6IAAAAAAe
AB0OAQAAABEAAABTb3J0aW5nIGluIFF1aWNrAAAAAAsAKQAAAAAACwAjAAAAAAADAAYQJJeWdgMA
BxCUCgAAAwAQEAAAAAADABEQAQAAAB4ACBABAAAAZQAAAEhJSk9TRVBIUVVJQ0tJVFNFTEZET0VT
Tk9UUFJPVklERVNPUlRGVU5DVElPTkFMSVRZSUZZT1VXQU5UVE9SRVRSSUVWRVJFQ09SRFNJTkFQ
QVJUSUNVTEFST1JERVIsWU9VTkUAAAAAQfw=
------_=_NextPart_000_01BE975C.AC12EF40--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.