SORTEDCOL (OpenInsight 16-Bit Specific)
At 11 MAR 2003 06:02:16AM Colin Rule wrote:
Doing a SORTEDCOL with sort of 3 (ascending numeric) it fails to sort properly values with commas in the thousands (eg MD24, conversion).
All rather pathetic really.
Any suggestions for a resolution.
At 11 MAR 2003 06:38AM Richard Guise wrote:
The other pathetic "feature" of SORTEDCOL (and therefore the double-click sorting of popups) is that it sorts on display and not on data - and there is no option for the latter. Therefore date fields are sorted by text and not by date!!!!!!
If one stumbles on this sort of stupidity in front of a client (or, worse still, a prospective client) then one looks rather silly oneself, even if it is RTI's doing.
I found this out the hard way very soon after OI Ver 2 appeared. I wrote a fix for popups and use my own routines for edit tables.
I have mentioned these problems several times to RTI and even offered the popups fix. In the meantime they've included some other much less important correction in the popup routine. I don't want any mention, immortal fame or anything else!
The answer has been that to change an existing routine could affect users' existing code. This response is as pathetic as the fault. There can be no problem if one just adds extra options (e.g. to SORTEDCOL) without changing the existing ones.
There's none so deaf as those who don't want to hear!
RTI - why don't you sort these problems out at last?
Colin, if you or anyone else want the popups fix, email me at [email protected]
At 11 MAR 2003 06:51AM Richard Guise wrote:
Colin et al
In addition to the sorting of dates and the like, POPUP has other "features" and/or lacks of "features".
I've just checked and, if you have a look at one of my experimental web site areas at www.tornadopropsys.co.uk/toolkit, you should find descriptions of what I've found and kludges of what I've done.
I haven't touched that area for a couple of years or so - so I apologise for it - but if it helps …
At 11 MAR 2003 11:01AM WinWin/Revelation Support wrote:
Colin:
Popup sorting is fixed in 4.13
The trick was to modify the popup subroutine to
set redraw=0
use the array property to get the data
iconv the data
set the sorted col
use array to get the values
oconv
put it back
turn redraw back on.
If you are not going to upgrade to 32-bit, at least download 4.13, check out what we did, adapt for 16-bit.
Do check out Richard's stuff too – he has many good ideas.
HTH
Bob
At 11 MAR 2003 11:15AM Mike Ruane wrote:
Richard-
I believe that this is fixed in OI 4.1.3, which is available in the Works download section.
I also believe I told you this in the Works section some time ago.
Thanks-
Mike Ruane
At 11 MAR 2003 12:48PM Richard Guise wrote:
Mike
1) You may have told me in the Works section - but for some strange reason it's never worked for me - just kept crashing on me - so I never got your reply. I must try again with it some time.
2) Delighted to hear that something's now been fixed in POPUP. Which of the three "features" notified and kludged in my "toolkit" area - i.e. :-
a) sorting dates, etc.
b) distinguishing null select from abort in preselected popups
c) literal column spec ignored by POPUP
????
No doubt I'll see when I get the new upgrade
3) Can one sort dates, etc. properly also with SORTEDCOL? Maybe with additional options to sort using INVAL instead of display? No doubt this will emerge too when I get upgrade.
4) Also, I notified that deployment of runtime from early 32-bit OI (I forget which release) failed to work as quite a few of the DLLs, EXEs, etc. had no repository entries and therefore didn't deploy. Has this also been fixed in the latest or a recent release???
Thanks
Richard