Thanks, but I found the answer in the meantime.

SET CONCAT_NULL_YIELDS_NULL_ON wasn't working by itself (first thing

Thank you for your replies.

Apparently, the problem lies in the fact that, as you said, Giles, Windev & SQL Server have different ways to evaluate JOINs :

In Windev, the word...

A follow-up from myself (still trying everything I can think of) : the following query, under the SQL Server Query Analyzer (on the SQL database), produces the same results as the...

Try adOpenDynamic,adLockOptimistic instead of adoOpenDynamic,adoLockOptimistic .

Edit : Ok. Just thought the correct syntax didn't include the "o". (thought reinforced by the error message you were getting)

Otherwise, I don't know about...