Exists i VB.net

Exists?
Can we see the SQL please?

You could also try selecting directly from the query in your .NET program. If your query in Access is named qrySelect then you can use

SELECT * from qrySelect

Dont know much at all about .NET but the problem may be because the SQL is being interpreted differently by the dB driver.

The SQL is quite nasty but here it is

SELECT *
FROM [SELECT Opgaver.Ansvarlige,Opgaver.Overskrift, Maanedsseddel.UdførtAf FROM Maanedsseddel LEFT JOIN Opgaver ON Maanedsseddel.Opgave = Opgaver.Id WHERE(((Maanedsseddel.DatoSenest) = date()) AND Maanedsseddel.UdførtAf IS NULL)

]. AS A
WHERE EXISTS (SELECT * FROM (


SELECT Logins.Initialer, Format(Last([Tid]),'dd/mm/yyyy') AS Dato FROM(Logins) GROUP BY Logins.Initialer HAVING (Format(Last([Tid]),'dd/mm/yyyy')=Format(date(),'dd/mm/yyyy'))


) AS B WHERE A.Ansvarlige LIKE '*' & B.Initialer & '*')=false;

I have alredy tried calling the query directly... same result :-(

http://www.firstsql.com/iexist3.htm

Maaby this helps u to solving it... i dont really understand it

Not easy to understand the SQL here, but is it possible to use IN instead of EXISTS?

I've had a very quick look at the link you gave, and as far as I can make out EXISTS can produce the wrong results if a column can return NULL.

but as far as i can see i don't have any null's in my testdata... i have tried using IN but can't figure out how to do it... maybe its not posible

Not easy to make suggestions when I dont know fo rsure what your trying to do.

When you use IN you must only select one field which normally will be a unique value for example the primary key. There is an example in the like you gave earlier.

WHERE  pno = 'P1'
AND    sno NOT IN
      ( SELECT sno
        FROM  sp
        WHERE  pno = 'P1'
        AND    qty = 1000) ;

The Sub select just selects all of the sno which the outer selects sno must NOT be in

You could also try each sub select to see if you can find out which one returns the incorrect result. Then maybe it will be easier to find the poroblem which may not be EXISTS

Problemet var at Access bruger * i like-sætninger og vb.net bruger %

but in your example you alreday used *!!!!

" .....AS B WHERE A.Ansvarlige LIKE '*' & B.Initialer & '*')=false; ...."