Sorting a table

Home Forum General Sorting a table

This topic contains 0 replies, has 0 voices, and was last updated by  Anonymous 7 years, 2 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #813

    Anonymous

    I’ve read a bit in the older posts how PerfectForms is unable to sort a table populated from an external database. The workaround suggested was to create a table ‘view’ within the external database and sort it by whatever column you need. Then you would connect to that table to get your sorted table in PerfectForms.

    I may be incorrect in my understanding of the suggestion, but this method of selecting from a ‘view’ table doesnt work.

    Table “sorting” seems to be effective only when you execute a SQL query specifically requesting it to be sorted. That said, the PerfectForms connection command for “select” does not appear to have the option of sorting. Consequently, the creation of a sorted view table would not help unless PerfectForms can ask for it to be sorted.

    Has anyone found a reliable method of sorting tables that are populated from an external database? Even being able to sort on one column by default would be great.

    Thanks

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.