Sorting calculated CrGrid columns

DerPaul · Post by **DerPaul** » Thu 10 Jan 2008 18:08

Hi

I have a CrGrid with a calculated column. If I click the columns titlebar, instead of sorting the table, everything just hangs.

Is that correct?

Best regards

Poul

Antaeus · Post by **Antaeus** » Fri 11 Jan 2008 12:49

I could not reproduce the problem.
Please send me a complete small sample at sdac*crlab*com to demonstrate it, including script to create and fill table.

Also supply me the following information:
- exact version of SDAC. You can see it in the About sheet of TMSConnection Editor;
- exact version of your IDE;
- exact version of SQL server and client. You can see it in the Info sheet of TMSConnection Editor.

DerPaul · Post by **DerPaul** » Fri 11 Jan 2008 14:44

Hi

Turns out that it does actually work - it just takes a really long time.

Poul

Antaeus · Post by **Antaeus** » Fri 11 Jan 2008 15:12

Please take a look at the TCustomDADataSet.Options.CacheCalcFields option. Probably it will be useful for you to increase performance of data ordering.