I created a dll in vfp.

I have a method ExecuteExcalar to execute sql queries. in the INIT of the class i am setting ANSI ON, for some reason the sql statement is returning rows even though the exact value does not exists in the table. it is just matching the first characters, I understand that ANSI ON makes exact string comparison and exact length.

I am instantiating this dll class in a visual basic 6.0 project, I have the same effect if I instantiate the dll class in VFP.

Now if I Instantiate the class in VFP from the PRG, not from the dll, it makes the exact comparison. I don't understan why.

Do I have to make something additional beside SET EXACT ON and SET ANSI ON?

Thanks in advance.