Help to Use PROP:SQL

29 columns… In browse yes, it could slow down the screen update but not the background process.

1 Like

90 columns, 29 columns?
How does one ever make such a browse client useful?
Hard for my old eyes to imagine.

No my dear. it is not hard if the fields contain codes or such. next I am using grouping in the browse that makes the browse looks like a form browsing. last don’t bother imagining people’s needs, it causes headache believe me.

1 Like

You could look at UltimateSQL class that has methods to help use Prop:SQL

https://www.clarionlive.com/Utilities.Htm

There are webinars on it if you search for: UltimateSQL

https://www.clarionlive.com/BrowseEpisodes/ww

I forked the old Repo and updated it to Feb 2022, so you can see the source here without installing:

3 Likes