Invalid RecordCount within complicated query

Eventer · Post by **Eventer** » Fri 04 Nov 2005 07:39

Win2000 + D6 + dbxsda.dll v2.50.6.0
When executing enough complicated (tables more then 2 with inner and outer joins) query resultset is not valid. RecordCount is less then it has to be. What's wrong here? I've got this situation using TSQLCLientDataSet.

Ikar · Post by **Ikar** » Fri 04 Nov 2005 10:27

Please send to us (dbxsda*crlab*com) small test project to reproduce the problem; it is desirable to use Northwind objects otherwise include definition of your own database objects; don't use third party components

Ikar · Post by **Ikar** » Mon 14 Nov 2005 15:21

Thank you for your sample. It did help us very much.
Problem is in indexes and MIDAS. To avoid the problem just set poRetainServerOrder> flag in SQLClientDataSet.Options.