ADO - returning different results rather then Query analyzer !!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 27 Dec 2005 11:00 GMT

Hi,

very strange thing happend today:
I wrote an sql syntax to query a sql server database:
"Select Count(*) From dbo.Func1() Where SomeCriteria"
From the sql server query analyzer i got results as a nameless column having
the value of 1

I took the SAME sql syntax and opend an ADO.Recordset using VB:

Dim Tmp as ADODB.Recordset
Tmp.Open "Select Count(*) From dbo.Func1() Where SomeCriteria",
CurrentProject.Connection, adOpenStatic, adLockReadOnly

I checked the value of Temp.Fields.Item(0) and it is now = 0 !!!

Cannot figure this out....

This is an Access XP file (.ADP) referencing the msado15.dll (ActiveX Data
Objects 2.8)

Ideas anyone ?

Reply to this Message

Douglas J. Steele - 27 Dec 2005 13:07 GMT

What does SomeCriteria contain? (it may matter...)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
>
[quoted text clipped - 19 lines]
>
> Ideas anyone ?

Reply to this Message

Daniel - 27 Dec 2005 21:01 GMT

SomeCriteria refers to a date column - RemindDate <='01/01/2005'
and it's the same on both querys.

Reply to this Message