(previously posted in .formscoding group but got no responses)
Hi,
I have been using DAO and ADO for years to get at data from linked tables
and by accident I am finding a fault with ADO.
My query is below and the tables are SQL2005 tables. I am linked to all
of
them.
If I use DAO - Set rsMembers = CurrentDb.OpenRecordset(strSQL,
dbOpenDynaset, dbSeeChanges, dbReadOnly)
and get 0001 False 0
0003 Null Null
'correct
If I use ADO - rsMembers.Open strSQL, CurrentProject.Connection,
adOpenForwardOnly, adLockReadOnly, adCmdText
and get 0001 False 0
0003 False Null '
which is WRONG !!!!!!!!!! False should be Null
SELECT tblMembers.AcNo,
tblOver70Bals.Covered, tblOver70Bals.ShareBal
FROM tblMembers LEFT JOIN tblOver70Bals ON tblMembers.AcNo =
tblOver70Bals.AcNo
tblOver70Bals.Covered is a BIT field
tblOver70Bals.ShareBal is a currency field
If I open my own ADO connection using the SQLOLEDB driver directly to the
server it works correctly.
It seems that the JetOLEDB driver is not reading the bit values correctly
Can anyone explain please?
Any solution? I prefer ADO.
I may now have to go back and review mounds and mounds of queries.
Thanks
Brian


|