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??
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.
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!!!