Devart Forums

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.

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

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.