Page 1 of 1

Sorting calculated CrGrid columns

Posted: Thu 10 Jan 2008 18:08
by DerPaul
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

Posted: Fri 11 Jan 2008 12:49
by Antaeus
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.

Posted: Fri 11 Jan 2008 14:44
by DerPaul
Hi

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

Poul

Posted: Fri 11 Jan 2008 15:12
by Antaeus
Please take a look at the TCustomDADataSet.Options.CacheCalcFields option. Probably it will be useful for you to increase performance of data ordering.