NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: ianburgess on July 25, 2012, 11:48:19 PM

Title: Browse sorting - use of keys
Post by: ianburgess on July 25, 2012, 11:48:19 PM

In a NT browse you can set the sort order for each field when you click on column heading. My question is whether the browse uses a key if that is available in order to make the sorting more efficient.

Whether or not it uses a key will determine whether I create additional keys in the dictionary.

Thanks

Ian

Title: Re: Browse sorting - use of keys
Post by: Bruce on July 26, 2012, 02:25:17 AM

Ian,

the short answer is yes, it'll use the key if a suitable key exists.

A longer answer is that fetching the data in a web browse and a windows browse uses exactly the same engine (the clarion VIEW structure) and it is this View engine that is responsible for actually getting the data (using a key if it can.)

In NetTalk you don't specify the key, but in Clarion Windows you don't really specify the key either. In both cases the View engine picks whatever key it likes, or no key if it can't find a suitable key. The Clarion windows template gives you this illusion that you're picking a key, but you're really not.

cheers
Bruce

Title: Re: Browse sorting - use of keys
Post by: ianburgess on July 26, 2012, 05:18:04 AM

Hi Bruce

That clarifies things and means that I will create some additional keys.

Many Thanks

Ian