Getting different results from Delphi/ADO/TADODataSet and from Query Analyser in SQL 2000

Sorry no solution, but I got the same problem. In my ADO - result set the first
row is missing.
Playing with cursor location didn't help very much. (Well it worked once and I
was happy but then the error occured again)
Might it be possible, that then MDAC - patch isn't installed properly ?
Is there a way to check that ?
Maybe we get some TeamB - support !?

marko.kinnu...@canaima.se schrieb:

Quote
> Hi,

> I am getting confused. I use Delphi 5 Prof + ADOExpress, with all the new
> updates, and also MDAC 2.6 against SQL Server 2000. I am accesing the SQL
> server with  a TADODataset component. Its created run time and the cursor
> location is client side. The query consist of some inner joins, IN and NOT
> IN statements.

> The strange thing is that the result set I receive in Delphi is different
> from the result set I get in Query Analyser in SQL server. (I get more and
> incorrect records in Delphi...)
> Does anybody know the reason??

> ///The query should return SITE data in AREA =1 that are not defined in AREA
> =2
> SELECT     *
> FROM         (SELECT ADB_2.ADB_ID, ADB_2.ADB_NAME, ADB_2.AREA_ID,
> SITE.TEMPLATE_ID, SITE.SITE_ID, SITE.SITE_NAME
>                        FROM          ADB ADB_2 INNER JOIN
>                                               SITE ON ADB_2.ADB_ID =
> SITE.ADB_ID AND ADB_2.AREA_ID = SITE.AREA_ID
>                        WHERE      (ADB_2.AREA_ID = 2) AND (ADB_2.ADB_NAME <>
> 'TEMP') AND (SITE.AREA_ID = 2) OR
>                                               (ADB_2.AREA_ID = 1) AND
> (ADB_2.ADB_NAME IN
>                                                   (SELECT     ADB_NAME
>                                                     FROM          ADB
>                                                     WHERE      ADB_ID = 2))
> AND (SITE.AREA_ID = 1) AND ((SITE.SITE_ID NOT IN
>                                                   (SELECT     SITE_ID
>                                                     FROM          SITE
>                                                     WHERE      AREA_ID =
> 2)))) DERIVEDTBL
> WHERE     (AREA_ID = 1)

> regards
> /Marko

> marko.kinnu...@canaima.se