Can't Sort Hidden Fields


#1

I’m seeing that a procedure can’t select a hidden field (attempt generates an error) so one can’t sort a database on a hidden field. Double checking that I’m not missing something??


#2

I’ve never tried that so I’m not sure, but that doesn’t sound surprising to me.

It’s Christmas so I’m not going to test this, but I think you could use a secret window do do this.

window info("databasename")+":SECRET"
field "any field"
sortup

You didn’t specify Panorama 6 or X but I think both the problem and solution apply to both versions.


#3

Thanks! My question pertained to PanX. The key fact I was missing was that hidden field status is only applicable when the data sheet in on top. I couldn’t get the secret window approach to work, but opening a visible form at the beginning of the procedure and closing it at the end allowed the sort to work. I just used a simple form with a text display that says “Sorting…” Thanks for steering me in the right direction!!!