thanks sergey

what should be the latest timestamp of VFPODBC.dll ?
mine is 6-16-1998
i downloaded the mdac_typ.exe ( not installed yet ) from the link you suggested ( it is version 2.1 )
i have .Net beta installed on my computer and
the last time i remembered it is mdac 2.6 or 2.7
i'm confused now whether how to go about the latest VFP ODBC
please help ?

i found out what i'm doing wrong

when i used allt(c.kind)='FABRIC' in VFP IDE it gets me results
but when i tested 'FABRIC'$c.kind no records were found
but when i used allt(c.kind)=='FABRIC' ( double = )
there were no results
therefore single = returns results even for EMPTY(c.kind)
why is that ? ( i ask the same from cindy )

>>SELECT D.dr_no,A.po_no,A.desc,D.rate,B.percent ;
>>	FROM dr_etc   A ;
>>	JOIN po_other C ON A.po_no  =C.po_no ;
>>	JOIN delivery D ON A.ctrl_no=D.ctrl_no ;
>>	JOIN payetc   B ON ;
>>		STR(D.dr_no)+STR(A.po_no)+STR(A.job_no)+A.desc=;
>>		STR(B.dr_no)+STR(B.po_no)+STR(B.job_no)+B.desc;
>>	WHERE ALLT(C.kind)='FABRIC' AND A.job_no=101571;
>>ORDER BY 1,2,3