I am having some problems trying to implement a few of the cool things I learned at DevCon 1999. I am building a VFP COM server to access VFP Data natively vrs ODBC. We have been using ODBC to access a VFP Database from Active Server Pages (Very slow!). The Active Server Pages are not slow but ODBC access to VFP is.

Anyway I am replacing the Data Access layer with a VFP COM Server. Here is the code I can't get to work

LPARAMETERS lcuserid
If ! used("Users")
use users in 0
endif
select * from users where userid = lcuserid into cursor ctemp
if _tally > 0
return .t.
else
return .f.
endif

This code works when I compile a regular win32 exe (I get a true return), but as soon as I compile it into a Multithreaded dll, the if _tally > 0 line returns 0 and I get a false return.

Is there some system functions that do not work when compiled as a COM MTDLL?

Thanks.

:>